Time value when using Grouping to Matrix shows Unix time

Grafana Dashboards
1

Hello community,
I have the following table:
The table contains multiple instances, and each instance has a value calculated daily. I want to transform the Time column into the table’s title. I used Grouping by Metrics, and it works as I intended, but the time is displayed as a number (unix time) instead of the format (dd-mm-yyyy…).
Initial tables:

image
image617×530 30.2 KB

After I use Grouping by Metrics (It seems to be showing a number in Unix timestamp format):
image
image1143×321 29.4 KB

How can I adjust this format?
Thanks
Note: Transform data:
image
image1248×378 24.2 KB

1 Like
2

Hi @phuckhag2001

Have you tried this transformation? (placed after your other 2 transformations)

image
image1142×189 16.2 KB

3

The “Time Field” shows “no options found”; however, if I disable transform “Grouping to matrix” the “Time Field” will have one option, which is “Time”.

4

Can you use the Format Time transformation 1st, and place the others as #2 and #3, and see if that helps?

5

It worked, thank you very much.