8 Replies Latest reply: Jun 24, 2016 1:01 AM by Sunny Talwar

# Rename x-axis value

Hello everyone,

WIth respect to the given graph below here is my question:

I want to rename the x-axis value ie. (-30-0) to be renamed as Within time .

Thanks!!

• ###### Re: Rename x-axis value

What is your current dimension? Is it a expression or a field which contains -30-0 as a value? If it is later, you can do like this:

If(DimensionField = '-30-0', 'Within Time', DimensionField)

• ###### Re: Rename x-axis value

dimension is an expression :

Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-')

• ###### Re: Rename x-axis value

If(Time(SiteArrivalDate)-Time(newdate) < 0, 'Within Time', Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-'))

• ###### Re: Rename x-axis value

Thanks Sunny T , it worked .

• ###### Re: Rename x-axis value

Can you also suggest how can i get x-axis values in order

ie. Witinn time, 0-30 , 30-60, 60-90,........

Tried using wild match function but its not working, can u suggest any other way??

Thanks!!!

• ###### Re: Rename x-axis value

Try this:

If(Time(SiteArrivalDate)-Time(newdate) < 0, Dual('Within Time', 0), Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-'))

• ###### Re: Rename x-axis value

I tried it still doesnt come in proper order!!