Filter option in Master item

[harsha]

Hello people,

I'm stuck in middle and please read my problem below.

I have added a measure in Master items which gives me results based on the condition like "Match" or "No match".

My requirements:

1. I want to have a filter on master Item (Check Compare). I can currently sort on CheckCompare column but not filter however I can filter Source_ID,Source_Period columns

2. I want to have count of the results in separate chart from Master item.. like count of "Match" and Count of "No Match"   

I have attached QVF file here for ur reference...thanks in advance 🙂

 

[harsha]

Hello Loren,

I have 3 requirements.

1. I used this formula to know how many records for 2018 however, I want this chart should show only if the count is below 3.

Count({<Dest_Period={'2018'}>}Dest_Period)

Also, 

2. I want to know the count of 'No match' cases from Test Compare which is a master dimension. For instance, In the below Test Compare dimension results, there are 14 no match records. 

3. I want % from total records like below

Out of 35 records, 14 records are unmatched and 40% is the match rate. How can I achieve all these?

[susantahpe]

Hi,

1) you need to use the formula with IF condition as below.

=IF(Count({<Dest_Period={'2018'}>}Dest_Period)<3,Count({<Dest_Period={'2018'}>}Dest_Period))

2) you can use the measure as below.

=Count({<TestCompare={'NoMatch'}>}Source_ID)

3) you just divide the above one to the total count to get the %. like below,

=Count({<TestCompare={'NoMatch'}>}Source_ID)/Count(Source_ID)

hope it helps you.

[lorenzoconforti]

1. if(Count({<Dest_Period={'2018'}>}Dest_Period)<3, Count({<Dest_Period={'2018'}>}Dest_Period))

2. as part of a KPI: sum(match(Source_Combo, Dest_Combo))

3. sum(match(Source_Combo, Dest_Combo))/count(Source_Combo)