Dashboards & Visualizations

Formatted millisecond values in table time columns always zero

AndrewR
Loves-to-Learn Lots

I'm trying to format timestamps in a table in dashboard studio. The original times are values such as:

2024-10-29T10:13:35.16763423-04:00

That is the value I see if I don't add a specific format.

If I add a format to the column : "YYYY-MM-DD HH:mm:ss.SSS Z" it is formatted as:

2024-10-29 10:13:35.000 -04:00

Why are the millisecond values zero?

Here is the section of the source code for reference:

    "visualizations": {
        "viz_mfPU11Bg": {
            "type": "splunk.table",
            "dataSources": {
                "primary": "ds_xfeyRsjD"
            },
            "options": {
                "count": 8,
                "columnFormat": {
                    "Start": {
                        "data": "> table | seriesByName(\"Start\") | formatByType(StartColumnFormatEditorConfig)"
                    }
                }
            },
            "context": {
                "StartColumnFormatEditorConfig": {
                    "time": {
                        "format": "YYYY-MM-DD HH:mm:ss.SSS Z"
                    }
                }
            }
        }
    },

Any ideas what I'm doing wrong?

Thanks, Andrew

Labels (2)
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...