It has [Steps Date] as its only dimension, another line with <vStepsDailyGoal not met, and another line totaling the two.
I have a pie chart beside the line chart that relies on a vStepsGoal expression, and after a little operator feedback I decided to modify the above expression to rely on vStepGoal so people would only have to input the one goal. I tried variations of this to no avail:
If I try just Count(), or use / instead of Div() I get expression error messages. The RangeCount() pulled me out of expression error messages, but flat lines the goal met line at 0 for all days. I had 7 days selected, 7000 in the vStepsDailyGoal and 49000 in the vStepsGoal, so it should work out numerically.
But people might have occasion to select 8 days or 6 days and I'm trying to accommodate this by just counting the days ([Steps Date]) they've selected. I know I could probably make a variable input box for them to enter the number of days, but my objective is to cut from 2 input boxes to 1, not replace one with another.