Group by week or month?

I have a table with a bunch of records each of which has a Date field. I created a function field whose formula =

WEEKOFYEAR ({Date})

and it returns a value. But the Page Builder won’t let me group on this field. Why not? What am I doing wrong?

William

Hey @WilliamPorter,

I’ve created a report internally about the number output and date type for Equations not grouping correctly.

However, I did find a way to work around this. To group by month, you may add the following Equation.

CONCAT('<span',CHAR(32),'class="hidden">',DATE_FORMAT({Date},'%Y/%m'),'</span>',DATE_FORMAT({Date},'%M-%Y'))

It will group your records by month as shown in the image below.

If you want to group a bit differently, do let me know and I’ll see what I can come up with! :smiley:

1 Like