Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DV Visual Filter Top 10

Received Response
35
Views
3
Comments
Brian666H
Brian666H Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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

Capture.JPG

Tagged:

Answers

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    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.

     

    dv_filter.jpg

  • Brian666H
    Brian666H Rank 6 - Analytics Lead

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

  • Antti Lappalainen
    Antti Lappalainen Rank 1 - Community Starter

    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. 

     

     

    FilterType.png