Hi All,
i am trying to create a line chart, but my dataset does not contain a singular date field. Instead, it contains multiple fields of the dates, and I'm having a hard time figuring out how to build it into a line chart. the line chart should go by months and should sum up the total for each of the months.
Do i need to use a Master Calendar? and if so what field would i put as Date?
this is my data table
| Elements | January | February | March | April | May | June | July | August | September | October |
| Iron | 4 | 5 | 6 | 6 | 7 | 7.7 | 8.4 | 9.1 | 9.8 | 10.5 |
| Metal | 7 | 1 | 0 | 4 | 8 | 11 | 15 | 18 | 22 | 25 |
| Fiber | 4 | 7 | 5 | 6 | 7 | 7 | 8 | 8 | 9 | 9 |
| Sulphur | 3 | 5 | 2 | 2 | 2 | 1 | 1 | 0 | 0 | 1 |
i have attached a sample file
Please suggest a workaround or a possible solution!
thanks!
