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?
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.
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.
@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: