Stack Bar Graph_Urgent

[#1]

Hi All,

I need your help to show the percentage of a sales at a specific time vs full time in a single stacked bar.

I put two expressions for that, which is not reflecting the correct picture as the portion is showing the wrong picture.

[rajat2392 · Accepted solution]

your 2nd expression is for total no of sales man..and what you need is the sales man those having less than 500 sales, so change the expression..I have attached the app, you can do this in 2 ways....

check graph1 and graph 2

[#3]

Is it better?

[MK_QSL]

Create a Bar Chart

Dimension

NO DIMENSION

Expression

1) COUNT(DISTINCT Salesman)-COUNT({<Salesman = {"=SUM(Sales)<500"}>}DISTINCT Salesman)

2) =COUNT(DISTINCT Salesman)-COUNT({<Salesman = {"=SUM(Sales)>=500"}>}DISTINCT Salesman)

Style Tab

Orientation = Horizontal

SubType = Stacked

Hope this helps...

[#5]

Thanks All for the help.