what is the expression for taking month wise analysis of quantity in a line chart when the date is given in numerical format??

[#1]

what is the expression for taking month wise analysis of quantity in a line chart when the date is given in numerical format??

[sunny_talwar]

Can you share what values do you have for date?

[#3]

i am having quantity values for various dates  eg: 19/04/2016 20/04/2016... 1/05/2016, 23/05/2016

there are various dates i need the quantity for the each sepearte month

[sunny_talwar]

I am still not 100% sure I understand your scenario. Can you may be share few rows of your raw data

[Anonymous]

if i understand correct you Need to define a Dimension as month(yourdatefield)

you may Format the month to ypur requirements

month(yourdatefield,'MMM') will Show you May, Jun etc. for your datedimension

the values will be automatically presented monthwise

[Anonymous]

Hi maikanta,

With Month() you will get the month from a date, don't worry if Date is in numerical or date format.

With MonthYear() you will get the month with the year.

All date functions work equally in numeric format or date format.

Regards!

[iahamedabdullah]

Give a try with this Calculated Dimension: Date(Left(NUM(Date Field),5),'MMM')