Home → NodeBox 3 →

How to Subtotal?

• Edit

Rob van Wees

08 Nov, 2017 12:13 PM

Hi all,

Is there a way to get subtotals out of a list?

I have (in the Sankey test) a list of cities with attached numbers of court cases. I want to subtotal those by city. Is there a way to do that?

Cheers,

Rob.

1. Support Staff 1 Posted by john on 08 Nov, 2017 11:13 PM

   

   Hi Rob,

   Yes, it's not too hard.

   Make a subnet which filters your table by a city, looks up the cases, and returns a sum. Then all you have to do is lookup a distinct list of cities and feed that into your subnet.

   Screenshot and demo network attached. The subtotals subnet can be used with any table.

   John

   • subtotal_screenshot.png 188 KB
   • Subtotal_Demo.zip 1.74 KB
   • Edit

2. 2 Posted by Rob van Wees on 09 Nov, 2017 12:55 AM

   

   Thanks John, I'll have a go at that.

   In the mean time, have a look at the Sankey diagram thread, I put a version with subtotals there. That shows the view I was going for.

   I did all of the counting outside of NodeBox, gonna try to do it with the subotals subnet next :)

   • Edit