How to convert from time series to table?

Hi all, I would like to view my time series data as a table. The time series are stored in Graphite (version 1.1.10-1). We are running Grafana 8.5 in production, 9.3 in development

Metrics are roughly stored like this (where timestamp is equal for all of them)

timestamp metric value
2023-02-14 12:03:00 repositories.repo1.total_commits 15
2023-02-14 12:03:00 repositories.repo1.unique_clones 12
2023-02-14 12:03:00 repositories.repo1.total_clones 30
2023-02-14 12:03:00 repositories.repo2.total_commits 20
2023-02-14 12:03:00 repositories.repo2.unique_clones 50
2023-02-14 12:03:00 repositories.repo2.total_clones 78
2023-02-14 12:03:00 repositories.repo3.total_commits 93
2023-02-14 12:03:00 repositories.repo3.unique_clones 15
2023-02-14 12:03:00 repositories.repo3.total_clones 99

I want these metrics to be displayed as a table, in the following format

Repository total_commits unique_clones total_clones
repo1 15 12 30
repo2 20 50 78
repo3 93 15 99

I have been playing around with transformation. Also worked with Table and Boom Table (which behave quite differently from each other). But no luck thus far.

Any help or suggestion would be highly appreciated.


Hi @jaapjanswijnenburg,

Thanks for opening this post.

I have tried and also asked the team but this is not possible simply on the Grafana UI level as you need to do it on the Graphite query level.