How to make values in visualization/visualizing that start on 0, 10, 15, 20, 25, 30

[Anonymous]

Hi All!

I need a little help with visualizaing my report. Is there any way to make my y-axis values start on 0, 10, 15, 20.... so on?

Please help me with this.

Regards,

lee

[Anonymous]

Hi @Anonymous,

Because there is no data given I'm not sure if I have understood your problem correctly or not, But I'm assuming that you have a column with either decimal or Whole number from 0 to 20 and you want to visualize the data by using 0,10,15,20...... on y axis.

to achieve this make a new column

Interval =
IF (
    number >= 0
        && number < 10,
    "0",
    IF (
        number >= 10
            && number < 15,
        "10",
        IF ( number >= 15 && number < 20, "20", BLANK () )
    )
)

Use this column in y-axis .

Regards,

Gaurav Raj Singh