Dimension in Bar Chart

[krishna20]

Hi Community,

I need to display month and year at X-Axis in Bar Chart, for last three years.Eg;Jan-2012....Dec-2012 .I need to take Calculated Dimension.Having Field as TP_APPR_DT in numeric format.

Please anyone suggest me how to solve it.

Thanks & Regards

Krishna

[ashfaq_haseeb]

Hi,

Can you attach sample data with expected output.

Regards

ASHFAQ

[krishna20]

Dear Mohammed,

Please find the attachments,and guide me how to solve it.

Regards

Krishna

[kaushiknsolanki]

Hi,

Use dimension as Floor(TP_APPR_DT )

Regards,

Kaushik Solanki

[avinashelite · Accepted solution]

Hi Kalyan,

Try like this

=if(year(TP_MonthYear)>='2012',Date(TP_MonthYear,'MMM-YYYY'))

or

=if(year(TP_MonthYear)>='2012',MonthName(TP_MonthYear)) and check the suppress null.

please find the attachment for the same

[er_mohit]

Try this instead of if condition

Monthname(TP_MonthYear)

[krishna20]

Thank You Avinash

Regards

Krishna

[avinashelite]