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