Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

ignore filter in rank function

Hi guys,

I have a rank function that needs to ignore some fields, but not working. how can I ignore the filter using the rank function?

aggr(

if( rank

 if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,

sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))

)<=5, only({<FIELD1>} Dim)),Dim)

 

If I included in the KPI only the sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure) the selection by FIELD1 will be ignored, this is ok, but using the full measure with rank not ignore

Labels (1)
2 Replies
vincent_ardiet_
Specialist
Specialist

Maybe with Aggr({<FIELD1>} ... ?

Jsobrinho77
Creator
Creator
Author

first of all, thank you for your answer...

But not ignored yet.

if I selected a type of the FIELD1, show 3 values, but without this selection I will wait 5, because the rank without this selection is 5.

I'm tried 

 

Only( {<FIELD1>}

aggr(

if( rank

 if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,

sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))

)<=5, Dim)),Dim))

But this retunr: Invalid dimension