Forum Discussion

Angel's avatar
Angel
Resolver III
9 years ago
Solved

hierarchy date doubt

Hi, everyone

 

I think my question is simple. 

 

If I select two years, ¿is there a way using only date hierarchy to show in a continous line all months from 1 year and then the other months of other year? (x-axis).

 

I know I can do that using calculated column to concatenate Year+Month, but ¿is there another way?.

 

Thanks,

Need Help
  • alexvc's avatar
    alexvc
    9 years ago

    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

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    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

    • Angel's avatar
      Angel
      Resolver III
      9 years ago

      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!!!

      • alexvc's avatar
        alexvc
        Resolver I
        9 years ago

        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