I’m having trouble with bringing in two measures that have different time grains. What do I mean by that? I have an example dataset that has the number of tickets sold by day, but the goal is at a monthly level. In IBM Cognos, we would mark the date as a “time dimension”, and then tell it what to…

Hi, You can use LAA to calculate at the required granularity and use POST_AGG_FILTER for visual calculations sumOver - Amazon QuickSight The sumOver function calculates the sum of a measure partitioned by a list of dimensions. Order of evaluation i…

Hi, please follow the period to over date functions as QS support lot of function. You can explore some others as per your requirements. periodToDateSumOverTime - Amazon QuickSight Use the periodToDateSumOverTime function for calculated fields in Amazon QuickSight analyses. …

Why is monthly_goal being aggregated as Average? [image] It should be Sum and that should give you the same figures you are expecting.

Darcoli setting monthly goal to Sum does not do what I want it to, now my summary for the month is 400k, I want it to be 100k for Jan/cricket, 80k for Feb/cricket, 170k for Jan/soccer, 200k for feb/soccer [image] The issue that I’m having a problem is that I’m mixing my time dimensions on my val…

Naveed, I’ve tried a dozen different formulas of PeriodToDateSumOverTime and am failing miserably. I can’t get it to add soccer (100k) and cricket (80k) for Jan 2022 to come up with a jan subtotal of 180k . Needless to say February’s monthly numbers are wrong and February’s YTD are off because I …

[image] Koushik_Muthanna: sumOver(min({monthly_goal}),[sport,{sale_date}],POST_AGG_FILTER) That did it. I think I had tried sumOver, but not with Post_agg_filter. I was even able to add a % [image] Thanks

Also, the avg also works, as in [image] Think of the instance where a new section of the stadium is approved for occupancy by the local jurisdiction mid month. Mgmt will want to sell the seats for the remainder of the month, so the monthly goal was increased for the last 15 days of the month.

Budget vs actual (different time grains)

Q&A

Koushik_Muthanna April 19, 2022, 9:40pm 6

Hi,

You can use LAA to calculate at the required granularity and use POST_AGG_FILTER for visual calculations

Calculated Field to test : monthly_goal_post_agg

sumOver(min({monthly_goal}),[sport,{sale_date}],POST_AGG_FILTER)

Below Screenshot :

Regards,
Koushik

Merging Actual vs Planned data from 2 different data sources

Topic		Replies	Views
How to use periodOverPeriodDifference with multiple aggregations Q&A quick-sight , calculations	3	499	March 28, 2023
Single Sheet with Different time period aggregation Q&A filters , quick-sight , calculations	1	355	August 18, 2023
URGENT - Wrong aggregation for sums Q&A formulas , error , period-over-period , quick-sight , calculations , reports , Business-Intelligence-Engineer	4	90	May 14, 2025
Subtraction between monthly and daily values Q&A quick-sight , calculations , Business-Intelligence-Engineer	8	538	October 24, 2023
Calculating sum from a specific period of time Q&A analysis , formatting , quick-sight , level-aware , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	8	1317	February 14, 2024

Budget vs actual (different time grains)

Related topics