I need to dynamically change Columns in CRM Analytics Dashboard. I need to change Columns with list selector.
2 answers
You can create a static query for grouping for list filter, something like this
Then in your table add the selection binding.
q = group q by ({{column(Dynamic_Grouping_1.selection, ["Text2"]).asObject()}});
q = foreach q generate {{column(Dynamic_Grouping_1.selection, ["Text2"]).asObject()}}, sum(q.'Amount') as 'A';