Hi everyone, I’m trying to calculate the growth of GMV in the last quarter. To do this, I want to be able to calculate the total GMV for that specific month. [image] Based on the image above, the pivot table’s rows consist of client names and the columns consist of the delivery month with GMV for…

Hello @rohit_SB , depending on your company, it may be worth considering utilizing Athena to run queries on your data in S3. That would allow you to build out some tables and run aggregations in SQL then bringing those tables into Quick Sights as datasets. I know that is a few steps to add to the pro…

[image] rohit_SB: GMV for the last 3 month Hi Try this periodToDateSum - Amazon QuickSight periodToDateSumOverTime - Amazon QuickSight Regards, Naveed Ali

Hi Naveen, I tried doing this, but the GMV values I have are calculated based on the LAC-A function as @David_Wong suggested earlier. The issue is that I can’t combine LAC with periodOverPeriod or periodToDate functions. Do you have any solutions?

Hello @rohit_SB , my apologies for the delayed response. I know I have worked with you on a few of your calculations more recently, is this something you are still seeking a solution for? With all of your calculations issues, I am starting to think that you may want to try and build your dataset usin…

Hi @WLS-DM , This ties in with the previous MoM calculations I wanted to do. This is still something I need a solution for. However, we’re dumping all our data on Amazon S3 through ElasticSearch (if I’m not mistaken) and there’s no way for me to change any data (such as making aggregations) pre-Quick…

I can bring it up with my supervisors and discuss this option with them. To me, it’s fine as long as it fits the company’s goals and data requirements. Thank you, i’ll update this thread soon!

Hello @rohit_SB , I appreciate the update! Let me know if you have any further questions, but I think this will give you a lot more flexibility and make it a lot easier to build out the metrics you require.

Calculating sum from a specific period of time

Q&A

rohit_SB January 8, 2024, 4:48am 4

Here’s something I did after looking at this thread
I created a new calculated field with the following formula: periodOverPeriodDifference(maxOver(max({GMV (USD)}),[orderID]),deliveryDate,MONTH,1)

However, this does not work either

Topic		Replies	Views
Calculating MoM growth and Churn risk with varied filters Q&A analysis , filters , error , quick-sight , visuals , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	8	423	January 17, 2024
PeriodOverPeriodComparison - Desenvolvimento QuickSight Q&A analysis , error , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	2	40	November 19, 2025
Calculating MoM growth without referencing date range in visual Q&A analysis , filters , error , period-over-period , quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	6	298	February 6, 2024
How to use periodOverPeriodDifference with multiple aggregations Q&A quick-sight , calculations	3	478	March 28, 2023
Show total sales for last 3 months in separate coloumn Q&A developer , quick-sight , qls-dev-resources	5	628	December 13, 2023

Calculating sum from a specific period of time

Related topics