cancel
Showing results for 
Search instead for 
Did you mean: 

Showing last 12 months based on end date

dim4a91
7 - Data Storage
7 - Data Storage

Hello! I'm struggling to build the following logic for my report:

I need to show last 12 months data based on time frame selected. For example, if the user selects 04/2021 - 09/2022 time frame - the chart should only show 12 months before 09/2022.

Another example, if the time frame is shorter, lets say 06/2022 - 08/2022, show  12 months before 08/2022. 

Please help 😞

Screenshot 2022-12-06 at 13.52.33.png

1 REPLY 1

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @dim4a91 ,

Are you looking for something similar to this:

https://community.sisense.com/t5/build-analytics/how-can-we-show-previous-12-month-on-selecting-a-pa...

 

Thanks.

Hari