Quarterly % Change

[Jeff2]

Good Morning, I have a percent change (or difference if it’s not available) visualization I am trying to build that I need help with.

I am trying to calculate the quarterly (and monthly) percentage change for the number of lesson views. Views are counted by counting the number of IDs. I have no problem getting the totals for the month/quarter but am stumped on percentage change. We have the following dimensions:

• Lesson View UUID (string)
• Lesson View Date (date dimension)
  Thank you guys in advanced. This is a cool little community you guys have here. It’s very helpful for a new quicksight user.

[Deep]

Hello Jeff,

Thank you for the feedback that the community Site is helpful.
I am not sure but please see this old post may be its helpful in your case as well.

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

hope this helps.

Cheers,
Deep