Forum Discussion
Multi-Year Timeline
RobFlandersWhen you remove the year from the Date you are now asking to only see things in Month buckets so data from every Month of January will be groupd, every February etc, so in your case the values from May of 16 and May of 17 will be combined together in the 'May' data point.
If you stick with the Line chart with Year and Month levels selected and then use the Drill Down arrow you can go to the next level down. Be sure you use the correct Drill Down option!!!
robofski Thanks for the response - it appears I need to do as you say and "Expand all down one level in the Hierachy". However, I now have an image that looks like this:
Something is clearly wrong with the sequencing of a number of the months - not sure why.
RobFlanders Any chance you can share a sample of the data, that looks strange?
robofski No sorry - there's a reason the pictures are heavily cropped!
The plot appears to assume that January 2017 is directly after January 2016, and Dec 2016 is directly after Dec 2015. I'll try some alternative plots.
Thanks for your help!
I received similar goofy results when drilling down the date hierarchy.
What is the best way to handle this?
Thank you
