how to sum values from query into a singlestat or other plugin?
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 …
wrapping the query in a sumseries() should do what you want, i.e. sumseries(collectd.$host.$volumegroups.$logicalvolumes).
as i had the time, thought i would tidy things up, just one custom query needed, no view required. just change the office names and copy/paste into a custom query 
have a great christmas party! 
select sum(office1) as office1,sum(office2) as office2,sum(office3) as office3,hours from 
((select 
cou… there is a slider labeled hubigraph tile installation, turn that on. then a device is created that can be placed on the dashboard. monthly energy graph in this case

[[grpah2]](https://community.hubitat.com/uploads/default/original/3x/1/f/1f9bb3212a9c5f09119badcf87284edd06a27c55.png "grpah2")

then add that device to you dashboard using attribute as the template. then pick an attribute over to the right.

[[grp…](https://community.hubitat.com/uploads/default/original/3x/4/e/4e9f3c1689dbd166447a7d8b3d76c3d90c3f3263.png "grpah") use the query string to pass the venue id to the generic venue display page, make your <a> tags ref that page with "?id=xxx" at the end, from the venue page fetch that xxx value and query your db for that specific venue, and display that venue's fields as you like.


$myvar = $\_GET['id']; and thus  

Select * FROM table WHERE field='$myvar' <https://docs.glideapps.com/all/reference/components/lists/inline-list#only-show-a-few-items> thanks i was able to use something similar. i have just seen online that we’re not able to extract column values for calculated columns? is there any other way of extracting this data?

query = """ query { boards (ids: %s limit: 20, page: 1) { id name columns … let table = base.gettable("table 1")

let record = await input.recordasync("record", table)

await table.updaterecordasync(record.id, {

"single select": null

}) hi [@jitse\_b](/u/jitse_b)

welcome to the community !

yes you can, there are various ways to do so.

the simplest:

you may want to create a table with 3 columns,

key\_column, type text, value “k000” (or whatever you want, it doesn’t matter if you stick to only one comparison)

“material1”, type ref, source tabl… [@najoua.abbaci](/u/najoua.abbaci)

mabye the flow can be adopted to following:

assign:

leftside: drresult (datatype: datarow)

right side:

dt\_datepv.asenumerable.orderby(function ( r ) datetime.parseexact(r(0).tostring.trim, “dd.mm.yyyy”, system.globalization.cultureinfo.currentuiculture.datetimeformat)).last()

so… If you're unsure of writing joins in SQL use an SQL builder.


Top of my list is still SQLeo which is java based. If you make a small donation you get the full thing, you only need to donate a dollar.


Others are navicat but they have a trial not sure if it is only available to windows either. hi phil 
congratulations on creating this. we’re about to upgrade our asana account so will be candidates for this. 
one function that would be super useful to us would be to have the subtasks of a task populate based on a selection made in a custom field. e.g. if we change content type to blog post…