I am working on dashboards that go to a client and would like to add a dynamic Title that reflects the chosen stack.
The only way I know to get dynamic text is to use the content view and a formula. However, I cannot find an option that will allow me to show which stack is showing. Specifically I want to give the customer the option of choosing between 2 stacks and the title to the chart should change according to which stack is chosen ( in this case the performance indicator ECOG & Karnofsky Index).
You can use formulas in each chart title, for dynamic results, just surround it by double brackets e.g. {{SUBSET_SINGLETON([Field])}} worked example: http://forums.visokio.com/discussion/2485
You may wish to use the Content view, with the same formula, as it will be more responsive to selection (Singleton function will work if you do select>keep).
Thanks that is a really good function to know. But what I need it the name of the field selected in the stack option.
Eg if the client chooses to stack by ECOG then ECOG should be the header and if the client chooses to stack by Karnofsky index then Karnofsky index should be the header.