Help editing a Named Query turned into JSON

I was given a script on here a long time ago to turn an hourmeter query into a pie chart

but now im trying to tweak it to just show a number

Im trying to get it to just show the red underlined number in here , but its showing all that stuff from the

output.append part of the script, when i remove the output append part it breaks it, any idea how to get just the number for the result?

Is Minutes the same every time? If so you could probably reduce the entire thing down to something like

return value[-1]['Minutes']
1 Like

it is counting up every minute

But if the column name doesn't change, then this should probably work.

1 Like

I finally got a chance to try it today and it worked like a charm, your a boss