Set analysis. Dimension compared to another dimension

[ruben_moya]

Dear experts,

This is my situation:

-I have a field 'prediction' with values from 0 to 1

-I have a field called 'prediction_ID' that is unique 

-I have created, in a separated table, a field called threshold that is basically class(Prediccion,0.01) and looks like this:

What I would like to achieve is to be able to sum the amount of prediction IDs whose prediciton values are greater than the thresholds. For a specific threshol the formula would be something like:

count({< Prediction={">=0,02"}>}Prediction_ID)

What I need is to be able to use a formula that allows me to tell, for each threshold, how many predictios have been higher.

I tried different options, but none worked:

count({<Prediction= {"=Prediction>= threshold "}>}Prediction_ID)
count({< Prediction={">=threshold "}>}Prediction_ID)

Is there any way to be able to filter in set anaylisis one dimension based on the value of another dimension?

I tried to be clear, if you have any questions please ask

Thanks a lot in advance

[vchuprina]

Hi,

Try this:

Count({<Prediction_ID= {"=([Prediction]>=[threshold])" } >} Prediction_ID)

Regards,

Vitalii

[ruben_moya]

Hi @vchuprina ,

thanks for your reply. That solution only works when there is one value of threshold selected.