Forum Discussion

pbimhkc's avatar
pbimhkc
Frequent Visitor
3 years ago

Changing date look back when using field parameters?

I have a stacked column chart that is summing an account balance on the y-axis with the date as the x-axis. I am using field parameters with both axes, with the x-axis having a toggle to group the account balance sum either daily, weekly, or monthly. This is working mostly as expected however I want the date lookback to be dynamic based on the field parameter chosen. By default it is going back 7 days when days is selected, 12 months when months is selected, and 13 weeks when weeks is selected. I would like it to go back 5 weeks when days is selected, 6 months when weeks is selected, and 13 months when months is selected. Is this even possible? Thank you

1 Reply