banana
banana copied to clipboard
lucidworks
2 Histogram panels on the same dashboard
I have a requirement to draw 2 histogram panels with different queries on the same dashboard. Seems like I can have only one query panel which is tied to the histogram/hits panel, Can you let me know if its possible to have 2 histogram panels with different queries?
v1.5 supports multiquery which renders on histogram as different series. You can also have more than one histogram panels on the same dashboard with different custom queries that can be configured under "Queries" tab of each panel. This applies to other panels as well.
My requirement is to have 2 histogram panels like this - 2 different queries - these are non-numeric fileds, so i cannot use group by also...how can I use multiquery for this?
From: Ahmed Adel [email protected] To: LucidWorks/banana [email protected] Cc: Harshini Mariswamy/India/IBM@IBMIN Date: 03/26/2015 03:59 PM Subject: Re: [banana] 2 Histogram panels on the same dashboard (#158)
v1.5 supports multiquery which renders on histogram as different series. You can also have more than one histogram panels on the same dashboard with different custom queries that can be configured under "Queries" tab of each panel. This applies to other panels as well.
— Reply to this email directly or view it on GitHub.
Using the leftmost button on the query text box (the plus sign), you can add more queries to the dashboard. You may specify it in the form of field:query where field can be of any type.
let me help clarify:
We desire to trend over time the count of messages grouped by a given field. This isn't a numerical field. I'd assume these query parameters is how it's done, but I'm not sure where to place this - what panel, etc.
&group=true&group.field=FIELD
so that the count of each value is rendered as its own series on the histogram. Limiting this to TopN or BottomN would also be nice.
A bit deeper exploration - I can see the results in the query I think I need - but how can I return a value ("numFound") into the histogram as unique series by group ("groupValue")? It seems if I could map in "numFound" into the value expected for each series "groupValue" that this would work.
The top portion of the histogram panel is right, just missing the value to be plotted. I wouldn't want the default query results, but only the actual "groupValue" results.
View | Zoom Out |
{ "responseHeader": { "status": 0, "QTime": 180, "params": { "fl": "timestamp numFound", "q": ":", "group.limit": "100000", "group.field": "conditionName_ts", "group": "true", "wt": "json", "fq": "timestamp:[NOW/MINUTE-5MINUTE TO NOW/MINUTE+1MINUTE]", "rows": "100000" } }, "grouped": { "conditionName_ts": { "matches": 319, "groups": [ { "groupValue": null, <-- this is the default query results, not wanted "doclist": { "numFound": 317, "start": 0, "maxScore": 1, "docs": [ { "timestamp": "2015-03-26T15:58:00.594Z" },
snip
]
}
},
{
"groupValue": "Error", <-- this is the groupValue desired
"doclist": {
"numFound": 2, <-- this is the results for groupValue
"start": 0,
"maxScore": 1,
"docs": [
{
"timestamp": "2015-03-26T15:58:05.59Z"
},
{
"timestamp": "2015-03-26T15:58:05.589Z"
}
]
}
}
]
}
}
}
