Period Over Period Alternate solution

[Geetha]

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?

[AnwarAli]

Hi Geetha,

Welcome to the QuickSight 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

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

Regards,
Anwar Ali

[Geetha]

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.

[duncan]

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:

Trailing data for Q

Hi I think we can only set the absolute value for the date field in the filter. If that’s true, what should I do if let’s say if I type TTM, then Q will know to look at the order_day field and filter for 12 month until the latest complete month (so Sep-Aug if I do it today). TIA!

[duncan]

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.