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.
- Create a parameter “Time Period Parm” with the list of values of:
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.