I've been poking at this for a couple of hours, I think I'm missing something obvious but it's a forest for trees thang.
I have to create 2 dashboards, first is done and tested sat, second uses all of the first except the last line. No, I can't post the exact code. Suffice it to say, I have aggregated 6 fields, a, b, c, x, y, z.
In the first panel, I had to sum a, b, c and then display them in a timechart span=1mon as a stacked bar chart. Works great.
In the second panel I have to sum x, y, z, then take that and subtract it from sum of a, b, c, and present sum of x, y, z and diff (a+b+c) - (x+y+z) in a stacked bar chart, span=1mon.
Here's the line I have to try to do this, but its not presnting any values (nor errors):
| timechart span=1mon sum(eval (sum(a) + sum(b) + sum(c)) as value1) sum(eval (sum(a) + sum(b) + sum(c) - sum(x) - sum(y) - sum(z)) as value2)
Am I allowed to do an eval inside a sum? Is that the issue?
... View more