Dynamic filter on multiple dimension and measure

RituKhatri — Thu, 28 Jul 2022 07:22:23 GMT

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.

topic Dynamic filter on multiple dimension and measure in App Development

Dynamic filter on multiple dimension and measure