Dashboards & Visualizations

Formatted millisecond values in table time columns always zero

AndrewR
Loves-to-Learn

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!

Earn a $35 Gift Card for Answering our Splunk Admins & App Developer Survey

Survey for Splunk Admins and App Developers is open now! | Earn a $35 gift card!      Hello there,  Splunk ...

Continuing Innovation & New Integrations Unlock Full Stack Observability For Your ...

You’ve probably heard the latest about AppDynamics joining the Splunk Observability portfolio, deepening our ...

Monitoring Amazon Elastic Kubernetes Service (EKS)

As we’ve seen, integrating Kubernetes environments with Splunk Observability Cloud is a quick and easy way to ...