Forum Discussion

zimmermanaric's avatar
zimmermanaric
Helper I
10 years ago
Solved

Prior 12 Months

I am trying to show a column chart that has the past 12 months of sales in each bucket shown by month with the capability to drill down to the data. Any thoughts are appreciated!
  • zimmermanaric's avatar
    zimmermanaric
    10 years ago

    Actually, I just received the notification that the August update is out already and I believe thta the "Continuous Date" that they provided in this update is what I need. I will open another thread if not. Thanks for your help!

zimmermanaric's avatar
zimmermanaric
Helper I
10 years ago

Actually, I just received the notification that the August update is out already and I believe thta the "Continuous Date" that they provided in this update is what I need. I will open another thread if not. Thanks for your help!

kcantor's avatar
kcantor
Community Champion
10 years ago

zimmermanaric

I accomplish this task by creating a Year-Month column on my date table to cross over the year threshold.  It is simply year-Month=[Year]&"-"&FORMAT([Month], "00"). The result is usable on the axis. It appears as 2016-01, 2016-02 etc and can cross over the year threshold with no issues.

Just in case the update did not solve this for you.