Hi all,
I have a question I cannot figure out the answer for. It must be something stupid I missed.
for the following query who is reporting live watt usage per plug in my home :
from(bucket: "homeassistant")
|> range(start: -5m)
|> filter(fn: (r) => r["_measurement"] == "W")
|> filter(fn: (r) => r["_field"] == "value")
|> filter(fn: (r) => r["domain"] == "sensor")
|> filter(fn: (r) => r["entity_id"] == "cuisine_toasti_blender_accessoires_divers_prise_meross_power" or r["entity_id"] == "cave_boucle_sanitaire_prise_tuya_power" or r["entity_id"] == "salon_insert_a_pellets_prise_tuya_power" or r["entity_id"] == "cave_congelateur_prises_aspi_balai_etc_prise_meross_power" or r["entity_id"] == "cave_chaudiere_prise_tuya_power" or r["entity_id"] == "cave_machine_a_laver_prise_meross_power" or r["entity_id"] == "cave_modems_routeurs_rock64_unraid_elements_power" or r["entity_id"] == "cave_seche_linge_prise_meross_power" or r["entity_id"] == "chambre_damis_consoles_prise_meross_power" or r["entity_id"] == "chambre_damis_projecteur_prise_meross_power" or r["entity_id"] == "chambre_parentale_tv_routeur_etc_prise_meross_power" or r["entity_id"] == "chambre_raph_et_cel_tables_de_nuit_prise_tuya_power" or r["entity_id"] == "cuisine_fours_prise_meross_power" or r["entity_id"] == "cuisine_frigo_prise_meross_power" or r["entity_id"] == "cuisine_lave_vaisselle_prise_meross_power" or r["entity_id"] == "cuisine_machine_a_cafe_robot_grille_pain_etc_prise_meross_power" or r["entity_id"] == "cuisine_tablette_modem_rpi_plexamp_etc_prise_tuya_power" or r["entity_id"] == "salle_a_manger_alexa_prise_tuya_power" or r["entity_id"] == "salle_a_manger_borne_darcade_prise_meross_power" or r["entity_id"] == "salle_a_manger_lampe_varmblixt_ikea_halo_prise_tuya_power" or r["entity_id"] == "salle_a_manger_prise_humidificateur_derriere_siege_emmanuel_prise_tuya_power" or r["entity_id"] == "salle_a_manger_rpi_plexamp_salle_a_manger_prise_tuya_power" or r["entity_id"] == "salle_de_bain_enceinte_bs_petite_lampe_etc_prise_tuya_power" or r["entity_id"] == "salle_de_bain_radiateur_electrique_prise_meross_power" or r["entity_id"] == "salon_aspirateur_a_cendres_prise_meross_power" or r["entity_id"] == "salon_barre_son_etc_prise_tuya_power" or r["entity_id"] == "salon_prise_logia_lampe_togo_prise_tuya_power" or r["entity_id"] == "salon_tv_shield_switch_etc_prise_meross_power" or r["entity_id"] == "consommation_directe_lampes" or r["entity_id"] == "cave_four_micro_ondes_prise_meross_power")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "last")
I only do see this or that plug, appearing:
My first assumption was that grafana was automatically displaying or hiding plugs based on their usage, in order to optimize the space allowed to my panel. But this is actually not the case. I currently do have plugs using 1kwh, and approx 150W respectively, that are NOT shown in the above grafana panel, while some other that only uses a few milliwatts are.
I’d like to know how to systematically show all entities in this panel. I am really interested in monitoring all my plugs in real time, whetever the space the panel will take on screen.
Is there an option I have to check somewhere in order to get this ?
Thanks ! 