Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am facing issue with change in the % when the filter with values in Column.
Below is the sample and out put that i have now.
Totals | Header | Totals | Items | ||||
UID | Match | Mismatch | Missing | Match | Mismatch | ||
000000337102 | 100.00% | 57.14% | 14.29% | 28.57% | 100.00% | 83.33% | 16.67% |
000000337107 | 100.00% | 85.71% | 0.00% | 14.29% | 100.00% | 83.33% | 16.67% |
Grand Total | 100.00% | 71.43% | 7.14% | 21.43% | 100.00% | 83.33% | 16.67% |
Everything working fine. If i select any value from UID it is showing the same value, but If I select any values from Header/Items (Match/Mismatch/Missing) i see % gets changed. So I should see same value as above no change in the % if there is ant filter.
I have set expression as below;
Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'}>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'}>} Total<UID, Field_Type > [Registration ID])
Basically i am looking for a Pivot where Filter should be possible but it should not change the values or % when it is filtered.
Attached Sample data
I some how got the result, But Not completely happy. I have set expression as below and for filtering Managed it with Vizlib Pivot.
if(GetSelectedCount(Result)>0,
(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({1< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type>[Registration ID])),
(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type >[Registration ID])))
If any one have any other solution please let me know. I want set analysis to Calculate the % even after Filter.
Till then setting this as a solution
Thanks,
What if you disregard selections on those 2 fields?
Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'},Header=,Items=>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'},Header=,Items=>} Total<UID, Field_Type > [Registration ID])
Hi Alberto,
Thanks for your reply. Expression you provided is not giving me the desired output. 2 Fields in Red are the Values from "Field_Type", these are not Fields.
So Do you want me try as below?
Count({$< STEP = {'VAL'}, Field 2-= {'Amount helper'}, Result -={'NA'},Field_Type=>}[Registration ID]) /
Count({$< STEP= {'VAL'}, Field 2 -= {'Amount helper'},Result -={'NA'},Field_Type=>} Total<UID, Field_Type > [Registration ID])
?
Thanks
Any other way to do this?
I some how got the result, But Not completely happy. I have set expression as below and for filtering Managed it with Vizlib Pivot.
if(GetSelectedCount(Result)>0,
(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({1< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type>[Registration ID])),
(Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}[Registration ID])
/
Count({$< STEP = {'VAL'},Field 2 -= {'Amount helper'},Result -={''}>}total<UID, Field_Type >[Registration ID])))
If any one have any other solution please let me know. I want set analysis to Calculate the % even after Filter.
Till then setting this as a solution
Thanks,