How to design a gauge chart with margin & margin % as given below.

[#1]

Expressions

Sum(Margin) for Margin

Sum(Margin)/Sum(Sales) for Margin %.

The attachment 1 shows the original solution but I don't have the properties of it.

Where as attachment 2 shows the chart I got. vinay_bangari‌

[Anonymous]

Hi Nithin,

In Expression tab of gauge chart properties give the

an expression - Sum(Margin)/Sum(Sales)

Number Tab:

select integer

and select show as percent checkbox

Presentation tab:

assign Min = 0

           Max = 100

Create 3 segments

Segment 1 = 0 //Colour Red

Segment 2 = 80 //Colour Amber

Segment 3 = 90 //Colour Green

For text give the expression for metrics you want to show.

Regards

Neetha

[maxgro]

like this?

[Anonymous]

go to the properties of the chart select Min and Max as per your requirement, select the checkbox -show as percentage and then give the coloring in segments assigning each segment a particular color.

[Bill_Britt]

HI,

Here is an example. It is very basic.

Posters, it is a big help for people if you would take the time to create a sample for them to see. The information you have given is good, but it also helps for them to see what you are doing.

Bill

[Anonymous · Accepted solution]

see the attached word document which will help you to solve the issue.

[Anonymous]

heere is the attachment