We would like to create macro-based analytic and use it in Heat Map Manager.
1. Should the macro return a specific value or just modify the current diagram.
2. How is it hide the macro results when deselecting a specific analytic in the heat map? (in case the macro changes a value has depiction is there a way to change the value when the analytic unchecked in the heat map manager?)
3. Is there somewhere example for the described above? (macro for analytic)