This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How do you group dates by groups in analytics? So that you can group all values within a single month into one collumn instead of multiple

You can apply the Grouping in the Workbook "Date Hierarchy when you add the Date field to the Layout.

<@U01E037GJ84> Where do i locate that? :slightly_smiling_face:

there is no pop up thhat shows date Hierachy

<@U01E037GJ84>

I can only find this filter when i add the date field to the layout

when i add it, i can find the grouping option there. But there is no option available so that i can group by month, and combine all the values for each day.. so that it shows all the values for one month summed together

But i dont get any values when i select pivot

oh now it works, had to press refresh. Thanks <@U01E037GJ84>!