Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've build a list box shiwng the felds in the model by $Field.
Is there a way to use $Field in the visualisation so that it does not show the name of the field but the actual contents of that field … something like $($Field) or a specific function/formula ?
Why : I would like to make visualisation / statistics on population/content of the field(s) that I select in the list box; having to make only 1 set of visualisations instead of making measurements/visualisation per field …
@HWallays , try something like:
=Count( $(='['&$Field&']') )
i use =Count(Distinct [$(=$Field)]) for this purpose:
TH
I have the same needs. But I try to use that and doesn´t works. When I try to calculate the =Count(Distinct [$(=$Field)]) the system doesn´t understand the chararcters [] and in the object show the formula: =Count(Distinct [(-]).
I have tried many different ways but when I introduce the $Field in some expressiones (Count, sum, etc...) the system doesn´t understand