First, it seems the selection method of wordcloud chart is not based on frequency. If the size of word set is less than 10, it gives me a blank chart. It may be a bug.
Second, the input of wordcloud is not friendly. Why does it only accept repeated words, rather than (word, count)?
In real case, I often filter very low freq words:
SELECT key_word, count(1)
FROM events
WHERE xxx
GROUP BY key_word
ORDER BY count(1) DESC limit 100
Now how to convert [(word, count), …] to [word1, word1,… word2, word2…]?

I’ve found the same issue and it’s an open issue on github Word Cloud visualization improvements · Issue #1414 · getredash/redash · GitHub
that you can follow.

1 Like