Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'd like to create a pie chart showing number of rows with the word 'Covid' in the 'description' column and number of rows without the word 'Covid'. I'm not sure how to accomplish this. Any help would be appreciated.
Solved! Go to Solution.
@ahhollan , Create new column and use that
if(search("covid",[column],,0) > 0, "Covid" ,"Not Covid")
@ahhollan , Create new column and use that
if(search("covid",[column],,0) > 0, "Covid" ,"Not Covid")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |