Comparing against a series
Happy Domo Dojo day!
Does anyone have any suggestions on how to dynamically do comparisons on a series? For example, let's say you have a grouped bar graph that shows Net Sales on the Y axis, months on the X, and the series is 2017 and 2016.
I can see the 2016 and 2017 sales easily enough. I can do some basic math to get the difference and of course the higher bar has more sales. But what if I want to see what the growth % is?
Currently for any comparisons like this I have to do it in the dataflow so that it is on one line and then I might as well do the math right there. This works but it isn't dynamic. I can't compare things on the fly.
I'm open to any suggestions.