Need help using tags

Ask for Help
1

Hi, need some help…

I want to keep track of records with different tags. Each tag# can be classified as good or bad.
Then count the % of each type of tags.

For example,
I can assign tag 1, tag 2, and/or tag 3, to a record.
Later on, I will mark the record as good or bad (for whole record, not just specific tag)

Then I want to get the following:

the % of good tag 1 among all tag 1s
the % of bad tag 1 among all tag 1s
the % of unchanged tag 1 among all tag 1s

the % of good tag 2 among all tag 2s
the % of bad tag 2 among all tag 2s
the % of unchanged tag 2 among all tag 2s

the % of good tag 3 among all tag 3s
the % of bad tag 3 among all tag 3s
the % of unchanged tag 3 among all tag 3s

There will always be more tags in the future and want the same results.

I tried the AI assistant, but don’t quite know how to structure it. Any help is appreciated.

2

From my understanding, you have two columns: one is of type choice list that contains your tags, and the second column is a choice, which can be good, bad, or unchanged.

Given that, you are asking for a formula that you can use, perhaps to display in a widget, where you can correlate how many of each tag is in good, bad, or unchanged.

Do I have the basic idea right?

1 Like