Dear Friends,
Iโm new on AppSheet and itโll be amazing if there is someone who can help me with the following scenario.
I have a google sheet with a list of shops and their products. I added a virtual column with the following formula OR(CONTAINS([Product],โCoca-Colaโ),(Contains ([Product], โCokeโ))) to tell me how many shops contains the following text.
Now, I want to create a graphic showing me the total number of shops that contains the text above vs how many doesnโt, for example, I have a total of 100 shops and 80 shops have the product and 20 shops donโt have.
Does anyone know the best way to do that?
Thanks,
Bruno
One tool I heavily use is
Pass any texts from your fields which will generate the placeholder/icon/graphics either way you call in a dynamic way.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |