Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the expression for taking month wise analysis of quantity in a line chart when the date is given in numerical format??
Can you share what values do you have for date?
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
I am still not 100% sure I understand your scenario. Can you may be share few rows of your raw data
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
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!
Give a try with this Calculated Dimension: Date(Left(NUM(Date Field),5),'MMM')