TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Chart view - x axis filter
The x axis in a chart creates a sum or an average of a value; it would be very useful to be able to filter the chart on that value so that in large data sets you can limit the details displayed to the most significant values.
ID
1153
Category
TeamDesk
Author

Val Bonner
Date Created
12/16/2017 1:22:54 PM
Date Updated
12/16/2017 8:27:02 PM
Status
New Idea
Score
30
Promoted By
Jamie (dbdesk)Patricio BustosVal Bonner
Comments
Cooper Collier 12/16/2017 8:27:02 PM
I am curious if one of the following could help?

1. Filter your data before defining the data to display? In the matching section of the chart view setup?
or
2. Create a many to many relation between the table and itself, then use one of the aggregate functions to get the values? https://www.teamdesk.net/help/4.6.20.aspx

You should even be able to use a combination of the two to get some interesting results.
Example...
Create a summary that aggregates the Average value of a column, then use the filter to return records that are greater than the Average Value.
or
Summary to find the maximum value, then filter for 10% of the maximum..

I see you can even get deviations and variations.. (whatever the heck those are!)

Feedback
 
Back to Search Results