Forum Discussion

pauliuseg's avatar
pauliuseg
Icon for Helper I rankHelper I
5 years ago
Solved

date hierarchy - year & Quarter issue

hi, i have date hierarchy, i can drill down - Year, Quarter, month. - all OK. but i can't get to Year+Quarter. and i have other report where is done so, but i cant do it in my report. how is in g...
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, 

Please correct me if I wrongly understood.

 

If you can see your Calendar Table (or Dates Table), 

- find a Year 

- right-click the mouse

- create a hierarchy

- find a Quarter

- right-click the mouse

- add into the hierarchy

I added a link for a short video.

 

I hope this is what you are looking for.

 

Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos, Press the thumbs up button!!

 

https://drive.google.com/file/d/18vlvgv3ri0coCpAFO8SKxuV3LCZ1GWI7/view?usp=sharing 

  • pauliuseg's avatar
    pauliuseg
    Icon for Helper I rankHelper I
    5 years ago

    thanks, i have a working hierachy, and what i can't do - to display in a bar chart Year& Quarter

    i can see year, i can drill down to Quarter.

     but no Year-Quarter.

    means  Y 2019  Y 2020

    or Q1 Q2 Q3 Q4

     

    but i cant 2019Q1,2019Q2,2019Q4...

    i quees i need to create new dimension including Year-Quarter column. ..

     

    strange is that , that i have a file which can use Year-Quater, means show it, event usind same date hierarchy,

     

    paul.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Hi, pauliuseg 

      If it is OK with you, please share the file then I can try to have a look.

      Thank you very much.

      • pauliuseg's avatar
        pauliuseg
        Icon for Helper I rankHelper I
        5 years ago

        sr, i can't . i will try to create hierarchy from begininig again.

        as strange.. 

  • pauliuseg's avatar
    pauliuseg
    Icon for Helper I rankHelper I
    5 years ago

    thanks , yes, it's both solutions, need to create new hierarchy and ten you can add as many dimensions as you want , joining them together.