does appsheet have dynamic charts?

AppSheet AppSheet Q&A
, , ,
1

my googlesheet has three columns. [DateTime], [StockName], [StockPrice].
note: these are not my actual columns, my columns has different names, but for the sake of simplicity i came up with these column, else. my app is different but same idea applies.

[stockName] column has bunch of stocks, repeated ones too.
this column is linked to [StockPrice], it scrapes the web, if it detects a price change, it will record it as well as the [DateTime]. so one stock name could appear multiple and multiple times under [stockName ] column, depending on how often it changed.

in app sheet i want to create a chart.
x-axis is the [DateTime] (note, these dates are very random and maybe no two are alike, and they are sorted from oldest to newest, the format is DD/MM/YYYY - HH/MM/SS)
the Y axis shows the [StockPrice] value (ranging from the min that is on my data to the max)
and a legend and a line chart of all the stocks names. the chart can show all the lines to compare them to eachother, or i can manually select a stock name and the chart will change and show just that stock. is this doable?

2

You may want to explore the concept mentioned in the sample app below. That sample app has just one user implementation. For multiple user implementation you will need a Users table in place of Filter table in the sample app. The Users table will have one row per user to store the selections of the table.

Sample app Slice based on user input - AppSheet from the help article Get started by using the sample apps - AppSheet Help

In the sample app, the user can select a color. The slice on the data table then filters the records related to that color. The slice in turn acts as an input to the chart view.

Similarly you could explore with 'Stock name". use selects a stock name and the records related to that stock name are filtered in the slice. Then the chart could be based on that slice.

Note: As for chart itself, I have not exactly analyzed whether it is possible to build the chart the way you want with those two remaining columns.