Add resource_cnt column to c_system_use tables

[gotdan]

It seems like these values are mostly interesting in the context of the total resource count in that category, status and year.

[mikix]

This and #32 seem like yet another cube vs aggregate issue. A CUBE provides that info automatically.

But you could also get it by summing up the aggregate rows, right?

[gotdan]

I think that's only true if a terminology element is populated in all resources though. If I want to get a sense of how many Encounters I can find with a particular coding, I think the total number of Encounters would be the more useful denominator, not the total number of Encounters with a coding populated.

[mikix]

The rows with cumulus__none for the systems field will tell you the count of Encounters without any terminology element populated (as well as Encounters with the element populated but no actual system filled in).

So you should still be able to sum up to get the total.

[gotdan]

Ah, cool, in that case agree that summing in a query in the presentation layer could be a workaround.