Is there a way to only show relevant rows in a hierarchy filter?
I have a dashboard that has a hierarchy filter from Cost Centers -> Jobs
(i.e. Cost Center A has 1M in Cost. When I click on it, the Jobs grid card updates to show 10 different jobs that make up that cost. But 2 of those Jobs has $0 cost.)
I don't want those 2 Jobs to show up since they are not relevant to the $1M for Cost Center. It will make the grid smaller and stop unnecessary scrolling.
Appreciate any ideas.
@R_Goza I tried that but the issue is that the filter asks for specific week. I have a grid card with 8 weeks of data. I can't have this depend on just 1 week of blank.
But I solved this by setting up a CUMULATE on the number of Hours Worked(the source metric for cost) and then connecting it to the Periods shown. Then I can use that cumulate line item as the filter in UX.0