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
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?