Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have chart that plots two expressions :
Line A : sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number)
Line B : sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number)
Is there anyway to set the minimum x-axis values to whatever the lowest value of these two expressions is minus 250?
Many thanks,
Tom
In the Static Min expression box (on the Axes tab):
=rangemin(min(aggr(sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number), YourFirstDimension, YourSecondDimension, etc.)), min(aggr(sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number), YourFirstDimension, YourSecondDimension, etc.)))-250
You need the aggr() to get the calculation with your dimensions. Listing them in rangemin() will give the min of the mins. Then just subtract 250.
Right Click
Axes
Scale
Tick Min and under Static Min Copy below expression.
IF(sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number))
<
sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number),
sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number))-250,
sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number)-250)