Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Much simplified version of the issue, we have data that looks like this:
ID represented people and Att_Id represents visits. We have a variable, say 4, we want to display the ID and Att_Id where the total number of visits is equal to the variable. So in the example it would show ID 234567 and the associated Att_ids
Cheers Andy
May be like attached sample.
Hello Andrew,
Maybe the below one,
Dimensions:
ID
Att_ID
Expression:
If(Count(Total <ID> ID)=$(YourVariableName),1)
Almost,
getting
May be like attached sample.
I have attached a sample. How the variable defined? Is it expression or just a number.?
What does the variable you have declared over there?
I think you should be able to use set analysis also
Dimension
ID,
ATT_ID
Expression
Only({<ID = {"=Count(DISTINCT ATT_ID) = vVar"}>} 1)
Avg({<ID = {"=Count(DISTINCT ATT_ID) = $(vVisit)"}>} 1)
Tested this on Tamil's sample and seems to work the same way as the if statement
Star turn!
Sorted!
Cheers Andy