Rename x-axis value

[Karahs]

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!!

[sunny_talwar]

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)

else please share what your current dimension is.

[Karahs]

dimension is an expression :

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

[sunny_talwar · Accepted solution]

How about this:

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

[Karahs]

Thanks Sunny T , it worked .

[Karahs]

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!!!

[sunny_talwar]

Try this:

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

[Karahs]

I tried it still doesnt come in proper order!!

[sunny_talwar]

How about this:

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