Hi Team, Currently, I have one time control for users to choose the specific month end (eg 2025/05/31) and I could select the corresponding Last 2 Months to calculated the MoM Difference use formula: “periodOverPeriodDifference(count({Customer}), {Month End}, MONTH, 1)” for 2 consecutive month-e…

Hi @yezhehu Following calculations work fine without a date filter. However, period-over-period calculations cannot be used with a date filter. For the Value - Last Month End calculation, used to get the last value of the month is explained in this community post . Example: Value on Last Month Sa…

On the other words, I want to know how to visualize some value of a row (“May 2025”) and hide other value one (“Apr 2025”) without changing the filter conditions in Quick Sight.

Is there any solution to fix this problem? :sob:

Hi @yezhehu Please refer to the below article this might be helpful for you. [image] Creating period comparisons with QuickSight's periodOver and periodTo functions Articles This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author W…

Thanks for your help. By refering to the method you mentioned, I added a filter named Date Hider - formula: minOver(min{Order Date},[{Order Date}], POST_AGG_FILTER [image] but the Quick Sight shows that “it is missing in the field” [image] How could I fix this problem?

Hi @yezhehu If you can recreate this issue in Arena using sample non-sensitive data, I can take a deeper look to see what is going on. [image] QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community What's New / Blog [FeatureTile 11(2)] Wa…

Thanks for your help in advance. I have recreate this issue in Arena. Temporary Could you please help to fix these 3 calculation field: Diff-MoM-PoPD; Value-MoM-PoPLV; Value - Last Month End [image]

Hi @yezhehu Thanks for recreating the issue in arena. Could you please explain the issue and what you are trying to achieve?

[image] Xclipse: issue in arena. Could you please explain the issue and what you are trying to achieve? I am trying to set the calculation fields in pivot table in Quick Sight to show: the value of count{Customer ID} on the selected Reporting Date by the control(i.e. 2025/06/12) and the cor…

Hide the first periodOverPeriodDifference Value in a visual sheet

Q&A

Xclipse July 2, 2025, 6:46am 6

Hi @yezhehu

If you can recreate this issue in Arena using sample non-sensitive data, I can take a deeper look to see what is going on.

Topic		Replies	Views
How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual? Q&A error , quick-sight , calculations	13	3942	March 28, 2024
No data shown for last month when filtering for N months Q&A filters , quick-sight , pivot-table , Business-Intelligence-Engineer	4	542	January 10, 2024
Using Date Hider Q&A period-over-period , quick-sight , Business-Intelligence-Engineer	4	129	April 11, 2025
How to get difference value and the end-of-month values Q&A date , quick-sight , visuals , calculations , Business-Intelligence-Engineer	3	778	October 31, 2023
ERROR: periodOverPeriodLastValue : TABLE CALUCLATION ATTRIBUTES ARE MISSING and VISUAL_CALC_REFERENCE_MISSING Q&A developer , error , quick-sight	11	155	February 25, 2025

Hide the first periodOverPeriodDifference Value in a visual sheet

Related topics