Flexpivot Top N not returning expected results when used with a filter

Flexpivot Top N not returning expected results when used with a filter

Posted by: tperkins on 6 July 2020, 1:01 am EST

• 

  tperkins

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 July 2020, 1:01 am EST - Updated 3 October 2022, 2:44 pm EST

  Hi,
  
  When using FlexPivot I have had issues with Top N not returning the number of results requested even when there are more than N returned in respect of the filters applied.

  I have attached screenshots of your sample ‘Custom C1FlexPivotPage’ showing an initial set of filtered results with 12 entries.

  After adding a Top N filter of 10 only 8 of the original 12 results are shown.

  Is this behaviour by design?

  Regards
  
  Tim

  

  702×618 27.9 KB

  

  885×693 33.7 KB

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 July 2020, 6:36 pm EST

  Hi Tim,

  We too can observe the issue at our end, thus escalated this to the developers and will let you know once we get any update on this from the developers’ end.
  
  [Internal Tracking ID: 444488]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 July 2020, 3:03 am EST - Updated 3 October 2022, 2:45 pm EST

  Hi Tim,

  We have got the response from the developers and as per them, it is correct behavior. Top 10 of countries by ExtendedPrice sum are: ‘USA’, ‘Germany’, ‘Austria’, ‘Brazil’, ‘France’, ‘UK’, ‘Venezuela’, ‘Sweden’, ‘Canada’, ‘Ireland’. The ProductName = ‘Alice Mutton’ filter covers only 8 of them. See the attached screenshot for more clarity.

  Regards,
  
  Prabhat Sharma.
  
  

  

  2332×1456 360 KB

• 

  tperkins

  • Post Options:
  • Link
    Copy

  Posted 20 July 2020, 4:29 am EST

  Thank you for that, I was aware of what was being displayed but I was actually looking for the top 10 countries by extended price for sales of Alice Mutton only rather than the countries within the overall top 10 that bought Alice Mutton.

  If that is the designed behaviour then I will change my data retrieval to achieve the required result.

  Regards

  Tim

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 July 2020, 4:31 pm EST

  Hi Tim,

  The filters are applied directly to the data, not on the filtered data that is why you are getting only 8 values and this is the default behavior so I will request you to change your data retrieval to achieve the required result.
  
  If you need any other help, please let me know.

  Regards,
  
  Prabhat Sharma.