How to sum values based on date (daily ,weekly, monthly)

Ask for Help
2

I don’t see a Date column in your table?

But, a general approach to summarise data by date is as follows:

  • Use a math column to convert the date to an integer in yyyymmdd format:
Year(Date)*10^4
+Month(Date)*10^2
+Day(Date)
  • Create a multiple relation column that matches the math column with itself.
  • Use a Rollup->Sum via the relation to sum the value/s that you’re interested in.
3 Likes