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…]?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
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