Getting tags used per category

There is this report, but I guess it kind of works in reverse of what you’re asking for, @jaeson.paul.

I can envision a set of operations that would get you this data.

  1. In a new sheet, specify a category and a date range (just to manage the scope of what is queried… for performance).
  2. Use a QUERY or FILTER function to get all transactions within that date range with the selected category.
  3. Use the SPLIT function on all contents of the Tags column to individualize the tags. (I haven’t tried this but you’d need to create a single concatenated string from the range… and there may be an issue with the string size overflowing).
  4. Run a UNIQUE function against that data to reduce the tags to a list of distinct (non repeating) tags.
  5. Run a SUMIF function to query for each unique tag.

That’s how I’d work up to it.
Hope this flow helps.