Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table being created for a control chart dashboard. It should show customer and the number of days out of control for our KPI. However, while the value is correct when not put in the table, it won't change for the customers in the rows.
For example
KPI = 3
customer: KPI
c1 3
c2 3
c3 3
How do I solve this
AVG(total {<[Date]={(Date Selection here}>} AGGR({<[ Date]={(Date Selection Here)}>} $(vKPI), ([Date],[Customer])))
Table has the dimension customer and 2-3 other measures which work perfectly
vKPI is an IF Statement which is the sum of various other metrics. It has it's own set analysis.
This is supposed to return the average of the KPI for the customer.
Most likely cause is the total
total keyword ignores dimensions. try removing that.
hope that works else you may need to rewrite the expression
When I remove total, it only shows values for 3 of the 50+ customers...
Possibly due to NULL Days?
You mean date is null?
Check the requirements. Do you need the aggr function in your chart
I mean not every customer has data for each day.
And yes the AGGR is necessary.
Share what the other dimensions are
There are no more in the table.