I am currently migrating a dashboard from Tableau to QuickSight. The Tableau dashboard uses a FIXED LOD calculation, and I am trying to replicate the same in QuickSight using sumOver(). However, the results are not matching.
In my example, there are 3 rows with a total of 565,351,988. When I apply a filter to exclude null values, I expect the total to remain the same (565,351,988), but it changes instead.
I have tried using both PRE_FILTER and PRE_AGG, but neither approach is giving the expected result.
Is there an alternative way to accurately replicate this behavior in QuickSight?
Hi @sandeeptota and welcome to the Quick Community!
I understand your mix-up here, migrations from Tableau to Quick can be tricky sometimes since there are a number of functions from Tableau that are not natively available in QS. Additionally, there are different scenarios that call for LAC-A or LAC-W calculations. Here’s a great article that helps with the breakdown of these scenarios:
What if you tried something like this: sumOver( sum({total_plays}), [{date_view}, {time_selection}, {content_type}], PRE_AGG )
If that does not work, you may want to consider moving this type of calculation to your dataset layer or handling through customSQL
