Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help with an expression to calculate % in a PivotChart.
The calculatuon is a division operation (Number of IDs in TeamB that Completed in 45 days over the Total number of TeamB IDs). by the Date Dimension.
Count(DISTINCT {$<Team={'TeamB'},DaysToComplete={"<=45"}>} ID)/Aggr(Count(DISTINCT {$<Team={'TeamB'}>}ID),day_month_year)
The expression is not showing the value in all scenarios. It seems to indicate a null.
What am I doing wrong?
Sample attached.
HI @sqlpuzzle
Try like below
=Count(DISTINCT {$<Team={'TeamB'},DaysToComplete={"<=45"}>} ID)/(Count(total<day_month_year> DISTINCT {$<Team={'TeamB'}>}ID))
HI @sqlpuzzle
Try like below
=Count(DISTINCT {$<Team={'TeamB'},DaysToComplete={"<=45"}>} ID)/(Count(total<day_month_year> DISTINCT {$<Team={'TeamB'}>}ID))