Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
How about this:
If(Time(SiteArrivalDate)-Time(newdate) < 0, 'Within Time', Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-'))
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.
dimension is an expression :
Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-')
How about this:
If(Time(SiteArrivalDate)-Time(newdate) < 0, 'Within Time', Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-'))
Thanks Sunny T , it worked .
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!!!
Try this:
If(Time(SiteArrivalDate)-Time(newdate) < 0, Dual('Within Time', 0), Replace(class(Time(SiteArrivalDate)-Time(newdate),30),'<= x <','-'))
I tried it still doesnt come in proper order!!
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)))