Aggregation by month with segmentation
I am breaking my head about something that just feels so easy to get. Is there somebody who can help me out with this please?
I want to show a bar chart grouped by month (please see example below). The bars then should be segmented into categories. The data is coming from the user activity in a tool. The idea is to show for each month how many users do have activity on e.g. 1 day that month, 2 days, that month, etc.
I attached the table with example data coming from the data flow I want to use. Each row represents an action done by a user in the system. These actions do have a respective userid and date.
Thanks so much for supporting. It just sounds so easy but I was not able to "beast mode/case when" it...