Smart visualization code

edwi0012 — Sat, 16 Nov 2024 20:51:33 GMT

Hi everyone!

I can't come up with a clever function to show what to focus on, could you help me?

Background: I have a nice "Super KPI" which consists of multiple production KPI's combined.

let's say you have 3 values of "Machines:90%, Tools:93% and Manning:97%, then the average of them are below target ( 95%).
In the header I want it to say "Below target, focus on Machines". It's easy to find the lowest KPI by using the fuinction Rangemin( Machine calculations, tools calculations, Manning calculations ). But it will only give me the calculation answer 90% in this case not that it's regarding the machines. Here I would like it to return "position number 1 is the lowest => Machines"

The whole point of this is that there are multiple KPI involved and I want an easy overview what should be focused on, additionally the KPI's are droll down able for different departments.

Any suggestions, thanks in advance!

Combined KPI

Re: Smart visualization code

ajaykakkar93 — Thu, 16 May 2019 15:29:02 GMT

Hi,

You can create a widget / extension to meet this requirement.

Extension is much flexible.

Re: Smart visualization code

edwi0012 — Mon, 20 May 2019 11:55:39 GMT

Thanks for the answer, I'd hoped not to create an extension for this since I'm only at a beginner level with javasript etc. But ooh well.

topic Re: Smart visualization code in App Development

Smart visualization code

Re: Smart visualization code

Re: Smart visualization code