Period Over Period Alternate solution

Q&A
, ,
1

I have data for a metric for different countries at quarterly level. I want to use this measurement end date i.e. quarter end date to calculate ttm. I have tried sumover and periodtodate options for the same but, unable to achieve TTM. Anyone has tried this before?

2

Hi Geetha,

Welcome to the Quick Sight community.

Are you looking to calculate training twelve month calculation. Can you please elaborate on requirement with example dataset/output. You can also reference prior question in community on TTM topic. Count of Trailing Twelve Months - On Filter

Quick Sight Arena QuickSight Arena -- An embedded instance of QuickSight within the Community can help you to share mock dataset and analysis if you can share an example with us.

Regards,
Anwar Ali

3

Screenshot 2023-12-04 at 12.03.29 PM
Screenshot 2023-12-04 at 12.03.29 PM948×508 80.8 KB

Thanks Anwar!
This is a sample data of what I am trying to build. This would help me to find delta between given quarter date and TTM output.

4

Hello @Geetha and @AnwarAli !

@Geetha are you still having trouble with this problem or were you able to find a solution? If so could you post your solution to help the community?

Could you share an anonymized view of the calculations that you attempted?

You could also try the solution posted here:

5

Hello @Geetha and @AnwarAli !

@Geetha were you able to attempt the solution in the link I posted above? It has been some time since there has been activity on this thread but we would still like to help find a solution.

If we do not hear from you in 3 days this topic will be archived.