periodOverPeriodDifference calculation in quicksight

My fiscal year and quarter are custom as shown below and in string format:

FiscalQuarterName:

  • Q1 2024: Jul 2023 to Sep 2023
  • Q2 2024: Oct 2023 to Dec 2023
  • Q3 2024: Jan 2024 to Mar 2024
  • Q4 2024: Apr 2024 to Jun 2024

How do I calculate the period-over-period difference for the custom quarters mentioned above?

periodOverPeriodDifference(sum(BillableHours), ?? ,QUARTER,1)

Hi

You have to define the custom quarters and then have to find difference manually
like bill amount of Q1,Q2 and so, then find the difference between each quarter.

1 Like

Thanks for your response.
My requirement is to display the difference between quarter bills and add a conditional format dynamically saying if 10% increase than last quarter , mark it green or red etc…

For that you can use conditional formatting and add conditions as per your requirement.

Try using ‘Difference’ function
difference(
sum( {Billable hours} ),
[{Quarter} ASC],
1,
[{Any other aggregation field(optional}]
)

1 Like

Hi @Asfak,
It’s been awhile since we last heard from you. Were you able to try Gojo’s suggestion and did it work for your case or do you have any additional questions?

If we do not hear back within the next 3 days, I’ll go ahead and close the topic.

Thank you!

Hi @Asfak,
Since we have not heard back from you, I’ll go ahead and mark the solution. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!