Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Last 4 quartes trend

Hi All,   I would like get  X Axis as last four quarters based on the today's quarter and year (current quarter and 3 quarters before) . Example 1): when today is October 22, 2019 i want to show Q...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Mariusz !

    It works)

    I have one small question - is this Date Dimension Table dynamic and based on today's date? 

    For example:

    Today is Decуmber 31, 2019 and rYearQuarter = 0. 

    Tomorrow will be January 1st, 2020 and what rYearQuarter for that date will be when i'll open my report: 0 or 1?

    1) 0 (because table is dynamic and changes everyday)?

    2) 1 (because table is created once and it is static)?

     

    Many thanks for your help!

     

    Regards,

    Oleh

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      The table is dynamic and it will change every time you refresh the dataset, so yes in Jan 2020 the rYearQuarter will be 0.

       

      Best Regards,
      Mariusz

      Please feel free to connect with me.
      Mariusz Repczynski