Item/Shape Counter to sum the number of cards in frame

Wow. This is great - I really appreciate your help. 

I actually do have some shapes that I’d like to exclude - the colored tiles. The name tags are below them (cut off for privacy).

Thanks

Also, is there a way to have individual counters for multiple areas within the same frame?
 

Certainly! I changed the formula on the badge from =COUNT(CONTAINED) to =COUNTIF(CONTAINED, x => SHAPETYPE(x) = “LucidCardBlock”). Here is a gif where I make that update and another gif showing how I got the shape type of the shapes.

Just saw your most recent question. We can get counts for subsections by putting those in frames as well. If you don’t want them to appear to be in additional frames, we can make them appear invisible. Looks like from your use case that we can maybe leave the frame title, which would make them easier to select and align.

Hopefully this helps.

Lance, hope you’re doing well. Just had another question related to this topic. Please see the image below.

I’d like to create a rule that adds up total number of Lucid cards (indicated by yellow circle at top right), but exclude “ATTRITION” & “LEADERSHIP” frames. Do you think you could assist with this?

It’s just so we can accurately see how many people we have on-site at a glance.
 
Thanks so much. 
 

This one took a bit. First, I added a property to the two frames I wanted to exclude. I called the property “Exclude” and marked each as “true”.

On the outer frame, I added the conditional formatting rule that set the badge text to

=COUNTIF(CONTAINED, x => AND(SHAPETYPE(x) = "LucidCardBlock", COUNT(MAP(CONTAINEDBY(x), y => y."Exclude" = true)) = 0))

It counts items contained in the frame if they are a “LucidCardBlock” and are not contained by any frame that has the “Exclude” property set to true. This will also work if you have frames nested in each other and add “Exclude” to the outer frame. In this example, the outer frame count is 7, and the exclude property is on the purple and pink frames in the top left.

Let me know if you have any questions or if it’s not working. And thanks for the interesting challenge!

Hi,

Thank you so much for the reply. What should the “If” parameters be? Once I have this I should be good.

 

You’re welcome! I just chose the formula option and entered =TRUE because I always wanted it to show up for the shapes I selected.

Lance,

Just a follow up question for this thread. I’m trying to make a smaller, separate frame that calculates how much of our workforce is gone using the total in “ATTRITION” and the total of the entire chart (both highlighted)

Any advice on how to best go about this?

Thanks again.