How to Aggregate Daily Data into Weekly Totals in Domo?

chetan_cricut
chetan_cricut Member
in Charting

I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals.

I've tried various approaches but haven't been able to get the desired weekly aggregation. How can I modify my dataset or settings in Domo to correctly display the aggregated values by week instead of by individual date? Any guidance or suggestions would be greatly appreciated!

image.png

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    Because you're sorting on your event date it can't aggregate your mon_adjust calculated date. If you sort based on your mon_adjust column instead it may resolve your issue.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • akhilsharma
    akhilsharma Member

    @GrantSmith sorting isn't solving the problem as well. Anything else, that we can do?

    image.png

Categories