I have a simple line chart with 3 measure values and one dimension , Is it possible via any option or customisation to let's say if any user wants to visualize only one line representing one measure rather than all 3 ( as by default we have 3 lines) as we have this feature in other BI tools like looker and tableau
Thanks in Advance
I didn't tested but maybe with a toggle with the measures and data binding them to the query measures of the chart.
Static query for the toggle widget:
"static_1": {
"type": "staticflex",
"numbers": [],
"strings": [],
"groups": [],
"columns": {
"Display": {
"type": "string"
},
"Measure2": {
"type": "aggregate",
"dataset": {
"name": "opportunity"
},
"aggregateFunction": "Measure2__func",
"field": "Measure2__field"
}
},
"broadcastFacet": true,
"selectMode": "singlerequired",
"values": [
{
"Display": "count of *",
"Measure2__field": "*",
"Measure2__func": "count"
},
{
"Display": "sum of Amount",
"Measure2__field": "Amount",
"Measure2__func": "sum"
}
],
"label": ""
},
And bindings similar to these:
measure1 (count rows) ---> row(static_1.selection, [0], ["Measure2__field", "Measure2__func"]).asObject() --> ["*","count"]
measure2 (sum of amount) --> row(static_1.result, [1], ["Measure2__func", "Measure2__field"]).asString() --> ["sum","Amount"]
