Hello ,
I am creating this dynamic dashboard where I need to create this dynamic filter using multiple dimension and measure . My data has date wise app feature names which I need to rank over the sum(total time to develop) and I want to have a selectable time period for data submission and in turn recalculate the rank .
I was able to calculate this dynamic rank using below expression
aggr({<feature_name>}rank(Sum((expert_actual_min)/60)),feature_name)
and than i divided my data into quartiles in order to get the top/medium/low features by selectable time period using below expression:
ceil(rank(total (aggr({<feature_name>}rank(Sum((expert_actual_min)/60)), feature_name))) /
(count(total (aggr({<feature_name>}rank(Sum((expert_actual_min)/60)), feature_name))) / 4))
Now as above calculation will create a measure which cant be used for filtering the data . I want to use my quartiles as filter to show the visualization . Is there any way to do the above calculation in data loader or to convert this measure into dimension and use as filter?
any guidance would be apricated.
