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?