Date Issues

[Anonymous]

Hi ,

i have a date field which is displaying how I wanted , the expression I have used is Date("recorded_at") as "Month/Year",

but it is splitting the date on each day in relation to the Service Type column,

How to get the Month/Year supposdely for example Oct 2016 we want to show collectively rather day by day.

[sunny_talwar · Accepted solution]

May be like this:

Date(MonthStart("recorded_at"), 'MMM/YYYY') as "Month/Year"

[Anonymous]

Hi sunny .

It is working partially But i wanted like picture 2.

[sunny_talwar]

Use a pivot table and drag MonthYear dimension to the top of the chart

[Anonymous]

Oh ok .I did that earlier.

It is working.

So for a straight table is that possible?

[sunny_talwar]

Use an expression with set analysis....