i found a typo, you forgot the last brackets.
as i wrote before, i am using OH 1.8.3
edit:
now, i have no errors, but nothing is displayed …
this are the item definitions
Number str_homebb01_tempds00_minimum04 "Minimum letzte 4h [%s]"
Number str_homebb01_tempds00_minimum12 "Minimum letzte 12h [%s]"
Number str_homebb01_tempds00_minimum24 "Minimum letzte 24h [%s]"
Number str_homebb01_tempds00_maximum04 "Maximum letzte 4h [%s]"
Number str_homebb01_tempds00_maximum12 "Maximum letzte 12h [%s]"
Number str_homebb01_tempds00_maximum24 "Maximum letzte 24h [%s]"
Number str_homebb01_tempds00_average04 "Durchschnittswert 4h [%s]"
Number str_homebb01_tempds00_average12 "Durchschnittswert 12h [%s]"
Number str_homebb01_tempds00_average24 "Durchschnittswert 24h [%s]"
and this is a part of the sitemap. the graph is displayed, well.
Text item=num_homebb01_tempds00 valuecolor=[>=40="#ff0000", >=37="#ff6e00", >=34="#ffec00", >=33="#b4ff00", >=30="#2cff00", >=25="#00e501", >=20="#009602", >=10="#009602", >=0="#00209f", <=0="#0000ff"]
{
Frame label="Errechnete Werte"
{
Text item=str_homebb01_tempds00_minimum04
Text item=str_homebb01_tempds00_minimum12
Text item=str_homebb01_tempds00_minimum24
Text item=str_homebb01_tempds00_maximum04
Text item=str_homebb01_tempds00_maximum12
Text item=str_homebb01_tempds00_maximum24
Text item=str_homebb01_tempds00_average04
Text item=str_homebb01_tempds00_average12
Text item=str_homebb01_tempds00_average24
}
Frame label="Letzte Aktualisierung der Werte"
{
Text item=str_homebb01_tempds00_lastupdate
}
Frame label="Diagramm: Innentemperatur oben"
{
Chart item=num_homebb01_tempds00 service="mysql" period=24h refresh=300000 visibility=[selectChartIntervall==0, selectChartIntervall=="Uninitialized"]
}
}
to go right, i do not want the actual date, i do want the last saved timestamp out of the mysql table of this item.
the temperature item “num_homebb01_tempds00” is updated with the correct temperature.
if i do a sql statement with sum / count i do get the values i want to display in the items min/max/avg, so i think, the table (=data) is right.
i do not get any infos out of the openhab.log
regards