Skip to main content
Kenji U
June 24, 2020
Solved

Count Number of Data Meeting Criteria in Shapes

  • June 24, 2020
  • 11 replies
  • 343 views

Hello

I have some shapes linked to data and would like to be able to count how many of those shapes have any partiular piece of data.

The shapes are linked to staff data so I would like to be able to have a formula to automatically count the number of staff with a particular skill set staff based in a particular location. etc etc

Thanks

 

Best answer by Shanna H

Hi Kenji Thanks for reaching out on Lucidchart Community! You can create Conditional Formatting rules to show these variations based on Location skills etc. To learn how to set up your Conditional Formatting on your document I suggest checking out our Conditional Formatting and Icon Sets article

Just to provide a general example in this screenshot below I have created two Conditional Formatting rules for my data set. One is that if the text contains "Tree" the Shape Style>Fill Color is green. The other rule is that if the text contains "Imported from SA" there is a pink circle icon in the upper right corner of the shape. You can customize these as desired to represent your information.

Uh57uA5u1yqpFsEDUI1lyA.png

Please let me know if you have any other specific questions after checking out the article and following the steps outlined there! Hope this helps!

Comments

Abby S
Lucid community team
May 3, 2024

Hi @Kenji U! I’m Abby from Lucid, reaching out because I think you, and others who might come across this topic in the future, might be interested in Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!