Hi Team,
So I’m trying to replicate this calculation from Tableau to Quicksight but am not able to achieve the same figs.
In Tableau:
Fixed Revenue by Diff = { FIXED [Weeks from Release]: SUM([Revenue])}
Trying to achieve this via LAC in Quicksight, I’ve tried but I’m getting inaccurate values
Fixed Revenue by Diff=sumOver(revenue,[{Weeks from Release}], PRE_FILTER)
I’ve retained the filters as is - what am I missing?
Thanks,
Tanisha
Try using PRE_AGG instead of PRE_FILTER.
Without seeing example data, I suspect that the other titles are being summed along with Spider-Man: No Way Home.
PRE_FILTER Specifies to sum the revenue before the filters are applied, so your filter on Title doesn’t look to have an impact in this caluclation.
Let me know if this works for you, thanks.
Using PRE_AGG gives me the same value as the revenue for the title.
Yes, I’m hoping that my filter on title is overridden when calculating this field.
Should I be using a LAC-A over LAC-W or some combination of the two? Thanks!
