beastmode
I working on a categorical text dataset with thousand of rows, I have a text column called 'indicatortext' with 21 distinct values , I have another column called 'result' with 7 distinct values, I want to create a table with indicatortext as the row and the percentage occurrence of one of the categories in result column, also the count occurrence of one the categories in result column based on the indicatortext columns(basically how many times, and the percentage occurrence of a categories is appearing for the distinct text in indicatortext column.
I have the below code for percentage COUNT(CASE WHEN `Result` LIKE '%NonCompliantUrgent%' THEN 1 END) / COUNT(DISTINCT `IndicatorText`) OVER (PARTITION BY `IndicatorText`) but i am getting zero's as the outcome
this the outcome i trying to get
Answers

@NIKKI Do you plan on having a single row per value of the Indicator Text field? If so you do not need to partition by that field in your card because your data will already be grouped by that field. Also, note that your denominator will always be 1 in this case based on your current formula. If that's not what you want, then you can remove the word DISTINCT from your formula to calculate the percentage based off the total number of rows.
1 
Thank you Michelle,
I tried this COUNT(CASE WHEN
Result
= 'NonCompliantUrgent' THENIndicatorText
END) / COUNT(IndicatorText
). but I am still getting zero's populating on my tabel0 
What I plan on having is the percentange of noncompliant category in result column by the distinct text in indicator text column
0 
Yes, I even use wildcard, LIKE %
0 
this is what the raw data looks like.
The first column is the indicator text and the 2nd column is the result with categories.
this is what the output looks like
0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 288 Workbench
 4 Cloud Amplifier
 7 Federated
 2.8K Transform
 94 SQL DataFlows
 593 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 667 Beast Mode
 42 App Studio
 34 Variables
 644 Automate
 165 Apps
 434 APIs & Domo Developer
 42 Workflows
 3 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 378 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 5 Software Integrations
 109 Manage
 106 Governance & Security
 8 Domo University
 23 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 95 Community Announcements
 4.8K Archive