Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 columns, name and status.
I want to count the columns only when all have the same status for example, yes.
Name | Status |
Jon |
No |
Jon | Yes |
Jon | No |
Kim | Yes |
Kim | Yes |
Kim | Yes |
Tim | Yes |
Here you go:
Sum(Aggr(If(Only(Status)='Yes', 1), Name)) / Count(distinct Name)
Hello, what should your result look like? In a KPI, in a table?
Can you please make an example with the input data and the expected result?
Hi Clement15,
In the best case, it would be a KPI that shows the percentage of names for which all statuses are Yes. In the example above, this would be around 66%.
I can not give you any input data, the only example is the table below. The desired output should be : a KPI that shows the percentage of names for which all statuses are Yes. In the example above, this would be around 66%.
Is this what you want?
Here you go:
Sum(Aggr(If(Only(Status)='Yes', 1), Name)) / Count(distinct Name)
No not exactly, The names are important to me. How many names have only YES entries. In my example I have 3 names, 1 name is only counted if all statuses are Yes. The problem is that the number of statuses per name can be different. Therefore, in my example above, 2 names out of 3 names would be completely on Yes, thus 66.6%.
ok, in this case the answer @LRuCelver should be suitable
Thank you very much