Unwanted Forced 0

[#1]

Hi all!

I'm making a chart with a trend line (monthly history) and two average lines based on calculations (using AVG TOTAL instead of the available average trend line). I have unchecked 'Forced 0' for all three lines under the Axes tab but my y-axis still starts at 0. Because the chart is intending to be dynamic, I don't want to set a static min/max. As an example, one set of data ranges from 10-35.

Any ideas for how to get the chart's y-axis min to change?

Thanks so much for your help!

Shannon

[swuehl]

Your 'static' min / max don't need to be constant, you can use expressions, hence stay dynamic.

But maybe the solution is much more simple, could you post a small sample QVW?

[#3]

It might take a while to post a sample QVW because of my dataset - not sure it can be done with my existing data. But the trend line expression is below if that is any help.

Why do I need to set static min/max at all if Forced 0 is unchecked?

Thanks, Stefan!

=if(invert = '1',

sum({<frequency = {'M'},universe= {'All'}>}(1/Value)),

sum({<frequency = {'M'},universe = {'All'}>}Value))

[swuehl]

Could you post all dimensions and expressions you are using?

I thought you mentioned something with Avg(TOTAL ...) as trendline, your above expression seems pretty different to that.

[#5]

Of course! To be clear, the above expression is the trend line and the two below are the average lines which use AVG(TOTAL()). 'All' isn't really all universes in case that is point of confusion.

=if(invert = '1',
avg(TOTAL {<frequency = {'M'},universe = {'All'}>}(1/Value)),
avg(TOTAL {<frequency = {'M'},universe = {'All'}>}Value))

=if(invert = '1',
avg(TOTAL {<frequency = {'M'},universe_name = {'All','US','Europe'}>}(1/Value)),
avg(TOTAL {<frequency = {'M'},universe_name = {'All','US','Europe'}>}Value))

Thanks!

[swuehl]

If you transform your chart to a straight table, do some expression cells get close to zero?

Could you post some screenshots?

[#7 · Accepted solution]

I've found an alternate solution.

By adding the average expressions as reference lines, the y-axis becomes dynamic without having to add an expression for static min/max. To add a reference line, go to the presentation tab in chart properties and click 'Add' in the 'Reference Lines' box. Make sure to click 'Primary Y' when adding the reference line.

Thanks for looking into my question, swuehl !