How to Subtotal?

Rob van Wees's Avatar

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

    john's Avatar

    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

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

    Rob van Wees's Avatar

    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 :)

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

25 May, 2024 11:52 AM
24 May, 2024 07:39 AM
16 May, 2024 02:11 AM
16 May, 2024 01:58 AM
14 May, 2024 01:29 AM

 

13 May, 2024 12:36 AM
12 May, 2024 07:46 PM
05 May, 2024 04:38 PM
03 May, 2024 06:50 AM
03 May, 2024 12:30 AM
03 May, 2024 12:09 AM