X Axis min point start from 20%

[paulyeo11]

Hi All

I try to changeX Axis min by enter 20% , it does not work. any idea ?

[sivarajs · Accepted solution]

You might have checked forced 0 option in axes tab of properties.Uncheck and set the changes

[#3]

This can be possible by set the Static min, max and set values for the expression "Scale" area under Axes tab. Also, uncheck the option "Forced 0".

[paulyeo11]

Hi Ven

How can i make use of Argg function to make it dynamic ? my expression as below :-

(

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

-

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1

)

/

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

Paul

[Siva_Sankar]

Under Axes tab, uncheck forced 0 option and try. Regards. siva

[kaushiknsolanki]

Hi,

     For min value try this.

Min(Aggr((

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

  -

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1  )

/

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),Dimensions)

For maximum value

Max(Aggr((

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

  -

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1  )

/

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),Dimensions)

Regards,

Kaushik Solanki

[paulyeo11]

Hi Kau

Many thank , it work fine.

Paul