I would like to create a bubble chart that will cycle through dimensions.
I want to have:
the values on the Y-Axis
the bubble size the sum of values
Days in the X-axis
It seems that having the day number on the x-axis causes a problem with this type of request.
I've uploaded the application but you can see that some values do not appear in the graph but they have multiple values for a dimension on the same day.
Scatter chart is the right pick for your requirement, generally in Scatter chart both x and y axis should be expressions, but day is a dimension. Instead of using Scatter you can go for either Bar or Line chart. You can analyse based on the bar height in the bar chart and the position of line in y axis.
