Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have stacked bar chart with 5 different values which I am getting from my SQL query.
Different stack showing different value in different colors. And that's fine.
Now I want to merge two different stack value and show as one ( as the same color), How can I achieve that without modifying my SQL query.
Put a preceding load on top of your SQL query where you combine the two different values into one value. If you don't want to modify your script you can try using a calculated dimension. Something like =If(MyFieldHere = 'FirstValueThatShouldBeMerged' OR MyFieldHere = 'SecondValueThatShouldBeMerged', 'NewMergedValue', MyFieldHere)