Values changes upon selections

[LoKi_asterix]

Hi all,

I’m using the following in my load script:

Count(DISTINCT ID) AS CustCount

Grouped by ID and Date.
In the front end, I'm calculating:

Sum(CustCount) / Sum(TOTAL CustCount)

It works perfectly when MonthYear is selected, I get the correct percentage of customers.
But when MonthYear is not selected, the percentage goes completely off.

I’ve tried a few things but I’m stuck. Any ideas on how to fix this so it always reflects the correct % with or without MonthYear selection?

Much appreciated 🙏

[marcus_sommer · Accepted solution]

I assume that the object itself contained a period-information like the MonthYear. In this case the expression extension must reflect this dimension - maybe like:

Sum(CustCount) / Sum(TOTAL <MonthYear> CustCount)

[LoKi_asterix]

I was overthinking it. This is perfect cheers!