Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Is it better?
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...
Thanks All for the help.