-
What Grafana version and what operating system are you using?
*** Using Grafana OSS : Latest
-
What are you trying to achieve?
*** I am trying to achieve a table that starts at the bottom row, and then stacks newer values on top of it. (see below)
-
How are you trying to achieve it?
***I have read in my time-based data that includes the fields ‘Chapter’, ‘Score’, and a ‘Timestamp’
-
What happened?
-
** The graph below shows the original data.
- 1.The oldest data starts at the top of table. I would like to reverse the y-axis so the oldest data is at the bottom of the table.
-
- I would ike to remove the blank cells. The timestamp data is not relevant after I have the answers in the correct order.
I have started looking into 'heatmap’s and ‘status history’ graphs to see if this is possible without much luck.
order the data by date_time desc then using the tableplugin
Thank you for your help. Order by DESC brings me one step closer to the desired result. Any advice on how to have each column start with the first entry for that chapter? See images below:
Actual results with DESC order…
Desired results:
After sorting by descending order, I would no longer need to use the timestamp column.
chapt 2 has 3 4s, how does one know which one should be first? your issue is not grafana issue, it is datasource issue. is it mysql ? or postgres
It is a Clickhouse database. For chapter 2, the first score recorded would be the score for chapter 2 question 1. The next score recorded would be for chapter 2 question 2, and so on until there are no more chapter 2 entries.
The database has the following fields:
-time
-chapter #
-score
again it is a non grafana issue which you should probably check on a clickhouse forum.
but that said someone here might chime in. since we have no access to your database, please provide sample data as csv inline here like following (Not an image though)
chapter1, chapter2,date,score
5,5,2024-0601,3
etc
