Is there a way to get colour slices on a pie chart to align to a value.
e.g for kpi scores.
Red = Red Slice
Amber = Amber Slice
Green = Green Slice
I can set multiple colours for the charts but when I filter them appsheet changes the assignments from the order I set in the UX.
Solved! Go to Solution.
In the said column, you could still assign it as enum by listing those enum options(red, amber, green) in the enum options settings. You could then have the IFS() based expression in the app formula of this enum column. So app formula will calculate one of the enum options. Please ensure the app formula does calculate at least one of those three enum options always.
If understanding of your requirement is correct, please assign an enum value for those KPI score statuses, meaning please create an enum field with words red, amber and green as enum options for the associated KPI scores.
If then you base your pie chart on that three value enum field, the colours should stick for respective statuses.
Note: Please post such queries in the "Q&A" section.
In the said column, you could still assign it as enum by listing those enum options(red, amber, green) in the enum options settings. You could then have the IFS() based expression in the app formula of this enum column. So app formula will calculate one of the enum options. Please ensure the app formula does calculate at least one of those three enum options always.
User | Count |
---|---|
42 | |
25 | |
25 | |
16 | |
11 |