Hi, I'm trying to plot two different counts of date value fields (register_date and conclusion_date) and a third which should be calculated (should be the cummulative sum of registered docs - the cumulative sum of concluded. Also having trouble calculating it).
Using the traditional Vertical Bar visualization I found no way to plot both date fields witout aggregating one within the other (ie: only show the register_date per conclusion_date or vice-versa) - I believe it would be possible if I could open more than one X-Axis, but ideally I'd like to plot both on the same "neutral" time axis.
I tried it in timelion, and in the visual builder as well, which do plot both counts independently. However both don't seem to be able to plot the bars unstacked. I've scoured the docs and didn't find how to do that.
Regarding the third field, I managed the cummulative sum of registered docs easily using the cummulative sum metric, but I'm not quite sure how to subtract the cummulative sum of concluded docs.
Any help would be appreciated. Thank you.