Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have defined a variable : vPercentPerVendor
I have placed a variable input with Input Box (so i can choose % from 0 - 100 (0.0 - 1))
I have placed a button and added action. Action is select value in the field (Field is dimension Vendor) with following expression: count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor).
Down below i have table with following fields: Vendor, Count (Distinct sale_service_id) and % of each Vendor in total count.
Idea is to represent vendors with 10 % or any higher % in relation to the total (which is 100 %).
I Attached SC.
Thank you in advance.
@LK13 You can create calculated dimension for vendor as below. Then check suppress null value option for this calculated dimension
=aggr(if(
count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor),Vendor),
Vendor)
@LK13 You can create calculated dimension for vendor as below. Then check suppress null value option for this calculated dimension
=aggr(if(
count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor),Vendor),
Vendor)
Something is wrong, it just doesn't show the expected results. Maybe my approach via "select value in the field" is completely wrong, I'm not sure.
Anyway , thank you Kushal very much !
@LK13 Solution I provided is not button solution it is calculated dimension solution for vendor dimension?
@Kushal_Chawda Actually you are absolutely correct. This approach work. I will just get rid of button and will leave only variable input. So yes calculated dimension will suppress null() and will work as expected.
Thank you.
@LK13 Please accept the appropriate reply as solution if it helped.