Show year,Month and day in X-axis

[sweety0912]

Hi,

I wanted to show X-axis with Year,Month and Day as shown in the attached picture. Please find the attached image and let me know how to achieve this.

Thanks!

Sweety

[Anil_Babu_Samineni]

Try this approach Exclude Zero bars

[balabhaskarqlik]

May be like this:

The script:

LOAD *
,month(YearMonth) as Month
,year(YearMonth) as Year
;
LOAD
date(addmonths(makedate(2009,1,1),floor(rand()*24)),'YYYY MMM') as YearMonth
,ceil(rand()*10) as Amount
AUTOGENERATE 100
;

The line chart:

dimension=aggr(date(YearMonth,if(Month=min(total <Year> Month),'YYYY MMM','          MMM')),Year,YearMonth)
expression=sum(Amount)

Check this link:

How to have 2 fields in the X axis of a graph

[pooja_prabhu_n]

Hi,

You can try like this

dimension= Month& chr(10) & Year