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.
Thanks,
Jacob