Hi everyone. Im working on a Dashboard with graphs.
Im trying to generate a Pie or Donut Chart that shows the TOTAL COUNT of records in the slice, divided by Type, which there are two options : “Preventivo” and “Correctivo”.
I tried adding two virtual columns to the table with the following formula:
COUNT(FILTER(“Tabla filtrada OT”,[Tipo]=“PREVENTIVO”)) ,and COUNT(FILTER(“Tabla filtrada OT”,[Tipo]=“CORRECTIVO”)),
But the graph makes a series for every record of the slice.
I then tried creating a new Table with only two virtual columns, that count the slice, but this only seems to work with “row series” style graphs, not pie or donut chart.
Can anyone think of a way of achieving this?
Is it correct understanding that in each row of the table ( and so slice) there is column [Tipo] which can have values either “Preventivo” and “Correctivo”. You would then like a Pie chart for the count of each of these values in the slice.
If so, you could base the chart view on the slice with aggregate pie chart type and select the chart column as [Tipo]
In the example below, the aggregate pie chart is based on the column [Order Status] that can be “Open”, “Complete” or “Canceled”
The group aggregate is selected as “Count”
3 Likes
Addition: When working with charts in Appsheet, it is useful to have columns or virtual columns that contain quantitative values for each row, even if it is 0 or 1. If you have such columns, use them when building charts.
For example:
[No_of_item]
[No_of_blue_item]
[No_of_green item]
…
3 Likes
Thanks @Suvrutt_Gurjar ! You made my day!
2 Likes
