Conditional Colours on Pie Chart

[antproberts]

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.

[Suvrutt_Gurjar]

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.

[antproberts]

Thanks but the scores are the result of an IFS test on percentage scores so
cannot set them to ENUM.

Is there any other way?

Thanks.

--


Please consider the environment before printing this email.
*********************************************************************
This
communication may contain information which is confidential, personal
and/or privileged. It is for the exclusive use of the intended
recipient(s).
If you are not the intended recipient(s), please note that
any distribution, forwarding, copying or use of this communication or the
information in it is strictly prohibited. If you have received it in error
please contact the sender immediately by return e-mail. Please then delete
the e-mail and any copies of it and do not use or disclose its contents to
any person.
Any personal views expressed in this e-mail are those of the
individual sender and the company does not endorse or accept responsibility
for them. Prior to taking any action based upon this e-mail message, you
should seek appropriate confirmation of its authenticity.
This message has
been checked for viruses on behalf of the company.
*********************************************************************


G4S
Regional Management (UK&I) Limited, Registered in England No. 3189802.
G4S
Care and Justice Services (UK) Limited, trading as G4S Central Government
Services, Registered in England No. 390328.
G4S Health Services (UK)
Limited, Registered in England No. 5121608.
G4S Government and Outsourcing
Services (UK) Limited, trading as G4S Outsourcing Services, Registered in
England No.3175173.
G4S Facilities Management (UK) Limited, Registered in
England No. 3333860.
G4S Investigation Solutions (UK) Limited, Registered
in England No. 3749819.
G4S Monitoring Technologies Limited, Registered in
England No. 2626613.
G4S Ordnance Management Limited, Registered in England
No. 7068855.
G4S Risk Management Limited, Registered in England No.
1540857.
G4S Secure Solutions (Iraq) Limited, Registered in England
No.5128617.
G4S Risk Consulting Limited, Registered in England No. 4047630.
The Registered office of all the above companies is 46 Gillingham Street,
London ,England, SW1V 1HU

G4S Aviation Services (UK) Limited, Registered
in England No. 2837136.
G4S Secure Solutions (UK) Limited, Registered in
England No. 1046019.
G4S Security Services (UK) Limited, Registered in
England No.2380900.
G4S Cash Solutions (UK) Limited, Registered in England
No.354883.
G4S Cash Centres (UK) Limited, Registered in England No.1485104.
G4S Bullion Solutions (UK) Limited, Registered in England No.7860383.
*The
Registered office of all the above companies is 2nd Floor, Chancery House,
St Nicholas Way, Sutton, Surrey, SM1 1JB.*

[Suvrutt_Gurjar · Accepted 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.