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.
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:
I could then create a new view only looking at Product A:
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:
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: