Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My reference line value is more than the the y axis scale . As its sets automatically the scale . So i could not make my reference line visible.
The scale is at 400 on y axis of the value.. And the reference line goes to value of 860 which is greater than the value 400 . So
plz suggest on this problem.
Hi, what you would need to do is to use a static max in the axix tab using a formula like
=if( max(aggr( sum({$} Expression1), Dim1))>860,max(aggr( sum({$} Expression1), Dim1))*1.2,860*1.2)
I have attached an EG.
Thanks
Steve