topic Re: Table Column showing same value for all rows in App Development

Table Column showing same value for all rows

thefish — Sat, 16 Nov 2024 05:05:57 GMT

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

Re: Table Column showing same value for all rows

dplr-rn — Wed, 31 Jul 2019 20:04:22 GMT

it depends on the expression. Share that please

Re: Table Column showing same value for all rows

thefish — Wed, 31 Jul 2019 20:08:34 GMT

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.

Re: Table Column showing same value for all rows

dplr-rn — Wed, 31 Jul 2019 20:11:22 GMT

Most likely cause is the total

total keyword ignores dimensions. try removing that.

hope that works else you may need to rewrite the expression

Re: Table Column showing same value for all rows

thefish — Wed, 31 Jul 2019 20:31:54 GMT

When I remove total, it only shows values for 3 of the 50+ customers...

Possibly due to NULL Days?

Re: Table Column showing same value for all rows

dplr-rn — Wed, 31 Jul 2019 20:55:34 GMT

You mean date is null?

Check the requirements. Do you need the aggr function in your chart

Re: Table Column showing same value for all rows

thefish — Wed, 31 Jul 2019 20:59:02 GMT

I mean not every customer has data for each day.

And yes the AGGR is necessary.

Re: Table Column showing same value for all rows

dplr-rn — Wed, 31 Jul 2019 21:01:25 GMT

Share what the other dimensions are

Re: Table Column showing same value for all rows

thefish — Wed, 31 Jul 2019 22:41:52 GMT

There are no more in the table.