I’m recording a timestamp formatted as unix seconds in a custom event. Using Insights data formatter I convert the seconds to a timestamp. Everything looks correct here.
Now I would like to display this value on a dashboard.
Querying the data as JSON looks fine as well:
results": [
{
"events": [
{
"timestamp": 1596181671406,
"timestampOfOldestMessage": 1596181663.931011
}
]
}
]
But if I query it as a table I get this:
I query nothing unusual: SELECT timestampOfOldestMessage FROM Outbox
Am I missing something here? Why wasn’t timestampOfOldestMessage
correctly formatted, but timestamp
(as a built-in feature) was?
Is the issue related to the comma? But why would it work then in the data formatter?
Thanks and best regards!