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!

Index This | How many sides does a circle have?

  March 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

New This Month - Splunk Observability updates and improvements for faster ...

What’s New? This month, we’re delivering several enhancements across Splunk Observability Cloud for faster and ...

What's New in Splunk Cloud Platform 9.3.2411?

Hey Splunky People! We are excited to share the latest updates in Splunk Cloud Platform 9.3.2411. This release ...