Hello everybody,
First of all sorry for any grammar mistake, but English is not my native language.
About the issue that I'm facing, let me explain some of the context:
I have a chart showing the average of some field (let's say field_A), based on a set analysis selection triggered by a selection of another field (field_B). For example, if I select Value_A from the field_B, the Value_A is used in the set analysis in the expression to calculate the average of field_A. So the expression goes like this:
Avg({<other_field={$(=field_B)}>}field_A)
The issue now is that the user wants to see the char as a trellis-chart, using the field_B as the trellis dimension (because she doesn't wants to select the values of field_B from the list one by one). The problem here is that I don't have the value of field_B selected any more. So, I need to find a way to get the value from the trellis dimension to pass it to the set analysis expression.
I already search the internet without any luck. Hope you can help to find a way or work around.
Regards.