Nice Simple How to! I think

[awhitfield]

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

[tamilarasu]

Hello Andrew,

Maybe the below one,

Dimensions:

ID

Att_ID

Expression:

If(Count(Total <ID> ID)=$(YourVariableName),1)

[awhitfield]

Almost,

getting

[tresB · Accepted solution]

May be like attached sample.

[tamilarasu]

I have attached a sample. How the variable defined? Is it expression or just a number.?

[Anil_Babu_Samineni]

What does the variable you have declared over there?

[sunny_talwar]

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

[awhitfield]

Star turn!

Sorted!

Cheers Andy