Calculated Field for Word Frequency in Word Cloud
I have a card which uses the word cloud visualization to show the different search terms my Domo users are searching forover the last 30 days. It sounds great in theory however it is displaying too many words, making the word cloud hard to read.
As such, I want to create a calculated field for the word cloud that omits all words that have been searched less than three times. I've looked everywhere but can't seem to figure out how to do this. Can someone give me some guidance please?
Its worth noting that due to my company's setup of Domo, using Magic ETL and creating a new dataset/flow aren't possible options for me to explore.
Thanks
Comments
-
I don't think you will be able to create a filter. However, if you create a beastmode that counts the number of times a value was searched for you should be able to accomplish something similar using the DATA TABLE to limit the number of rows. COUNT(DISTINCT `Value`) This should give you the distinct count for each "Value" that was searched for. You would then set up your Word Cloud so that WORD NAMES = `Value` and WORD VALUES = the above beastmode Sort by the distinct count in descending order. You can then limit the number of rows being used by using the DATA TABLE. The number of rows that you select will be the number of Values that the card displays. If you only want to see the top 20, then use 20.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 182 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive