Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Extensions
1406 2
cancel
Showing results for 
Search instead for 
Did you mean: 
TCGpro_Shop
4 - Data Explorer
4 - Data Explorer

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: