Want help to make abar graph like attached image

[ananyaghosh]

Hi,

I want to make a bar graph like attached image and have used no dimension and expression as sum(Income). So if it is 66% or 69% , then accordingly the red line will be increased or decreased along the gray line. So what I have to do? Please suggest

[Anonymous]

It is a gauge chart, take a look.

Edit: Can be done with the bars too - use two expressions, stacked style.

[Anonymous]

OK, here is a bar example

[ananyaghosh]

!Hi,

I have the following data points in scripts:

[Data2]:

load * inline [

Exp

12

14

15

45

12

67

78

34

57

56

78

];

and used two expression as:

1st expression

sum(Expression1)/sum(all Expression1)

2nd expression

1 - (sum(Expression1)/sum(all Expression1))

and used stacked style

but did not get the exact effect. ! please help me.

[Anonymous]

Your example works correctly - just bring the list box on the screen and make selections

(If no selections are made, you have 100%of course)

[ananyaghosh]

I am requesting you to make a QVW on the basis of my provided data and please give me that one. otherwise I cannot understand that solutions.