4 Replies Latest reply on Apr 13, 2016 9:03 PM by mrmmickle1

    Filter Top 10 Values Not Performing As Expected

    mrmmickle1

      Lets say I have 40 rows of data....

       

      One row contains two fields:

       

      Report (case when TRIM(BOTH FROM SUBSTRING("Topic"."Webcat Path" FROM LOCATE('/',"Topic"."Webcat Path", -1)+1)) = 'Employee Headcount - Detail' then '2. Employee Headcount - Detail' else TRIM(BOTH FROM SUBSTRING("Topic"."Webcat Path" FROM LOCATE('/',"Topic"."Webcat Path", -1)+1)) end)

       

      and

       

      # of Times Requested (Measure:"Measures"."Query Count")

       

      When I try to filter on top 10 values there are only 4 results returned....How is this possible?  There are 40 records so I know that there are more than 4...

       

      I remember running into something like this while using a top 25 while using Tableau...  I think it had something to do with the data being filtered at the source and not in the presentation layer...  Can someone help me to understand the issue and provide a solution if possible....

       

      Fields that are not being used in the current compound view are as follows:

      UserName, Year, Month & Month Number

       

      Filter Criteria:

      Rank_Capture.PNG