Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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?
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.
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)