1 of 1 people found this helpful
you say it is returning a value - what is the aggregation that it is using when it returns the value - i.e. you drag it into the viz and it is going to aggregate the value of the case statement for each of the records that contain that month value
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I believe you directed me in the right direction. I switched from SUM to AVG and it works know.
I'm not sure why the SUM wouldn't work though. It would only return one number.
Glad to help out