Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My waterfall model is flying in air as you can see in the below picture. Please someone help me to start the bars of the chart from the axis line.
I have used the below expression:
Total: Count (DISTINCT QUOTE#)
Bar offset:No exp( as this is the first expression)
1st level: count (DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))
Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))
2nd level: count (DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))
Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))
3rd level: count (DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))
Bar offset:Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))
4th level:count (DISTINCT if(CPG_APPROVAL_LEVEL=4,QUOTE#))
Bar offset: Count (DISTINCT QUOTE#)-count(DISTINCT if(CPG_APPROVAL_LEVEL=1,QUOTE#))-count(DISTINCT if(CPG_APPROVAL_LEVEL=2,QUOTE#))
- count(DISTINCT if(CPG_APPROVAL_LEVEL=3,QUOTE#))- count(DISTINCT if(CPG_APPROVAL_LEVEL=4,QUOTE#))
Set Static Min to 0 and "Forced 0" at Axes tab
Set Static Min to 0 and "Forced 0" at Axes tab
Thank you so much Clever.