I am not sure if this would do the trick, but you can use the formula like the one below to pick items of interest and then calculate % of total via quick table calculation (see attached).
I used sample data and looked for brand names in product names instead of your text. It can be easily adapted for any data.
IF CONTAINS([Product Name],'Crayola') THEN 'Crayola'
ELSEIF CONTAINS([Product Name],'DAX') THEN 'DAX'
ELSEIF CONTAINS([Product Name],'Epson') THEN 'Epson'
ELSEIF ISNULL([Product Name]) THEN 'error'
instances of text in name.twbx.zip 412.7 KB
Thanks. I'm learning the tool, to determine if it take care of our PPM (project and portfolio management) needs.
There are more complex cases where we need a count and percent of all data elements (again, text strings)in a field on a monthly basis, and the results need to be trended by month, quarter and year by string in data table and chart form (likely histogram, with trend lines, but would love to get flashier...) The text strings in this field can vary by month (not an infinite variety of strings but the list of strings can be added to at any time, and not all which existed last month will appear in a future month.) The process must do all this automatically, so it must identify the strings on it's own.
This data is typical of project portfolio management in a large organization: not all departments have active projects each month, departments which have never made a request before can make one at any time and new departments are formed periodically. (Have to cope with departments merging too, but let's put that to the side right now.)
I'm looking to not make production generation of these metrics and charts a full-time job and to not worrying that we miss a new "string/department."
We are trying to make a decision as to whether or not Tableau is the right tool for this and had been hoping to find examples of Tableau being used for PPM but have not seen any, so really do appreciate your help!
I think it's probably more appropriate for me to open a separate issue about this and will do so.
Thanks so much!