Forum Discussion
hierarchy date doubt
Have you tried creating a hierarchy with year and month? Choose a line chart and put this hierarchy on the axis. To display what you want (year+month) in the X-Axis choose the third drill down icon on the top left of the chart ("Expand all one level in the hierarchy")
Alex
Hi Angel,
Assuming that you use a line chart the best way is to use the Month in the X-Axis and then the Year in the legend, that way you will get the two years in different lines.
Regards,
MFelix
Hi, MFelix
I can't use Year in legend becuase seller name is used it.
I want to show how prices have changed across all months from 2016 to 2017.
Anyway, thanks!!!
Have you tried creating a hierarchy with year and month? Choose a line chart and put this hierarchy on the axis. To display what you want (year+month) in the X-Axis choose the third drill down icon on the top left of the chart ("Expand all one level in the hierarchy")
Alex