Hello,
I use a table visual, for each row i need a value of previous month (2 month ago- May in this case), value in relevant month (previous month- June in this case), and the change between them
How can i do that?
Thanks
Hi @InbalK,
To find the change in between months (or other time period), I would suggest looking in to the periodOverPeriodDifference calculation as that should be able to assist with what you’re looking to achieve.
To limit the dates shown in your visual, you can set up a filter using your date field and set the constraints of the time window.
I’ll include some additional information regarding period over period computations in QuickSight below but let me know if you have any additional questions.
1 Like