Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Is it possible to create a Chart App with search box to filter its [group by] field?

Topic Labels: Extensions
473 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Given a table which records [date, product, price] is it possible to make a chart that have search box to filter which product we want to focus on? My current approach is to double click from the legend, but even they aren’t sorted which kinda frustrating to me.

Or were there yet considered approach to solve the exact problem (to make a dynamic chart of price by date for a specific product)? One of the first few thing in my head are to create a table for each product (which seems unscalable), tweet via automation a tweetable ascii art, or even create/update a google sheet everytime a transaction happened.

2 Replies 2

Hello and welcome to the Community @TCGpro_Shop!

When using the Chart App we recommend creating views that capture the different slices of data you’d like to show in the chart (so in your case you could create separate views to filter down and focus on certain products).

So if this is my main table with all my products:
Demo+Lessonly+Base_+Products+2021-04-30+at+8.40.39+AM

I could then create a new view only looking at Product A:
Demo+Lessonly+Base_+Products+2021-04-30+at+8.41.49+AM

Then in the Chart App I can switch between the two views to see all the information in the table, and see the information just from the view I created:
Screen+Recording+2021-04-30+at+08.44.25+AM

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .

I see, so currently the best approach is to make a view for each product manually. I’m not so sure about this as there’s a lot of products and I doubt I could click and type for each product for it :frowning: