grafana: how to sum values from query into a singlestat or other plugin?How can I calculate bandwidth usage per day or hour with Grafana, graphite and collectd?grafana / collectd Write Graphite plugin change timestampHow to plot the sum and the individual components in Graphite?how to move a grafana panel from bottom to top without exchanging the top one with the bottom?Generate graph in Grafana from APIGrafana will not restart after update from 3.1 to 4.3Set Grafana dashboard variable from Prometheus scalarHow to make grafana GDPR compliantHow to install a second Grafana instance to run alongside an existing Grafana instance?Using Grafana to calculate and display disk capacity from free% and free MB
Formatting Datetime.now()
Why is my arithmetic with a long long int behaving this way?
Why did WWI include Japan?
To kill a cuckoo
Are pressure-treated posts that have been submerged for a few days ruined?
Where to draw the line between quantum mechanics theory and its interpretation(s)?
Are there terms in German for different skull shapes?
Find magical solution to magical equation
Correct way of drawing empty, half-filled and fully filled circles?
Why would a military not separate its forces into different branches?
Is 'contemporary' ambiguous and if so is there a better word?
How to pass hash as password to ssh server
What was the first story to feature the plot "the monsters were human all along"?
Why symmetry transformations have to commute with Hamiltonian?
Copy previous line to current line from text file
Is there a word that describes the unjustified use of a more complex word?
Handling Null values (and equivalents) routinely in Python
SOQL query WHERE filter by specific months
It is as simple as ABC
Notation: What does the tilde bellow of the Expectation mean?
Is an HNN extension of a virtually torsion-free group virtually torsion-free?
When does tabularx decide to break the cell entry instead of reducing the columns separation?
What are the advantages of luxury car brands like Acura/Lexus over their sibling non-luxury brands Honda/Toyota?
Endgame puzzle: How to avoid stalemate and win?
grafana: how to sum values from query into a singlestat or other plugin?
How can I calculate bandwidth usage per day or hour with Grafana, graphite and collectd?grafana / collectd Write Graphite plugin change timestampHow to plot the sum and the individual components in Graphite?how to move a grafana panel from bottom to top without exchanging the top one with the bottom?Generate graph in Grafana from APIGrafana will not restart after update from 3.1 to 4.3Set Grafana dashboard variable from Prometheus scalarHow to make grafana GDPR compliantHow to install a second Grafana instance to run alongside an existing Grafana instance?Using Grafana to calculate and display disk capacity from free% and free MB
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Is it possible to make a sum of values - depending on multi-selections in query (templating) - and showing those in a singlestat plugin in grafana?
setup:
- grafana 3.1.1
- datatsource: graphite
Use case:
A query-based dropdownlist allows me to select a logical volume.
The singlestat then shows me the size of this logical volume.
Now I have a multi-select query list so I'd love to achieve that the size value for each of those selected logical volumes is summed and shown in the singlestat.
I've been trying to find some function and I know there are sum functions but in my case, I don't know which are going to be the results of the selections in the templating query and there doesn't seem to exist a way to automatically add an "invisible" query to the metrics section while only showing a sum-of-all-queries-metric.
Are there any options to achieve this?
a sample query:
collectd.$host.$volumegroups.$logicalvolumes
where all 3 values are from a templating query with results like:
$host => the server in question
$volumegroups => vg00 (LVM Volume Group)
$logicalvolumes => lv_data, lv_root, ... (LVM Logical Volume)
Now when selecting multiple "$logicalvolumes" from the dropdown ofcourse, the singlestat goes "N/A".
In the list of plugins on grafana website, I don't find any other plugin to match this need.
graphite grafana
asked Mar 29 '17 at 11:42
lievendplievendp
56118
add a comment |
Is it possible to make a sum of values - depending on multi-selections in query (templating) - and showing those in a singlestat plugin in grafana?
setup:
- grafana 3.1.1
- datatsource: graphite
Use case:
A query-based dropdownlist allows me to select a logical volume.
The singlestat then shows me the size of this logical volume.
Now I have a multi-select query list so I'd love to achieve that the size value for each of those selected logical volumes is summed and shown in the singlestat.
I've been trying to find some function and I know there are sum functions but in my case, I don't know which are going to be the results of the selections in the templating query and there doesn't seem to exist a way to automatically add an "invisible" query to the metrics section while only showing a sum-of-all-queries-metric.
Are there any options to achieve this?
a sample query:
collectd.$host.$volumegroups.$logicalvolumes
where all 3 values are from a templating query with results like:
$host => the server in question
$volumegroups => vg00 (LVM Volume Group)
$logicalvolumes => lv_data, lv_root, ... (LVM Logical Volume)
Now when selecting multiple "$logicalvolumes" from the dropdown ofcourse, the singlestat goes "N/A".
In the list of plugins on grafana website, I don't find any other plugin to match this need.
graphite grafana
asked Mar 29 '17 at 11:42
lievendplievendp
56118
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01
add a comment |
Is it possible to make a sum of values - depending on multi-selections in query (templating) - and showing those in a singlestat plugin in grafana?
setup:
- grafana 3.1.1
- datatsource: graphite
Use case:
A query-based dropdownlist allows me to select a logical volume.
The singlestat then shows me the size of this logical volume.
Now I have a multi-select query list so I'd love to achieve that the size value for each of those selected logical volumes is summed and shown in the singlestat.
I've been trying to find some function and I know there are sum functions but in my case, I don't know which are going to be the results of the selections in the templating query and there doesn't seem to exist a way to automatically add an "invisible" query to the metrics section while only showing a sum-of-all-queries-metric.
Are there any options to achieve this?
a sample query:
collectd.$host.$volumegroups.$logicalvolumes
where all 3 values are from a templating query with results like:
$host => the server in question
$volumegroups => vg00 (LVM Volume Group)
$logicalvolumes => lv_data, lv_root, ... (LVM Logical Volume)
Now when selecting multiple "$logicalvolumes" from the dropdown ofcourse, the singlestat goes "N/A".
In the list of plugins on grafana website, I don't find any other plugin to match this need.
graphite grafana
asked Mar 29 '17 at 11:42
lievendplievendp
56118
Is it possible to make a sum of values - depending on multi-selections in query (templating) - and showing those in a singlestat plugin in grafana?
setup:
- grafana 3.1.1
- datatsource: graphite
Use case:
A query-based dropdownlist allows me to select a logical volume.
The singlestat then shows me the size of this logical volume.
Now I have a multi-select query list so I'd love to achieve that the size value for each of those selected logical volumes is summed and shown in the singlestat.
I've been trying to find some function and I know there are sum functions but in my case, I don't know which are going to be the results of the selections in the templating query and there doesn't seem to exist a way to automatically add an "invisible" query to the metrics section while only showing a sum-of-all-queries-metric.
Are there any options to achieve this?
a sample query:
collectd.$host.$volumegroups.$logicalvolumes
where all 3 values are from a templating query with results like:
$host => the server in question
$volumegroups => vg00 (LVM Volume Group)
$logicalvolumes => lv_data, lv_root, ... (LVM Logical Volume)
Now when selecting multiple "$logicalvolumes" from the dropdown ofcourse, the singlestat goes "N/A".
In the list of plugins on grafana website, I don't find any other plugin to match this need.
graphite grafana
graphite grafana
asked Mar 29 '17 at 11:42
lievendplievendp
56118
asked Mar 29 '17 at 11:42
lievendplievendp
56118
edited Mar 29 '17 at 11:47
lievendp
asked Mar 29 '17 at 11:42
lievendplievendp
56118
asked Mar 29 '17 at 11:42
lievendplievendp
56118
asked Mar 29 '17 at 11:42
lievendplievendp
56118
56118
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01
add a comment |
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01
add a comment |
1 Answer
1
active
oldest
votes
Grafana community provided the answer here: 1
effectively by using the "sumseries" function it works as expected.
answered Apr 5 '17 at 15:28
lievendplievendp
56118
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f841280%2fgrafana-how-to-sum-values-from-query-into-a-singlestat-or-other-plugin%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Grafana community provided the answer here: 1
effectively by using the "sumseries" function it works as expected.
answered Apr 5 '17 at 15:28
lievendplievendp
56118
add a comment |
Grafana community provided the answer here: 1
effectively by using the "sumseries" function it works as expected.
answered Apr 5 '17 at 15:28
lievendplievendp
56118
add a comment |
Grafana community provided the answer here: 1
effectively by using the "sumseries" function it works as expected.
answered Apr 5 '17 at 15:28
lievendplievendp
56118
Grafana community provided the answer here: 1
effectively by using the "sumseries" function it works as expected.
answered Apr 5 '17 at 15:28
lievendplievendp
56118
answered Apr 5 '17 at 15:28
lievendplievendp
56118
answered Apr 5 '17 at 15:28
lievendplievendp
56118
answered Apr 5 '17 at 15:28
lievendplievendp
56118
56118
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f841280%2fgrafana-how-to-sum-values-from-query-into-a-singlestat-or-other-plugin%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
groupByNode("sum",1)
– MUY Belgium
Nov 20 '17 at 13:01