How does IFS Cloud determine Lobby Pie chart colours?

I have also the same thing issue now i cant able to slove it of lobby pie chart colors..  

@Wyomi Ranasinghe, do you have an explanation of how it works? I think this is a great example of why it’s important we allow customers flexibility of adjusting colors!

It is not possible to map a specific color to a series of a chart in IFS Cloud lobby elements. This is only possible for charts in application pages which are declared through marble.
In apps 10 there was the possibility to customize the pallet used in lobby through the page settings, But this functionality is not available in IFS Cloud

Hi Wyomi, thanks for clarifying. Next question of course: is it on the roadmap? As this limitation is really awkward when talking to customers. It is 2023 and IFS has a powerfull tool for operational reporting, but some elements are just useless because "wrong” colours are very confusing!

@Drausenhaus Could you add a community idea with a use case. This will help us prioritize and and help you keep track of the progress.

We also had an issue when multiple charts were supposed to present the same categories for different criteria but depending on the data available, the auto-assigned colors for a given category could be different across the charts. Of course, this was “disappointing” to end-users.
(eg: One graph displays status A in purple while in the other graph status A may be green as Status B is absent in the result data.) 

The workaround was to create a new view which had a union of:

• the actual data and a ‘dummy’ column with 1 as the value for each record

and

• a select statement that would present at least one record for each category along with 'dummy' column with a 0 value. (Cross joins could be helpful here.)

In the lobby data source, the new view was used, the ‘dummy’ column was added to the columns list and the category column was added into the Order by of the data source.

The Order by provides consistency when the colors are assigned automatically. The colors would be consistent across graphs as all the categories are represented at least once.

In the lobby element, 'Sum' of the ‘dummy’ column was used as the aggregate to disregard the dummy records.

If the graph needs to click through to underlying data, then the new view needs to have the correct columns so they can be added to the data source condition to allow mapping to the client screen. (Custom fields could be added to the client window if needed).