Solved

Insight aggregation by week

  • 23 February 2023
  • 1 reply
  • 19 views

Hi all,

I'm trying to aggregate an insight by weeks. When I move the relevant date to the X-axis, it only offers aggregate by week (Sun-Sat), not the week (Mon-Sun) option. See the attached print screen.

I changed my settings to have Monday as the first day of week. But still no luck.

Where can I change the weeks starting on Monday for individual insights?

Thanks!
Adam

icon

Best answer by Michael Ullock 23 February 2023, 13:13

View original

1 reply

Userlevel 2

Hi Adam, 

unfortunately, at this time we do not support the “Mon-Sun” week format in Analytical Designer. Our Product team is aware of this limitation and I believe we have plans for improvements for this in the future. But at this time we have no ETA on when this will come to fruition. But you can "Follow" our Release Notes below to see all the new features and improvements to our platform that will be coming soon here:
https://support.gooddata.com/hc/en-us/sections/203564877-Release-Notes

However, the only work-around would be to use a Custom Date Dimension - but this is still not ideal because the granularity will be still called Week (Sun-Sat), and the calendar pickers will still show Sunday as the first day of week etc. You can download CSV with calendar definition from the documentation, modify it and follow instructions how to upload the calendar definition back to platform, more details on this approach can be found here:
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/manage-custom-date-dimensions

Reply