Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can you please help?
I have data as follows:
Category Id
A 1
B 2
C 3
A 4
B 5
C 3
C 6
A 1
How to calculate in as a KPI that we have two ids with the same category (A - 1 and C -3)?
Many thanks for suggestion
Tommy
Or if you need to check this, maybe
Sum( Aggr( If( Count(Id)>=2, 1,0), Id, Category))
what do you want to calculate?
Maybe something like
=Count({<Id = {"=Count(Id)>=2"}>} DISTINCT Id)
This will not check if the category is the same, just checking if there are multiple assignments for the same Id.
Or if you need to check this, maybe
Sum( Aggr( If( Count(Id)>=2, 1,0), Id, Category))
This is what i needed, thanks so much.