MIN GRAPHIC SCALE

[philgood34]

Hi everybody

I try to improve the appearance of a graph by customizing the scale

I would like the y-axis to start at 90% of the minimum value for example

I tried, but i don't know the syntax with "min" or "range min" applied to the sales values (Measure is Sum({<Flag = {'CY'}>}VMS_CATTC)) for the period (Dimension is AsOfMonthYear)

Regards

Philippe

[pradosh_thakur · Accepted solution]

try this

if dont want it to be changed by selection.

=min({1}aggr(Sum({1<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

else

=min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

edit:

You may want to check for the flag. If you want to include all the value or only for 'CY'. edit that as per your requirement.

regards

Pradosh

[philgood34]

Hi Pradosh

i tried the second expression in a tab to see the result ...

it seems that it does not work ?

have you an idea ?

Thank's in advance

Philippe

[pradosh_thakur]

1:Try using that in a text box and check the result.

2: Use the expression in MIN(for setting the min value of Y axis for Sales) not in another tab

edit: we missed a '{' . I have edited the same in the previous reply too. so it will work for you now. Let me know if it works and close the thread by marking answers helpful and correct.

try this

min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

regards

Pradosh

[Frank_Hartmann]

=min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

[philgood34]

Sorry .. Still does'nt work ??

[philgood34]

Yes i just saw it !

min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

min(aggr({Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

it works in the tab also

thank's a lot !!!

Regards

Philippe

[pradosh_thakur]

you are still writing it wrong Philippe

not this   ->   min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

this

-> =min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

[philgood34]

It's ok , i was to show the mistake

Thank's