I have my data in a daily form for a predefined period of dates (2021-06-01 until 2021-10-31).
@date returns values as 2021-10-25
@othervalue returns values as a simple number, for that day.
1. The simple version of what I'm trying to do is show a bar chart for the @othervalue grouped by month. Basically, I want to see 5 bars with sums for June, July, August, September, and October.
2. A more complicated version of what I'm trying to do is, I have a user input that allows me to pick whether I want to group my values by day, week, month, or quarter. How do I change the bar chart in #1 above to reflect this?
I've looked at a bunch of posts here, and nothing I did (tried using GROUP and GROUPBY) did not accomplish what I was trying to do.