cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TeyaSax Frequent Visitor
Frequent Visitor

How to compare the data for January 2017 and January 2018 in one chart

How to compare sales data for January 2017 and January 2018 in one chart(clustered column chart)
If I use a date(axis) like a hierarchy, then the data is layered one on one. If the date is not hierarchical, then the data is compared, but they are unloaded by day. And I need to see the data collected by months.

1 ACCEPTED SOLUTION

Accepted Solutions
RolandsP Member
Member

Re: How to compare the data for January 2017 and January 2018 in one chart

I think I know where is the problem. In axis field, you should have the following Date hierarchy-  YEAR -> MONTH. And in the graph drill down till the month. But for drill use the last of three buttons on the top left corner (marked with red in attached picture).

Bez nosaukuma.png

7 REPLIES 7
RolandsP Member
Member

Re: How to compare the data for January 2017 and January 2018 in one chart

You need 2 following columns Month and YEar. Then you put Month on Axis and Year on Legend. 

TeyaSax Frequent Visitor
Frequent Visitor

Re: How to compare the data for January 2017 and January 2018 in one chart

It's impossible to use anything in the legend, cause  I use data from 2  different reports in the field value, legend in this case is not active.

RolandsP Member
Member

Re: How to compare the data for January 2017 and January 2018 in one chart

I don't really get the structure of your data - do you have values for 2017 and 2018 in separate tables? 

Could you show some sample of the data?

TeyaSax Frequent Visitor
Frequent Visitor

Re: How to compare the data for January 2017 and January 2018 in one chart

Screenshot_2.pngremade the report. now all the data in one report.
sorry for dullness, I'm new here.

RolandsP Member
Member

Re: How to compare the data for January 2017 and January 2018 in one chart

I think I know where is the problem. In axis field, you should have the following Date hierarchy-  YEAR -> MONTH. And in the graph drill down till the month. But for drill use the last of three buttons on the top left corner (marked with red in attached picture).

Bez nosaukuma.png

adamflath Member
Member

Re: How to compare the data for January 2017 and January 2018 in one chart

THIS!!  I had the same problem as the poster and for the past two days I could not find the answer.  Then I see this post pop up 45 mins ago and BAM, that 3rd button drill down solved it for me.  Thanks!   Time to celebrate for the day and go to lunch. 

Highlighted
TeyaSax Frequent Visitor
Frequent Visitor

Re: How to compare the data for January 2017 and January 2018 in one chart

thank you so much.