How to find the count of workflows tagged for a district

[swapnilhoderkar]

Hi All,

I would like to find how many workflows are part of a specific district

When i look at a particular district to see how many workflows are tagged under it i am not able to see the entire list.

Is there a way through Gallery or building a workflow against Mongo DB to find total no of workflows per district.

Regards,

Swapnil

[joshuaburkhow]

Hey @swapnilhoderkar 

You might want to look in the 'districts' collection in AlteryxGallery of Mongo. I don't use them so don't have a reference. 

Hope this helps!

[swapnilhoderkar]

Thanks Josh. I will take a look at it and update here on my findings.

[BrianR]

Using the districts and appInfos collections @joshuaburkhow mentioned, you can join on the TagIds.0 / TagId column, which are tied to Districts. Counting on the _id column should give you a count of workflows that are in a given District.