Panel data - row series stack chart

[edulk]

Hi everyone,

I’ve researched and read the AppSheet documentation, specially about the charts (https://help.appsheet.com/en/articles/961557-charts-the-essentials), but I didn’t succeed to achieve what I wish.

I have a panel data with 3 columns:
Table 1

I would like to display the data in AppSheet in the following way (row series stack chart):
Graph 1

The above chart was actually a workaround using the following data framework:
Table 2

Anyway, does anyone know if there is a solution for this case of panel data (Table 1) and displaying the data in a stack chart (like Graph 1)?
Or would I have to stick with the data frame as shown in Table 2, the problem I would have to generate a new column for every new animal added in the dataset, wouldn’t this be a problem when the app is displaying the chart?

Thank you!