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
    Icon for Community Champion rankCommunity 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