3 Replies Latest reply on Oct 27, 2015 3:16 AM by Nasrin Ahmed

# move x-axis to fall somewhere other than 0

Hi all,

Is there a way to change the x-axis so that the "0" point occurs at another number, like 2? I want values below 2 to be shown in red, and above 2 to be shown in black.

Thanks!

• ###### 1. Re: move x-axis to fall somewhere other than 0

I think you mean the Y-axis, but if you want everything less than 2 to be in red I would create a simple calculation to do that and place on the Colors card.

Something like:

if sum([Data]) < 2 then "red" else "black" end

and then change the colours to match red & black.

If this doesn't answer your question can you please supply some more detail or some example data ?

• ###### 2. Re: move x-axis to fall somewhere other than 0

That didn't produce the desired results, but it taught me something new!

Based on your suggestion, I created this calculated field:

IF (AVG([Duration hrs/wk (Adj)])<2) THEN "red" ELSE "black" END

When I place the calculation on the Colors card, it tells me "The calculation can't be applied to a user-defined aggregate."

My goal is to visually distinguish between average values that are below 2.5 and those above 2.5. I think I may need to use a reference line instead...

Thanks for your help!

• ###### 3. Re: move x-axis to fall somewhere other than 0

Remove the calculated field and drag it again in the view.

Does this help?

quoting joe mako

If you are editing a calc field that is already on a shelf, and you get that error, you will have to remove it from the shelf and place it again. What the error is saying is you can not perform an aggregate on an aggregate, so the text on the green 'pill' will change from "SUM" to "AGG" - meaning the aggregation is performed inside of the calculated field.