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
Chem
2
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!
1 Like