Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Only first word shown #21

Open
bontchev opened this issue May 28, 2023 · 0 comments
Open

Only first word shown #21

bontchev opened this issue May 28, 2023 · 0 comments

Comments

@bontchev
Copy link

I am trying to use this plugin in a visualization that shows the data gathered by a honeypot. The data source is MySQL. The relevant data is in a table named auth, which contains, among others, the fields timestamp and password. I want to display a word cloud of the passwords used.

I use the query

SELECT
  password as Password,
  COUNT(password) AS Count
FROM
  auth
WHERE
  $__timeFilter(timestamp)
GROUP BY Password
ORDER BY Count DESC

If I format this as a table, the data looks fine. But the word cloud plugin displays only a single word - the topmost (most frequently used) password. What am I doing wrong? What is the format of the data expected by this plugin? I guess I don't understand what you mean by "group by terms" in the documentation. I am grouping by the passwords used - i.e., the terms I want displayed in the word cloud. Should I be doing something else? I did set Count as the "Count Field" and Password as the "Tags/Words Field" in the settings but it made no difference.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant