Dynamic grouping / rollup by day, week, month

Hello - I’m wondering if it is possible to update the view of graph by different date aggregations, Ex. the user would be able to specify in a filter/parameter if they would like the data rolled up by day, week, month etc.

Yes, that is possible. You can create a level that is based on a formula, that will show either a day, or a week or a month, depending on a user selected parameter.

  1. Create a parameter “Time Period Parm” with the list of values of:
  • day
  • week
  • month

Then create a formula
[Order period] = Switch([Time Period Parm],“day”,DateTrunc(“day”,OrderDate),“week”,DateTrunc(“week”,OrderDate),DateTrunc(“month”,OrderDate))

Then you would create a level based on this formula.