Aggregate Running Total
I am trying to create a running total chart that calculates the aggregate running total as the day goes on. However, using the running total chart in DOMO, it sums up the amounts per time period rather than take aggregate amounts. I am hoping someone out there has come up with a solution for the way the chart is built.
To illustrate the problem assume I have a data set that has these amounts:
and I've written a beast mode calc that is Sum(Amount1)/Sum(Amount2).
I put it into a running total chart and DOMO give me this:
However, what I want DOMO to do is sum the amounts first, then divide so that I get a chart that looks like this:
Has anyone come across this problem before and possibly have a solution?