Forum Discussion
stacked years on a time based line chart
Hello!
I am trying to get separate lines on top of eachother rather than the full time window. I've got 'year' as my Legend value but it still is appearing as one continuous line, when I am looking for a Jan-Dec window, with each year as a separate line:
This is what I am getting^^^^
THis is what I would like it to look like ^^^
Hi Anonymous ,
That is what I refer in the first step you need to add both day and month to your axis, this can be done using an hierarchy with both columns (day/month) or a single column that is day-month format.
3 Replies
- MFelix
Super User
Hi Anonymous
This is happening because you have your X-axis on continuous format, you need to:
- Add the month and day to the x-axis
- Add the year on legend
- Change the x-axis to categorical
- Turn off concatenate labels on the x-axis
Be aware that this will return all the days for each month so maybe it will not match the example you have in terms of agregation of dates but beleive is one of the options based on the information you have.
- MFelix
Hi Anonymous ,
That is what I refer in the first step you need to add both day and month to your axis, this can be done using an hierarchy with both columns (day/month) or a single column that is day-month format.