I would like to create a trend reports which shows results over months. It must be easy but I cannot figure it out… In the table, the months are columns. The results per items are in each cell. The data collection looks a bit like this table. Each month people enter the numbers per items in the column of that month.
July 2024
August 2024
Sept 2024
Oct 2024
1
2
5
10
50
20
30
10
400
100
200
250
I like to create a graph (possible per row in the table), of a trend line of the numbers per month. So x-axis is the month (which is the column name) and y-axis is the number in the cell.
Hi @Juudt
If you want to create a chart in which the month is on x-axis and the values of items on the y-axis, There should be a change in the format. Monday don’t support this kind of data set(You have Provided) to reflect on the chart.
Instead you should create data set by taking this data set’s transpose. And for the chart you can use tags for each month. This will give you better visibility.