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
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
