Filtering in a chart

Hi there!

Would you be able to share a snapshot of your chart setup? That’ll help me better understand the challenge.

If I understand correctly, I’ve tackled a similar issue by filtering data to show only the Top 10 values dynamically—for example, displaying the Top 10 states in attendance instead of all 50. Depending on how your data is structured, I might have a solution that works for you!

Let me know, happy to help.

Hmm, assuming your data looks like this:

And let's say you wanted to only see the first two titles for the Price and Users category:

If the above looks right, then you could try linking all your records to a single record in another table and using rollups and formulas to help with this:

And here's the field setups:

I've also set it up for you here and once you duplicate it to your own workspace you'll be able to see all the formulas

Hei Adam

Thanks for this detailed explanation. My records are not numerical and this is the challenge I believe as I am not able to properly define the sorts nor filters.

Here is an example of the issue I am encountering. In this table are included all of the titles I have been in touch with. The goal is to display only the 10 most common ones: CMO, Chief Revenue Officer etc. so this graph does not get cluttered. Right now I am not able to see anything.

This is another example of the same issue

These are all of the industries these people are from. I need the charts to be set up to dynamically identify only the top 10 most common Industries as I am going to be adding more info to the base weekly if not daily. Thus far this base has over 11k rows with data so you see the challenge

So my questions are:
1. how should I set everything up in the data tables
2. what conditions, formulas, sorts should be applied so that the charts/tables identify top 10 cost common titles etc

Thanks for your help and support

Hmm yea, I'd try creating a new table where each record represented one of those titles and then use a linked field to that table instead of a single select field.  With that, you'd be able to create a Count field in that new table to get the number of instances, and then you could set up the system above

That's what I've done, too!  @TheTimeSavingCo

There may be an easier to execute (if so, I would love some tips!), but here is an example of my use case (that shows an attendee count from each state at conference) 

New linked table of 'States' sorted in order of total attendees: 

- The added look up field from the states table that shows total number for each state  to the original base 

The condition I utilized on the interface to show only states that had 85+ attendees: 

@MilaIvanova , you could also set up another single select option that groups a couple of the titles ("Head of Marketing",  "Associate Manager" )

Hope this helps