I added a chart with a period selector to my sitemap
Frame{
Switch item=number_grouphousetotalenergychartperiod label="Chart Period" icon="line" mappings=[0="Hour", 1="Day", 2="Week", 3="month", 4="2month"]
Chart item=number_dailytotalenergy period=h refresh=600000 visibility=[number_grouphousetotalenergychartperiod==0, number_grouphousetotalenergychartperiod=="NULL"]
Chart item=number_dailytotalenergy period=D refresh=3600000 visibility=[number_grouphousetotalenergychartperiod==1]
Chart item=number_dailytotalenergy period=W refresh=3600000 visibility=[number_grouphousetotalenergychartperiod==2]
Chart item=number_dailytotalenergy period=M refresh=3600000 visibility=[number_grouphousetotalenergychartperiod==3]
Chart item=number_dailytotalenergy period=2M refresh=3600000 visibility=[number_grouphousetotalenergychartperiod==4]
}
item
Number number_grouphousetotalenergychartperiod "Chart Period"
But when I select the period this is in my log
[ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'number_grouphousetotalenergychartperiod'.
Any help is appriciated.
Thanks