Skip to main content

I’m trying to create a badge that shows the number of times the shape’s text occurs throughout the page. The shape text is coming from column A of a linked data set.

 

This is what I’m trying to use: =COUNTIF(CHILDREN(PAGE)."A",THIS."A")

 

But it just returns a 0.  If I type out the shape’s text long-hand like this I get the count I want: =COUNTIF(CHILDREN(PAGE)."A",THIS="Exact text of column A")

 

How can I get it to count for me without typing long-hand values for every shape?

Try this formula: =COUNTIF(CHILDREN(PAGE).”A”, x => x=THIS.”A”)

The CHILDREN(PAGE).”A” gives an array. The second half of the function evaluates the condition for each value in the array, and the x=> defines the current value we are checking as x so we can compare it.

Hi @JJensen18! 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!

 

Reply


Lucid Software Inc. Supplemental Community Terms