Changing Date Aggregation with Parameter Dynamic

I’m trying to create a Date Aggregation that will have the following options: Day, Week, Month, Quarter, And Year.

Screen Shot 2023-01-24 at 5.37.47 PM

I have a variety of values and MP, but my main date field is metric_day. I want to show the FY, but have the parameter option to select if the user wants to see it by day, week, month, quarter, or year.

I also want it to change dynamically where if it’s month then change to month format like Jan’23 and day then Jan 3, etc.

Any help would be appreciated!

hi @Phillip_Le,

Date aggregation dynamic change has example in here. you can create calc field using truncDate().

I don’t think we can change date format dynamically though…