Setting Graph

[Kibishi47]

Hello everyone,
I'm new to graphic design on appsheet and I can't figure out how to achieve what I want.

Here are my main columns for solving my problem : (some name are in french but I am going to translate)

Logs_Intervention

Début (Start) *Label

Related Travaux_Composants (Component Works)

Travaux_Composant (Component Works)

Etat (State) *Label ENUM(Good, Bad)

I need a piechart that show the number of good or bad state in only one log.

So I try to make some virtual column in log : nbGood, nbBad. And add them in the chart columns but that don't work.

One extra question : can we add that graph in a report using a template ?

[Kibishi47 · Accepted solution]

EDIT : I Success this task by filtered the last work of each state and each of them have a virtual column to know how many same state in this log there are

If you have a better option, I'll like to know it