DV Visual Filter Top 10

Brian666H

Summary

I need to filter for Top 10 for just one of the reports in my canvas

Content

Looking for How-To place a top 10 filter on the record count of just one of the Visual reports in my canvas.  I do not want this filter to effet the others.

Version

18

Doug Ross

Is this similar to what you are looking for?

I created a calculation called RankCnt with a formula of RANK(SUM(Person Count By Assignment Status))

Then I dragged that calculation down into the filter area on the visualization, not to the filter bar.   Then in the visualization, set the limit from 1 to 10.

 

Brian666H

Wow too easy!   Love it, Thank You!!!

Antti Lappalainen

Hi, I think it's easier. Just drag the metric to visualization filters and change 'filter type' with a right click to 'Top Bottom N' as in picture.