Hi Everyone,
I have a Pie chart in EDD that shows on-time and Late Data for Operation completion.
In EDD, I selected the Status column as Category and Count Job number in row, but still it is selection color base on the value.
Can anybody help me ?
Ask a question!
I want to fix the colour for the status.
Red - LATE.
Green for on time.
So I put the status in the category
Still, it is going by data value, if next time is late jobs, have more count, then it will become green.
There is so little control over the charts there, that I don’t trust them to even be consistent. They should maintain the same colors in the same order. The colors do not change based on values or status. They are just static colors assigned to the data slot.
Could you try sorting by something else? Maybe the sort is the key. It look sto be sorted from high-low on the percentage. If you could sort it on the words “Early, Late” then you might get what you need.
I did sort by status in BAQ and in EDD but no luck
I have this type of color option here:
D3 Categorical
D3 Diverging
D3 Sequential
Qualitative Series
Quantitative Series
Aging Series
KPI
Highlight Good
Highlight Bad
Honestly, EDD is just waiting to be put out to pasture (IMHO). If you want real control, use Excel, or Grafana. Good luck!
How do you create your chart?
I use Epicor BAQs. I make sure the BAQ produces the correct set of data. Then I expose that BAQ via an epicor API key. I use Excel Power Query to ingest the BAQ via the API, then I use Excel to format the data into any kind of chart I want. Grafana has some better graphing tools, but everyone knows Excel! Either way, using your own BAQ and an API really helps get the data out into a usable place. Check out this thread:
REST API, Postman, and Excel Power Query Editor - Kinetic ERP - Epicor User Help Forum