I wanna show the axis value as date in below manner

[#1]

Hi friends

   I wanna show the axis value as date in below manner. In that picture u can see the range of values  0-29 like that. I need to show the date like as that manner

[#2]

Hi Abinesh,

Try with Replace() and Class() functions.

Can you please post the existed x-axis format so that we will try to implement it?

Thanks & Regards,

Harsha Nandan.

[PrashantSangle]

Hi,

Create Bucket in script then use that field as dimension.

For better understanding read article on Bucket written by Henric

Buckets

Regards

[ToniKautto]

I would consider using IntervalMatch and pre-group the values during load.

[amit_saini]

Abinesh,

Try this:

load distinct

    *,

    dual(if(TicketAge >=0 and TicketAge <= 7, '0-7 days',

    if(TicketAge >=8 and TicketAge <= 14, '8-14 days',

    if(TicketAge >=15 and TicketAge <= 21, '15-21 days',

    if(TicketAge >=22 and TicketAge <= 28, '22-28 days',

    if(TicketAge >=29 and TicketAge <= 60, '29-60 days',

    if(TicketAge >=61 and TicketAge <= 90, '61-90 days',

    if(TicketAge >=91 and TicketAge <= 120, '91-120 days',

    if(TicketAge >121, 'Above 121 days')))))))),

    if(TicketAge >=0 and TicketAge <= 7, 10,

    if(TicketAge >=7 and TicketAge <= 14, 20,

    if(TicketAge >=15 and TicketAge <= 21, 30,

    if(TicketAge >=22 and TicketAge <= 28, 40,

    if(TicketAge >=29 and TicketAge <= 60, 50,

    if(TicketAge >=61 and TicketAge <= 90, 60,

    if(TicketAge >=91 and TicketAge <= 120, 70,

    if(TicketAge >121, 80))))))))

    ) as TicketAgeGroup,

Thanks,

AS

[#6]

Harsha Thank you for your resp I attached the existing bar chart in that I wanna show the date as the above bar chart

[ToniKautto]

You mention that the X-axis should be 0-29. What does this range mean? Does it represent the age, and number of days from today?

You will probably get a more precise answer if you attach a sample QVW.

[#8]

Bro I 2nd one is my chart 1st one is for reference I just wanna to show the date in my chart like as range in first chart "Slightly bend in vertical direction". That's my question

[PrashantSangle · Accepted solution]

Hi,

If you want to bend your dimension value.

then go to presentaion ->Axis->Dimesion Axes->Primary Dimension Labels->Select Radio Button

Regards

[#10]

Thank you bro.