Hide the first periodOverPeriodDifference Value in a visual sheet

[yezhehu]

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-end values (eg. 2025/04/30 vs. 2025/05/31).

Here is my question: I find that the Diff by Month for “Apr 2025” is null because I previously filtered only “Last 2 months” to calculate the MoM Difference and no “Mar 2025” Data was filtered in (please refer to the two red rectangle above).

How could I hide the null part (i.e “Apr 2025” Part ) and show the current one month only (i.e “May 2025” Part) in this visual without changing my filter conditions?

Thanks for your help in advance~

[yezhehu]

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 QuickSight.

[yezhehu]

Is there any solution to fix this problem?

[Xclipse]

Hi @yezhehu

Please refer to the below article this might be helpful for you.

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,…

[yezhehu]

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

but the Quick Sight shows that “it is missing in the field”

How could I fix this problem?

[Xclipse]

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.

QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

[FeatureTile 11(2)] Watch this video for a 30 second intro to Arena. QuickSight Arena provides you with an embedded instance of QuickSight right within the QuickSight Community. Using Arena, you can: Explore creating QuickSight data visualization dashboards for free Publish dashboards to the Community Gallery to showcase your skills Include dashboards depicting your use case while posting questions in the Community Q&A Clone underlying analysis views of published dashboards in order …

[yezhehu]

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

[Xclipse]

Hi @yezhehu

Thanks for recreating the issue in arena.

Could you please explain the issue and what you are trying to achieve?

[yezhehu]

@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 QuickSight to show:
the value of count{Customer ID} on the selected Reporting Date by the control(i.e. 2025/06/12) and the corresponding value of count{Customer ID} on the last month end (i.e. 2025/05/30) and last month corresponding date (i.e. 2025/05/12)

In addition, I also want to set the calcultion fields to calculate the difference of value (count({Customer ID})) above between 2025/06/12 and 2025/05/31, and the difference of value between 2025/06/12 and 2025/05/12.

My issue is that the 3 calculation field I tried to set in Arena (Diff-MoM-PoPD; Value-MoM-PoPLV; Value - Last Month End) doesn’t work now.

How could I fix it?

[Xclipse]

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 Same Day - periodOverPeriodLastValue(count({Customer ID}), {Reporting Date}, MONTH, 1)

Difference from Last Month Same Day - periodOverPeriodDifference(count({Customer ID}), {Reporting Date},   MONTH, 1)