hello ,I’m using grafana cloud and my current statement is
error
Figure 2
How can I solve this problem?
I understand that you’re querying logs.
And in the timewindow you selected, you have more than 1000 different (visitorId, deviceType) combinations, and you hit a limit.
You could try to :
• Reduce the time window
• Filter down your logs
• Maybe asking for the top counts (via topk) would also fix it and give you a satisfying output
Do I need to adjust the statement?, how do I do that?
No, I can’t solve my problem, my time is a day, I want to count the events clicked by my different users, which means that I have more than 1000 user click events in a day, but the highest Kanban is 1000,
Do you really want to have a graph with more than 1000 lines? What kind of information do you expect to get from this? How will you read it?
Of course, we want to analyze the dimensions of users on different ends, and our users are visitorId, and now we have more than 1000 volumes a day
I mean, what kind of analysis do you want ?
I really don’t see how you could make sense of a graph showing 1000 lines in a grafana dashboard.
Examples of things which could make sense :
• If you want to know how many visitors you have, you could count individual visitorId (and have one value)
• If you want to know how many queries each visitor does, you could build a histogram. Way more concise and easier to read.
It all depends of what kind of information you expect to see on your graph.
The first point you said
The current query gives you one line per visitorId.
If you want to count the number of lines, adding a count() around your query should do it.
