Issue with the waterfall model

[farheenayesha]

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#))

[Clever_Anjos · Accepted solution]

Set Static Min to 0 and "Forced 0" at Axes tab

[farheenayesha]

Thank you so much Clever.