Hello, I'm trying to set up three calculated dimensions that I can use in a cyclic group for a chart. Each calculated dimension should show the selected values of the same field but for different alternate states. Below is my current expression:
I added this cyclic group to a bar chart and set the expression to =1. All I want to see right now is the dimensions change based on the cyclic. However, the only value that I'm getting is '-'. Any ideas of what is happening here?
Huh, that's interesting. I compared yours to mine and I can't see any difference, which makes me believe that it is my data that is causing the problem. I added the aggr() expression to a text object and it returned the correct value when one value was selected, but would show '-' when I had two or more values selected. Can you think of any reason within my data set that would cause that? The [Entity Name] field contains unique values.