Dynamic Percentages of Total
Hello! I am trying to get a percentage total column to work within a beast mode calculation in a pivot table card. I'm using the OVER () function, but because I have dynamic date ranges in the table (ex: we're looking at last 30 days only) it seems to aggregate by the grand total instead, not considering date ranges.
Is there a way to calculate a "dynamic" percentage of total, meaning that the %s will change based on the date range filtered?
Here's the formula I am using:
SUM(`field`)/ SUM(SUM(`field`)) OVER ()