Forum | Synoptix

Learn, Create, Report
It is currently Thu Jul 18, 2019 9:35 pm

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Top N
PostPosted: Tue Jul 09, 2019 11:43 am 
User avatar

Joined: Fri Jul 28, 2017 4:02 pm
Posts: 11
Position: Not Provided
I would love to put the top 10 customers by invoice TOTAL onto a pie chart for KPI's. But there appears no way to do this. Using BI cells for the MTD invoice is great for getting a total, but is not sortable. If I attempt to sort the results are VERY unpredictable. Looking at the generated SQL shows why, the system attempts to sort the components of the BI cell, rather than the total displayed by the BI cell. Likewise, any filter added is at the component level, not the BI return value level. So the idea of putting everything with say $100K on the chart and lumping the rest is a no go.

I can create a custom view to return the top N, but this would be a very useful feature to be included in the system.


Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
cron
Powered by phpBB® Forum Software © phpBB Group
Powered by Reputation System © Pico88