In the imagine you will see how the dataset when you click the table diagram shows the date and time format as a non epoch value. You will also see the column is set to date and format is set properly. Although, it seems the named Query over-rides the column properties. The thing is the named query is converting the t_stamp from epoch time already, and for some reason the table when showing the named query converts it back to Epoch automatically. If I alter my query to show the t_stamp natively, the table still shows it as Epoch.
You need to set
columns.0.field : DateAndTime
so that it can apply the rest of your settings.
Setting the field property for every column is usually a good idea.
1 Like
Thanks a ton, that was a simple fix.