Chart from Enum or Enumlist data

[Renata]

This seems like it should be simple, but…

I’m trying to chart/graph data from columns which are of data type Enum. i.e. a defined list of options/categories.
Why can’t I select these columns when creating pie charts, stacked charts etc

To be specific, I want to graph cohorts of animals along X axes with number of animals on Y axes scale and broken down by a specific status re fate (died, released etc).

[Marc_Dillon]

Renata:

I’m trying to chart/graph data from columns which are of data type Enum. i.e. a defined list of options/categories.
Why can’t I select these columns when creating pie charts, stacked charts etc

Only numeric values are chartable (Number,Decimal,Price,Duration). What is the “base type” of your Enum columns set as?

List type columns, like EnumList, cannot be charted.

---

Renata:

To be specific, I want to graph cohorts of animals along X axes with number of animals on Y axes scale and broken down by a specific status re fate (died, released etc).

It sounds like you would need a Table like this:

Then you could use a “col series (stack)” chart.

[Renata]

Marc, Thank you so much for your feedback (and apologies for the slow reply).

Yes, you are right - it isn’t numerical data… but I thought it might be possible to do Countifs since the enum lists form categorical data. But I’ve ended up going back to the spreadsheet itself to pull out graphs. Not quite as ideal as embedding on a dashboard, but it will suffice.

Thanks again.