Bar Chart X Axis Values

[MK_QSL]

Please check enclosed file showing Trellis Bar Chart.

What I want is to show Bar Chart X - Axis Timing as 10:00, 11:00, 12:00 without changing the size of bar chart.

The Bar corresponding to 10:15, 10:30, 10:45 etc should be there but only bar chart should not show the name.

Hope my requirement is clear...

[arthur_dom]

It's that( attached file) ?

I used this expression:

time#(text(if(Customer = 'X' , time(Time#(Time,'hh:mm'),'hh:00'), Time#(Time,'hh:mm') )),'hh:mm') as Time

[MK_QSL]

Dear Arthur,

Thanks for your reply.

Looks like you misunderstood the question.

I want all bar but the axis should only show full Hour ... i.e. 10:00 11:00 12:00

[crusader_]

Hi Manish,

PFA qvw file.

Hope I understood you correctly if not please reply.

Andrei

[tresesco]

Create a new field, like:

Dual(Time(Time#(Time,'hh:mm'),'hh'),Time#(Time,'hh:mm')) as Hour,

And use that as dimension. See attachment.

[MK_QSL]

Looks better and yes, you completely understood my requirement but can't we do it without using Continuous and Static Step in Axes Tab?

[tresesco]

Have a look at the attachment I tried.

[MK_QSL]

Yes but this is not I am looking for... Thanks for your suggestion Tresesco

[crusader_]

Hm... Let me think.

You can try to mix some approaches.

Look this thread

Dimension Text type in a barchart

I like giakoum

solution, then in your case you just change Text Color to White() in 15, 30, 45 minutes and Black() in 00 minutes.

I hope this helps.

Andrei

[tresesco]

May be like this?