Gauge chart question

[#1]

Hello,

I'm trying to create a Dashboard (using primarily gauge charts) to consolidate a number of KPIs to provide a quick snapshot of performance. Each KPI has a target and when the target has been positively achieved (some targets should be exceeded while others should not be, e.g. waste) the weighting attached to the KPI should be colour coded green (e.g. for Sales below 10% of the gauge would be green if the target is met).

25

KPI	Target	Weighting	Week1	Week2	Week3	Week4
Sales	40	10%	30	50	35	60
R&D	20	40%	10	10	60	70
Manufacturing	150	30%	800	200	100	600
Waste	50	20%	15	35	20

N.B. Sales, R&D and Manufacturing actuals will be green when above the target and waste is red when above target

So based on the above week 1 would 50% green, week 2 would be 60% green, week 3 would be 60% and week 4 would be 100% green

Any suggestions or feedback would be useful.

Thanks,

Ralph

[suniljain]

To Achieve this , you need to create fout segnment in presentation tab of gauge chart .

each segment for each week .

[#3]

Do you mean each segment should be a KPI? If so whilst it would work the segments would not be sorted by colour, i.e. one segment could be red, then the next green, then red etc. Ideally I would want all the green KPIs sorted first and then red.

Thanks,

Ralph

[mjm]

Hello Graham,

if I have understood this correctly, then you should have the following:

KPI will be a dimension in the chart, which you can change in a list box for example. The one gauge chart will then change to represent the KPI which you have chosen.

You will need to have segments (possibly 1) which will show the acceptable value. This segment can be colored green.

Anything below this value will need a second segment, where the color will be red.

You will need to deal with each week as a seperate dimension which will control the values in the chart. So two list boxes seperate to the gauge chart (KPI and week) which the user can change, and the gauge chart will change accordingly.

I am not quite clear on what you wanted to do with weighting, but I think this explanation will help you in the right direction.

Hope this helps. Please mark as answered if so.

[#5]

Hello,

The gauge chart has to show all KPIs at the same time (I can create a variable for the date so that is not a problem) and the weighting determines how much of the gauge is attributed to the KPI. For example the R&D segment will always be 40% of the gauge whether it is green or red. I can create a segment per KPI and then assign the relevant colour using a simple if statement. The problem with this is that I need to sort the KPIs by colour, I don't want a mis mash of colours.

Thanks,

Ralph