{"id":74421,"date":"2020-03-17T08:43:08","date_gmt":"2020-03-17T05:43:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant"},"modified":"2020-03-17T08:43:08","modified_gmt":"2020-03-17T05:43:08","slug":"umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant","title":{"rendered":"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/f1133a4c391e901ed64bf0825a774fc6.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nSa her\u00eb q\u00eb marr fatur\u00ebn e energjis\u00eb elektrike dhe ujit, habitem \u2014 a konsumon v\u00ebrtet familja ime kaq shum\u00eb? Po, n\u00eb banj\u00eb kemi dysheme me ngrohje dhe bojler, por ato nuk punojn\u00eb pa nd\u00ebrprerje. Edhe ujin duket se e kursejm\u00eb (edhe pse na p\u00eblqen edhe t\u00eb relaksohemi n\u00eb vask\u00eb). Disa vite m\u00eb par\u00eb un\u00eb tashm\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/411259\/\">lidha mat\u00ebsit e ujit<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=XKvunh29sZo&amp;list=PLkt_cQxT0oUmfdxhbmTjytjaJjZjSVUOu\">t\u00eb energjis\u00eb elektrike<\/a><\/noindex> me sht\u00ebpin\u00eb e men\u00e7ur, por aty mbeti gjith\u00e7ka. Te analiza e konsumit u ktheva vet\u00ebm tani, dhe pik\u00ebrisht p\u00ebr k\u00ebt\u00eb flet ky artikull.<\/p>\n<p>S\u00eb fundmi kalova te Home Assistant si platform\u00eb p\u00ebr sht\u00ebpin\u00eb e men\u00e7ur. Nj\u00eb nga arsyet ishte pik\u00ebrisht mund\u00ebsia p\u00ebr t\u00eb organizuar mbledhjen e nj\u00eb sasie t\u00eb madhe t\u00eb dh\u00ebnash dhe p\u00ebr t\u00eb nd\u00ebrtuar leht\u00ebsisht grafik\u00eb t\u00eb llojeve t\u00eb ndryshme.<\/p>\n<p>Informacioni i p\u00ebrshkruar n\u00eb k\u00ebt\u00eb artikull nuk \u00ebsht\u00eb i ri; t\u00eb gjitha k\u00ebto zgjidhje jan\u00eb trajtuar tashm\u00eb n\u00eb internet, n\u00eb forma t\u00eb ndryshme. Por \u00e7do artikull, si rregull, p\u00ebrshkruan vet\u00ebm nj\u00eb qasje ose nj\u00eb aspekt. Krahasimin e k\u00ebtyre qasjeve dhe zgjedhjen e asaj m\u00eb t\u00eb p\u00ebrshtatshme m'u desh ta b\u00ebja vet\u00eb. Ky artikull gjithsesi nuk jep nj\u00eb pasqyr\u00eb shteruese p\u00ebr mbledhjen e t\u00eb dh\u00ebnave, por sh\u00ebrben si nj\u00eb lloj p\u00ebrmbledhjeje se si e kam realizuar un\u00eb. Prandaj, kritikat konstruktive dhe sugjerimet p\u00ebr p\u00ebrmir\u00ebsim jan\u00eb t\u00eb mir\u00ebpritura.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Formulimi i detyr\u00ebs<\/h2>\n<p>\nPra, q\u00ebllimi i ushtrimit t\u00eb sot\u00ebm \u00ebsht\u00eb t\u00eb marrim grafik\u00eb t\u00eb bukur t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike:<\/p>\n<ul>\n<li>P\u00ebr \u00e7do or\u00eb, p\u00ebr 2 dit\u00eb<\/li>\n<li>P\u00ebr \u00e7do dit\u00eb, p\u00ebr 2 jav\u00eb<\/li>\n<li>(opsionale) p\u00ebr \u00e7do jav\u00eb dhe p\u00ebr \u00e7do muaj<\/li>\n<\/ul>\n<p>\nK\u00ebtu na presin disa v\u00ebshtir\u00ebsi:<\/p>\n<ul>\n<li>Komponent\u00ebt standard\u00eb t\u00eb grafik\u00ebve, si rregull, jan\u00eb mjaft t\u00eb dob\u00ebt. N\u00eb rastin m\u00eb t\u00eb mir\u00eb, mund t\u00eb nd\u00ebrtohet nj\u00eb grafik linear sipas pikave.\n<p>N\u00ebse k\u00ebrkoni mir\u00eb, mund t\u00eb gjeni komponent\u00eb t\u00eb pal\u00ebve t\u00eb treta q\u00eb zgjerojn\u00eb mund\u00ebsit\u00eb e grafikut standard. P\u00ebr Home Assistant, n\u00eb parim, nj\u00eb komponent i mir\u00eb dhe estetik \u00ebsht\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/kalkih\/mini-graph-card\">mini-graph-card<\/a><\/noindex>, por edhe ai ka disa kufizime:<\/p>\n<ul>\n<li>\u00cbsht\u00eb e v\u00ebshtir\u00eb t\u00eb p\u00ebrcaktohen parametrat e grafikut me shtylla p\u00ebr intervale t\u00eb gjata kohore (gjer\u00ebsia e shtyll\u00ebs p\u00ebrcaktohet n\u00eb fraksione t\u00eb or\u00ebs, ndaj intervalet m\u00eb t\u00eb gjata se nj\u00eb or\u00eb duhet t\u00eb jepen me numra dhjetor\u00eb)<\/li>\n<li>Nuk mund t\u00eb shtohen n\u00eb t\u00eb nj\u00ebjtin grafik entitete t\u00eb ndryshme (p\u00ebr shembull temperatura dhe lag\u00ebshtia, ose t\u00eb kombinohet nj\u00eb grafik me shtylla me nj\u00eb vij\u00eb)<\/li>\n<\/ul>\n<\/li>\n<li>Jo vet\u00ebm q\u00eb Home Assistant si parazgjedhje p\u00ebrdor baz\u00ebn m\u00eb t\u00eb thjesht\u00eb t\u00eb t\u00eb dh\u00ebnave, SQLite (dhe un\u00eb, p\u00ebr paaft\u00ebsin\u00eb time, nuk arrita t\u00eb instaloj MySQL ose Postgres), por edhe t\u00eb dh\u00ebnat ruhen jo n\u00eb m\u00ebnyr\u00ebn m\u00eb optimale. P\u00ebr shembull, sa her\u00eb q\u00eb ndryshon secili paramet\u00ebr numerik, qoft\u00eb edhe m\u00eb i vogli, n\u00eb baz\u00eb shkruhet nj\u00eb JSON i madh me madh\u00ebsi rreth 1 kilobajt.\n<pre><code class=\"json\">{&quot;entity_id&quot;: &quot;sensor.water_cold_hourly&quot;, &quot;old_state&quot;: {&quot;entity_id&quot;: &quot;sensor.water_cold_hourly&quot;, &quot;state&quot;: &quot;3&quot;, &quot;attributes&quot;: {&quot;source&quot;: &quot;sensor.water_meter_cold&quot;, &quot;status&quot;: &quot;collecting&quot;, &quot;last_period&quot;: &quot;29&quot;, &quot;last_reset&quot;: &quot;2020-02-23T21:00:00.022246+02:00&quot;, &quot;meter_period&quot;: &quot;hourly&quot;, &quot;unit_of_measurement&quot;: &quot;l&quot;, &quot;friendly_name&quot;: &quot;water_cold_hourly&quot;, &quot;icon&quot;: &quot;mdi:counter&quot;}, &quot;last_changed&quot;: &quot;2020-02-23T19:05:06.897604+00:00&quot;, &quot;last_updated&quot;: &quot;2020-02-23T19:05:06.897604+00:00&quot;, &quot;context&quot;: {&quot;id&quot;: &quot;aafc8ca305ba4e49ad4c97f0eddd8893&quot;, &quot;parent_id&quot;: null, &quot;user_id&quot;: null}}, &quot;new_state&quot;: {&quot;entity_id&quot;: &quot;sensor.water_cold_hourly&quot;, &quot;state&quot;: &quot;4&quot;, &quot;attributes&quot;: {&quot;source&quot;: &quot;sensor.water_meter_cold&quot;, &quot;status&quot;: &quot;collecting&quot;, &quot;last_period&quot;: &quot;29&quot;, &quot;last_reset&quot;: &quot;2020-02-23T21:00:00.022246+02:00&quot;, &quot;meter_period&quot;: &quot;hourly&quot;, &quot;unit_of_measurement&quot;: &quot;l&quot;, &quot;friendly_name&quot;: &quot;water_cold_hourly&quot;, &quot;icon&quot;: &quot;mdi:counter&quot;}, &quot;last_changed&quot;: &quot;2020-02-23T19:11:11.251545+00:00&quot;, &quot;last_updated&quot;: &quot;2020-02-23T19:11:11.251545+00:00&quot;, &quot;context&quot;: {&quot;id&quot;: &quot;0de64b8af6f14bb9a419dcf3b200ef56&quot;, &quot;parent_id&quot;: null, &quot;user_id&quot;: null}}}<\/code><\/pre>\n<p>\nUn\u00eb kam mjaft sensor\u00eb (sensor\u00eb temperature n\u00eb \u00e7do dhom\u00eb, mat\u00ebs uji dhe energjie elektrike), dhe disa prej tyre gjenerojn\u00eb edhe shum\u00eb t\u00eb dh\u00ebna. P\u00ebr shembull, vet\u00ebm mat\u00ebsi i energjis\u00eb elektrike SDM220 prodhon rreth nj\u00eb duzin\u00eb vlerash \u00e7do 10-15 sekonda, dhe un\u00eb do t\u00eb doja t\u00eb instaloja rreth 8 mat\u00ebs t\u00eb till\u00eb. P\u00ebrve\u00e7 k\u00ebsaj, ka edhe nj\u00eb s\u00ebr\u00eb parametrash q\u00eb llogariten mbi baz\u00ebn e sensor\u00ebve t\u00eb tjer\u00eb. K\u00ebshtu, t\u00eb gjitha k\u00ebto vlera mund ta fryjn\u00eb leht\u00ebsisht baz\u00ebn e t\u00eb dh\u00ebnave me 100-200 MB n\u00eb dit\u00eb. Pas nj\u00eb jave sistemi mezi do t\u00eb punoj\u00eb, nd\u00ebrsa pas nj\u00eb muaji do t\u00eb d\u00ebshtoj\u00eb memoria flash (n\u00eb rastin e instalimit tipik t\u00eb Home Assistant n\u00eb Raspberry Pi), e p\u00ebr ruajtjen e t\u00eb dh\u00ebnave p\u00ebr nj\u00eb vit t\u00eb t\u00ebr\u00eb as q\u00eb mund t\u00eb b\u00ebhet fjal\u00eb.<\/li>\n<li>N\u00ebse keni fat, mat\u00ebsi juaj di vet\u00eb t\u00eb llogaris\u00eb konsumin. N\u00eb \u00e7do moment mund t\u2019i drejtoheni mat\u00ebsit dhe t\u00eb k\u00ebrkoni vler\u00ebn e akumuluar t\u00eb konsumit deri n\u00eb at\u00eb \u00e7ast. Si rregull, t\u00eb gjith\u00eb mat\u00ebsit e energjis\u00eb elektrike q\u00eb kan\u00eb nd\u00ebrfaqe dixhitale (RS232\/RS485\/Modbus\/Zigbee) e ofrojn\u00eb k\u00ebt\u00eb mund\u00ebsi.\n<p>\u00cbsht\u00eb edhe m\u00eb keq n\u00ebse pajisja mund t\u00eb mas\u00eb vet\u00ebm nj\u00eb paramet\u00ebr t\u00eb \u00e7astit (p\u00ebr shembull fuqin\u00eb ose rrym\u00ebn e \u00e7astit), ose thjesht t\u00eb gjeneroj\u00eb impulse \u00e7do X vat-or\u00eb apo litra. At\u00ebher\u00eb duhet menduar si dhe me \u00e7far\u00eb t\u00eb integrohet kjo dhe ku t\u00eb grumbullohet vlera. Ekziston rreziku t\u00eb humbet raporti i radh\u00ebs p\u00ebr ndonj\u00eb arsye, dhe edhe sakt\u00ebsia e sistemit n\u00eb t\u00ebr\u00ebsi ngre pik\u00ebpyetje. Sigurisht, t\u00eb gjitha k\u00ebto mund t\u2019i besohen nj\u00eb sistemi smart home si Home Assistant, por askush nuk e ka anuluar \u00e7\u00ebshtjen e numrit t\u00eb regjistrimeve n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave, dhe sondazhi i sensor\u00ebve m\u00eb shpesh se nj\u00eb her\u00eb n\u00eb sekond\u00eb nuk do t\u00eb jet\u00eb i mundur (kufizim i arkitektur\u00ebs s\u00eb Home Assistant).<\/li>\n<\/ul>\n<p><\/p>\n<h2>Qasja 1<\/h2>\n<p>\nS\u00eb pari, le t\u00eb shohim \u00e7far\u00eb ofron Home Assistant si funksionalitet standard. Matja e konsumit p\u00ebr nj\u00eb periudh\u00eb \u00ebsht\u00eb nj\u00eb ve\u00e7ori shum\u00eb e k\u00ebrkuar. Natyrisht, kjo \u00ebsht\u00eb zbatuar prej koh\u00ebsh n\u00eb form\u00ebn e nj\u00eb komponenti t\u00eb specializuar \u2014 utility_meter. <\/p>\n<p>Thelbi i komponentit \u00ebsht\u00eb se ai krijon brenda nj\u00eb variab\u00ebl current_accumulated_value dhe e rivendos at\u00eb pas p\u00ebrfundimit t\u00eb periudh\u00ebs s\u00eb caktuar (or\u00eb\/jav\u00eb\/muaj). Komponenti vet\u00eb monitoron variabl\u00ebn hyr\u00ebse (vler\u00ebn e nj\u00eb sensori), vet\u00eb abonohet ndaj ndryshimeve t\u00eb vler\u00ebs \u2014 ju thjesht merrni rezultatin gati. Kjo gj\u00eb p\u00ebrshkruhet vet\u00ebm me disa rreshta n\u00eb skedarin e konfigurimit<\/p>\n<pre><code class=\"python\">utility_meter:\n  water_cold_hour_um:\n    source: sensor.water_meter_cold\n    cycle: hourly\n  water_cold_day_um:\n    source: sensor.water_meter_cold\n    cycle: daily\n<\/code><\/pre>\n<p>\nK\u00ebtu sensor.water_meter_cold \u00ebsht\u00eb vlera aktuale e mat\u00ebsit n\u00eb litra, t\u00eb cil\u00ebn e marr <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/411259\/\">drejtp\u00ebrdrejt nga pajisja<\/a><\/noindex> p\u00ebrmes mqtt. Kjo struktur\u00eb krijon 2 sensor\u00eb t\u00eb rinj water_cold_hour_um dhe water_cold_day_um, t\u00eb cil\u00ebt grumbullojn\u00eb leximet orare dhe ditore, duke i zeruar ato pas p\u00ebrfundimit t\u00eb periudh\u00ebs. Ja grafiku i akumulatorit orar p\u00ebr gjysm\u00eb dite.<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/d3c3ea29c10b17142e51ebe756ab7123.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKodi i grafik\u00ebve orar\u00eb dhe ditor\u00eb p\u00ebr lovelace-UI duket k\u00ebshtu:<\/p>\n<pre><code class=\"python\">      - type: history-graph\n        title: 'Konsumi orar i ujit duke p\u00ebrdorur vars'\n        hours_to_show: 48\n        entities:\n          - sensor.water_hour\n\n      - type: history-graph\n        title: 'Konsumi ditor i ujit duke p\u00ebrdorur vars'\n        hours_to_show: 360\n        entities:\n          - sensor.water_day\n<\/code><\/pre>\n<p>\nN\u00eb fakt, pik\u00ebrisht te ky algorit\u00ebm q\u00ebndron problemi i k\u00ebsaj qasjeje. Si\u00e7 e p\u00ebrmenda m\u00eb her\u00ebt, p\u00ebr \u00e7do vler\u00eb hyr\u00ebse (leximi aktual i mat\u00ebsit p\u00ebr \u00e7do lit\u00ebr pasues) krijohet nga 1 KB regjistrim n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave. \u00c7do utility meter gjeneron gjithashtu nj\u00eb vler\u00eb t\u00eb re, e cila po ashtu ruhet n\u00eb baz\u00eb. N\u00ebse dua t\u00eb mbledh lexime orare\/ditore\/javore\/mujore, p\u00ebr disa kolona uji, dhe t\u2019u shtoj edhe nj\u00eb grup mat\u00ebsish t\u00eb energjis\u00eb elektrike, kjo do t\u00eb krijoj\u00eb shum\u00eb t\u00eb dh\u00ebna. Ose m\u00eb sakt\u00eb, vet\u00eb t\u00eb dh\u00ebnat nuk jan\u00eb edhe aq shum\u00eb, por meq\u00eb Home Assistant shkruan n\u00eb baz\u00eb shum\u00eb informacion t\u00eb panevojsh\u00ebm, madh\u00ebsia e baz\u00ebs do t\u00eb rritet me shpejt\u00ebsi marramend\u00ebse. Madje hezitoj t\u00eb p\u00ebrllogaris sa e madhe do t\u00eb b\u00ebhej baza p\u00ebr grafik\u00eb javore dhe mujore.<\/p>\n<p>P\u00ebrve\u00e7 k\u00ebsaj, utility meter n\u00eb vetvete nuk e zgjidh detyr\u00ebn e vendosur. Grafiku i vlerave q\u00eb jep utility meter \u00ebsht\u00eb nj\u00eb funksion monoton n\u00eb rritje, q\u00eb rikthehet n\u00eb 0 \u00e7do or\u00eb. Nd\u00ebrsa ne kemi nevoj\u00eb p\u00ebr nj\u00eb grafik konsumi t\u00eb qart\u00eb p\u00ebr p\u00ebrdoruesin: sa litra jan\u00eb konsumuar gjat\u00eb nj\u00eb periudhe t\u00eb caktuar. Komponenti standard history-graph nuk e ofron k\u00ebt\u00eb, por mund t\u00eb na ndihmoj\u00eb komponenti i jasht\u00ebm mini-graph-card.<\/p>\n<p>Ky \u00ebsht\u00eb kodi i kart\u00ebs p\u00ebr lovelace-UI:<\/p>\n<pre><code class=\"python\">      - aggregate_func: max\n        entities:\n          - color: var(--primary-color)\n            entity: sensor.water_cold_hour_um\n        group_by: hour\n        hours_to_show: 48\n        name: &quot;Konsumimi i ujit n\u00eb or\u00eb i agreguar nga mat\u00ebsi&quot;\n        points_per_hour: 1\n        show:\n          graph: bar\n        type: 'custom:mini-graph-card'<\/code><\/pre>\n<p>\nP\u00ebrve\u00e7 parametrave standard\u00eb si emri i sensorit, lloji i grafikut dhe ngjyra (portokallia standarde nuk m\u00eb p\u00eblqeu), k\u00ebtu vlen t\u00eb theksohen 3 cil\u00ebsime:<\/p>\n<ul>\n<li>group_by:hour \u2014 grafiku do t\u00eb gjenerohet me rreshtimin e shtyllave sipas fillimit t\u00eb or\u00ebs<\/li>\n<li>points_per_hour: 1 \u2014 nj\u00eb shtyll\u00eb p\u00ebr \u00e7do or\u00eb<\/li>\n<li>Dhe m\u00eb e r\u00ebnd\u00ebsishmja, aggregate_func: max \u2014 merret vlera maksimale brenda \u00e7do ore. Pik\u00ebrisht ky paramet\u00ebr e shnd\u00ebrron grafikun n\u00eb form\u00eb dh\u00ebmb\u00ebsh sharre n\u00eb shtylla<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/5bd866c39b23299e5f15dcf4a9bce38f.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nMos u kushtoni v\u00ebmendje rreshtit t\u00eb shtyllave n\u00eb t\u00eb majt\u00eb \u2014 kjo \u00ebsht\u00eb sjellje standarde e komponentit kur nuk ka t\u00eb dh\u00ebna. Dhe t\u00eb dh\u00ebna v\u00ebrtet nuk kishte \u2014 mbledhjen e t\u00eb dh\u00ebnave p\u00ebr utility meter e aktivizova vet\u00ebm para pak or\u00ebsh, posa\u00e7\u00ebrisht p\u00ebr k\u00ebt\u00eb artikull (qasjen time aktuale do ta shpjegoj pak m\u00eb posht\u00eb). <\/p>\n<p>N\u00eb k\u00ebt\u00eb figur\u00eb doja t\u00eb tregoja se ndonj\u00ebher\u00eb paraqitja e t\u00eb dh\u00ebnave madje funksionon, dhe shtyllat v\u00ebrtet pasqyrojn\u00eb vlerat e sakta. Vet\u00ebm se jo t\u00eb gjitha. Shtylla e theksuar p\u00ebr intervalin nga 11 deri n\u00eb 12 paradite, p\u00ebr ndonj\u00eb arsye, tregon 19 litra, nd\u00ebrsa n\u00eb grafikun me dh\u00ebmb\u00eb pak m\u00eb sip\u00ebr, p\u00ebr t\u00eb nj\u00ebjt\u00ebn periudh\u00eb dhe nga i nj\u00ebjti sensor, shohim konsum prej 62 litrash. Ose \u00ebsht\u00eb bug, ose \u00ebsht\u00eb b\u00ebr\u00eb keq. Nd\u00ebrsa pse jan\u00eb prishur t\u00eb dh\u00ebnat n\u00eb t\u00eb djatht\u00eb, k\u00ebt\u00eb ende nuk e kam kuptuar \u2014 konsumi aty ishte normal, gj\u00eb q\u00eb shihet gjithashtu nga grafiku me dh\u00ebmb\u00eb.<\/p>\n<p>Me pak fjal\u00eb, nuk arrita t\u2019i jap besueshm\u00ebri k\u00ebtij qasjeje \u2014 grafiku pothuajse gjithmon\u00eb shfaq ndonj\u00eb marr\u00ebzi.<\/p>\n<p>Kod analog p\u00ebr sensorin ditor. <\/p>\n<pre><code class=\"python\">      - aggregate_func: max\n        entities:\n          - color: var(--primary-color)\n            entity: sensor.water_cold_day_um\n        group_by: interval\n        hours_to_show: 360\n        name: &quot;Konsumimi ditor i ujit i agreguar nga mat\u00ebsi&quot;\n        points_per_hour: 0.0416666666\n        show:\n          graph: bar\n        type: 'custom:mini-graph-card'\n<\/code><\/pre>\n<p>\nVini re se parametri group_by \u00ebsht\u00eb vendosur n\u00eb vler\u00ebn interval, dhe parametrin kryesor k\u00ebtu e p\u00ebrcakton points_per_hour. K\u00ebtu q\u00ebndron edhe nj\u00eb problem tjet\u00ebr i k\u00ebtij komponenti \u2014 points_per_hour funksionon mir\u00eb p\u00ebr grafik\u00eb me koh\u00ebzgjatje nj\u00eb or\u00eb ose m\u00eb pak, por shum\u00eb keq p\u00ebr intervale m\u00eb t\u00eb gjata. K\u00ebshtu, q\u00eb t\u00eb merrja nj\u00eb shtyll\u00eb p\u00ebr nj\u00eb dit\u00eb, m\u00eb \u00ebsht\u00eb dashur t\u00eb vendos vler\u00ebn 1\/24=0.04166666. P\u00ebr t\u00eb mos folur fare p\u00ebr grafik\u00ebt javor\u00eb dhe mujor\u00eb.<\/p>\n<h2>Qasja 2<\/h2>\n<p>\nTeksa sapo po njihesha me Home Assistant, hasa n\u00eb k\u00ebt\u00eb video:<\/p>\n<p><center><div class=\"youtube-placeholder\" data-id=\"-0HrYFCRH0M\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/-0HrYFCRH0M\/hqdefault.jpg\" alt=\"Luaj videon\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><br \/>\nAutori mbledh t\u00eb dh\u00ebna t\u00eb konsumit nga disa lloje prizash Xiaomi. Detyra e tij \u00ebsht\u00eb pak m\u00eb e thjesht\u00eb \u2014 thjesht t\u00eb shfaq\u00eb vler\u00ebn e konsumit p\u00ebr sot, dje dhe p\u00ebr muajin. Nuk nevojiten fare grafik\u00eb. <\/p>\n<p>Le t\u2019i l\u00ebm\u00eb m\u00ebnjan\u00eb arsyetimet p\u00ebr integrimin manual t\u00eb vlerave t\u00eb menj\u00ebhershme t\u00eb fuqis\u00eb \u2014 p\u00ebr \u201csakt\u00ebsin\u00eb\u201d e k\u00ebsaj qasjeje kam shkruar tashm\u00eb m\u00eb sip\u00ebr. Nuk \u00ebsht\u00eb e qart\u00eb pse ai nuk p\u00ebrdori vlerat e akumuluara t\u00eb konsumit, t\u00eb cilat mblidhen tashm\u00eb nga e nj\u00ebjta priz\u00eb. Sipas mendimit tim, integrimi brenda pajisjes do t\u00eb funksionoj\u00eb m\u00eb mir\u00eb. <\/p>\n<p>Nga videoja do t\u00eb marrim iden\u00eb e llogaritjes manuale t\u00eb konsumit p\u00ebr nj\u00eb periudh\u00eb. Tek ai llogariten vet\u00ebm vlerat p\u00ebr sot dhe p\u00ebr dje, por ne do t\u00eb shkojm\u00eb m\u00eb tej dhe do t\u00eb p\u00ebrpiqemi t\u00eb vizatojm\u00eb nj\u00eb grafik. Thelbi i metod\u00ebs s\u00eb propozuar n\u00eb rastin tim \u00ebsht\u00eb si m\u00eb posht\u00eb.<\/p>\n<p>Le t\u00eb krijojm\u00eb nj\u00eb variab\u00ebl \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435_\u0432_\u043d\u0430\u0447\u0430\u043b\u0435_\u0447\u0430\u0441\u0430, ku do t\u00eb regjistrojm\u00eb leximet aktuale t\u00eb mat\u00ebsit<br \/>\nSipas nj\u00eb koh\u00ebmat\u00ebsi n\u00eb fund t\u00eb or\u00ebs (ose n\u00eb fillim t\u00eb or\u00ebs tjet\u00ebr), do t\u00eb llogarisim diferenc\u00ebn midis leximit aktual dhe atij t\u00eb ruajtur n\u00eb fillim t\u00eb or\u00ebs. Kjo diferenc\u00eb do t\u00eb jet\u00eb konsumi p\u00ebr or\u00ebn aktuale \u2014 do ta ruajm\u00eb vler\u00ebn n\u00eb sensor dhe m\u00eb pas do ta p\u00ebrdorim p\u00ebr t\u00eb nd\u00ebrtuar grafikun. <br \/>\nGjithashtu duhet t\u00eb \u201czerohet\u201d variabla \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435_\u0432_\u043d\u0430\u0447\u0430\u043b\u0435_\u0447\u0430\u0441\u0430 duke shkruar aty vler\u00ebn aktuale t\u00eb mat\u00ebsit.<\/p>\n<p>T\u00eb gjitha k\u00ebto mund t\u00eb b\u00ebhen p\u00ebrmes mjeteve t\u00eb vet\u00eb home assistant. <\/p>\n<p>Do t\u00eb duhet t\u00eb shkruhet disi m\u00eb shum\u00eb kod sesa n\u00eb qasjen e m\u00ebparshme. S\u00eb pari, le t\u00eb krijojm\u00eb k\u00ebto \u201cvariabla\u201d. Si standard, nuk kemi nj\u00eb entitet \u201cvariab\u00ebl\u201d, por mund t\u00eb p\u00ebrdorim MQTT broker. Do t\u00eb d\u00ebrgojm\u00eb aty vlerat me flamurin retain=true \u2014 kjo do ta ruaj\u00eb vler\u00ebn brenda broker-it dhe mund t\u00eb merret prej andej n\u00eb \u00e7do moment, edhe pas rinisjes s\u00eb Home Assistant. Un\u00eb krijova menj\u00ebher\u00eb num\u00ebruesit orar\u00eb dhe ditor\u00eb.<\/p>\n<pre><code class=\"python\">- platform: mqtt\n  state_topic: &quot;test\/water\/hour&quot;\n  name: water_hour\n  unit_of_measurement: l\n\n- platform: mqtt\n  state_topic: &quot;test\/water\/hour_begin&quot;\n  name: water_hour_begin\n  unit_of_measurement: l\n\n- platform: mqtt\n  state_topic: &quot;test\/water\/day&quot;\n  name: water_day\n  unit_of_measurement: l\n\n- platform: mqtt\n  state_topic: &quot;test\/water\/day_begin&quot;\n  name: water_day_begin\n  unit_of_measurement: l<\/code><\/pre>\n<p>\nE gjith\u00eb magjia ndodh n\u00eb automatizim, i cili niset p\u00ebrkat\u00ebsisht \u00e7do or\u00eb dhe \u00e7do nat\u00eb.<\/p>\n<pre><code class=\"python\">- id: water_new_hour\n  alias: water_new_hour\n  initial_state: true\n  trigger:\n    - platform: time_pattern\n      minutes: 0\n  action:\n    - service: mqtt.publish\n      data:\n        topic: &quot;test\/water\/hour&quot;\n        payload_template: &gt;\n          {{ (states.sensor.water_meter_cold.state|int) - (states.sensor.water_hour_begin.state|int) }}\n        retain: true\n    - service: mqtt.publish\n      data:\n        topic: &quot;test\/water\/hour_begin&quot;\n        payload_template: &gt;\n          {{ states.sensor.water_meter_cold.state }}\n        retain: true\n\n- id: water_new_day\n  alias: water_new_day\n  initial_state: true\n  trigger:\n    - platform: time\n      at: &quot;00:00:00&quot;\n  action:\n    - service: mqtt.publish\n      data:\n        topic: &quot;test\/water\/day&quot;\n        payload_template: &gt;\n          {{ (states.sensor.water_meter_cold.state|int) - (states.sensor.water_day_begin.state|int) }}\n        retain: true\n    - service: mqtt.publish\n      data:\n        topic: &quot;test\/water\/day_begin&quot;\n        payload_template: &gt;\n          {{ states.sensor.water_meter_cold.state }}\n        retain: true<\/code><\/pre>\n<p>\nT\u00eb dy automatizimet kryejn\u00eb 2 veprime:<\/p>\n<ul>\n<li>Llogarisin vler\u00ebn p\u00ebr intervalin si diferenc\u00eb midis vler\u00ebs fillestare dhe asaj p\u00ebrfundimtare<\/li>\n<li>P\u00ebrdit\u00ebsojn\u00eb vler\u00ebn baz\u00eb p\u00ebr intervalin pasues<\/li>\n<\/ul>\n<p>\nNd\u00ebrtimi i grafik\u00ebve n\u00eb k\u00ebt\u00eb rast zgjidhet me history-graph t\u00eb zakonsh\u00ebm:<\/p>\n<pre><code class=\"python\">      - type: history-graph\n        title: 'Konsumi orar i ujit duke p\u00ebrdorur vars'\n        hours_to_show: 48\n        entities:\n          - sensor.water_hour\n\n      - type: history-graph\n        title: 'Konsumi ditor i ujit duke p\u00ebrdorur vars'\n        hours_to_show: 360\n        entities:\n          - sensor.water_day<\/code><\/pre>\n<p>\nDuket k\u00ebshtu:<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/ebde2fc5f0a72d7d6ba565c3686dc9c6.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nN\u00eb thelb, kjo \u00ebsht\u00eb tashm\u00eb ajo q\u00eb duhet. P\u00ebrpar\u00ebsia e k\u00ebsaj metode \u00ebsht\u00eb se t\u00eb dh\u00ebnat gjenerohen vet\u00ebm nj\u00eb her\u00eb p\u00ebr \u00e7do interval. Pra, gjithsej 24 regjistrime n\u00eb dit\u00eb p\u00ebr grafikun orar. <\/p>\n<p>Fatkeq\u00ebsisht, kjo gjithsesi nuk e zgjidh problemin e p\u00ebrgjithsh\u00ebm t\u00eb rritjes s\u00eb baz\u00ebs. N\u00ebse dua nj\u00eb grafik t\u00eb konsumit mujor, do t\u00eb m\u00eb duhet t\u2019i ruaj t\u00eb dh\u00ebnat t\u00eb pakt\u00ebn p\u00ebr nj\u00eb vit. Dhe meq\u00eb Home Assistant ofron vet\u00ebm nj\u00eb cil\u00ebsim t\u00eb vet\u00ebm p\u00ebr koh\u00ebzgjatjen e ruajtjes p\u00ebr t\u00eb gjith\u00eb baz\u00ebn, kjo do t\u00eb thot\u00eb se T\u00cb GJITHA t\u00eb dh\u00ebnat n\u00eb sistem do t\u00eb duhet t\u00eb ruhen p\u00ebr nj\u00eb vit t\u00eb t\u00ebr\u00eb. P\u00ebr shembull, brenda nj\u00eb viti konsumoj 200 metra kub uj\u00eb, q\u00eb do t\u00eb thot\u00eb 200000 regjistrime n\u00eb baz\u00eb. E n\u00ebse marrim parasysh edhe sensor\u00ebt e tjer\u00eb, at\u00ebher\u00eb shifra b\u00ebhet fare e pajustifikueshme.<\/p>\n<h2>Qasja 3<\/h2>\n<p>\nP\u00ebr fat t\u00eb mir\u00eb, njer\u00ebzit e zgjuar e kan\u00eb zgjidhur tashm\u00eb k\u00ebt\u00eb problem duke krijuar baz\u00ebn e t\u00eb dh\u00ebnave InfluxDB. Kjo baz\u00eb \u00ebsht\u00eb optimizuar posa\u00e7\u00ebrisht p\u00ebr ruajtjen e t\u00eb dh\u00ebnave t\u00eb bazuara n\u00eb koh\u00eb dhe \u00ebsht\u00eb ideale p\u00ebr ruajtjen e vlerave nga sensor\u00eb t\u00eb ndrysh\u00ebm. Sistemi ofron gjithashtu nj\u00eb gjuh\u00eb pyet\u00ebsish t\u00eb ngjashme me SQL, e cila lejon t\u00eb nxirren vlerat nga baza dhe m\u00eb pas t\u00eb agregohen n\u00eb m\u00ebnyra t\u00eb ndryshme. S\u00eb fundi, lloje t\u00eb ndryshme t\u00eb dh\u00ebnash mund t\u00eb ruhen p\u00ebr periudha t\u00eb ndryshme. P\u00ebr shembull, matjet q\u00eb ndryshojn\u00eb shpesh, si temperatura ose lag\u00ebshtia, mund t\u00eb ruhen vet\u00ebm p\u00ebr disa jav\u00eb, nd\u00ebrsa matjet ditore t\u00eb konsumit t\u00eb ujit mund t\u00eb ruhen p\u00ebr nj\u00eb vit t\u00eb t\u00ebr\u00eb.<\/p>\n<p>P\u00ebrve\u00e7 InfluxDB, njer\u00ebzit e zgjuar shpik\u00ebn edhe Grafana \u2014 nj\u00eb sistem p\u00ebr vizualizimin e grafik\u00ebve nga t\u00eb dh\u00ebnat e InfluxDB. Grafana mund t\u00eb krijoj\u00eb lloje t\u00eb ndryshme grafik\u00ebsh, t\u2019i personalizoj\u00eb ato n\u00eb detaje dhe, m\u00eb e r\u00ebnd\u00ebsishmja, k\u00ebta grafik\u00eb mund t\u00eb \u201cintegrohen\u201d n\u00eb lovelace-UI t\u00eb Home Assistant.<\/p>\n<p>Frym\u00ebzim <noindex><a rel=\"nofollow\" href=\"https:\/\/dummylabs.com\/ru\/post\/2019-01-13-influxdb-part1\/\">k\u00ebtu <\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/dummylabs.com\/ru\/post\/2019-05-28-influxdb-part2\/\">k\u00ebtu<\/a><\/noindex>N\u00eb artikuj p\u00ebrshkruhet n\u00eb detaje procesi i instalimit dhe lidhjes s\u00eb InfluxDB dhe Grafana me Home Assistant. Un\u00eb do t\u00eb p\u00ebrqendrohem te zgjidhja e detyr\u00ebs sime konkrete.<\/p>\n<p>Pra, si hap t\u00eb par\u00eb, le t\u00eb fillojm\u00eb t\u00eb ruajm\u00eb vler\u00ebn e mat\u00ebsit n\u00eb InfluxDB. Pjes\u00eb e konfigurimit t\u00eb Home Assistant (n\u00eb k\u00ebt\u00eb shembull do t\u00eb merrem jo vet\u00ebm me ujin e ftoht\u00eb, por edhe me at\u00eb t\u00eb ngroht\u00eb):<\/p>\n<pre><code class=\"python\">influxdb:\n  host: localhost\n  max_retries: 3\n  default_measurement: state\n  database: homeassistant\n  include:\n    entities:\n      - sensor.water_meter_hot\n      - sensor.water_meter_cold<\/code><\/pre>\n<p>\nLe t\u00eb \u00e7aktivizojm\u00eb ruajtjen e k\u00ebtyre t\u00eb nj\u00ebjtave t\u00eb dh\u00ebna n\u00eb baz\u00ebn e brendshme t\u00eb Home Assistant, q\u00eb t\u00eb mos e zmadhojm\u00eb pa nevoj\u00eb:<\/p>\n<pre><code class=\"python\">recorder:\n  purge_keep_days: 10\n  purge_interval: 1\n  exclude:\n    entities:\n      - sensor.water_meter_hot\n      - sensor.water_meter_cold<\/code><\/pre>\n<p>\nTani le t\u00eb kalojm\u00eb n\u00eb konzol\u00ebn e InfluxDB dhe t\u00eb konfigurojm\u00eb baz\u00ebn ton\u00eb. Konkretisht, duhet t\u00eb p\u00ebrcaktojm\u00eb sa koh\u00eb do t\u00eb ruhen lloje t\u00eb caktuara t\u00eb dh\u00ebnash. Kjo rregullohet nga e ashtuquajtura retention policy \u2014 di\u00e7ka e ngjashme me baza t\u00eb dh\u00ebnash brenda baz\u00ebs kryesore, ku secila baz\u00eb e brendshme ka parametrat e vet. Si parazgjedhje, t\u00eb gjitha t\u00eb dh\u00ebnat ruhen n\u00eb retention policy me emrin autogen, dhe k\u00ebto t\u00eb dh\u00ebna mbahen p\u00ebr nj\u00eb jav\u00eb. Un\u00eb do t\u00eb doja q\u00eb t\u00eb dh\u00ebnat orare t\u00eb ruheshin p\u00ebr nj\u00eb muaj, ato javore p\u00ebr nj\u00eb vit, nd\u00ebrsa ato mujore t\u00eb mos fshiheshin kurr\u00eb. Le t\u00eb krijojm\u00eb retention policy p\u00ebrkat\u00ebse<\/p>\n<pre><code class=\"sql\">KRIJONI POLITIK\u00cbN E RUJTJES &quot;muaj&quot; N\u00cb &quot;homeassistant&quot; KOH\u00cbZHVILLIMI 30d REPLIKIMI 1\nKRIJONI POLITIK\u00cbN E RUJTJES &quot;vit&quot; N\u00cb &quot;homeassistant&quot; KOH\u00cbZHVILLIMI 52w REPLIKIMI 1\nKRIJONI POLITIK\u00cbN E RUJTJES &quot;pa fund&quot; N\u00cb &quot;homeassistant&quot; KOH\u00cbZHVILLIMI INF REPLIKIMI 1<\/code><\/pre>\n<p>\nTani vjen truku kryesor \u2014 agregimi i t\u00eb dh\u00ebnave me ndihm\u00ebn e continuous query. Ky \u00ebsht\u00eb nj\u00eb mekaniz\u00ebm q\u00eb ekzekuton automatikisht nj\u00eb k\u00ebrkes\u00eb n\u00eb intervale t\u00eb caktuara kohore, i agregjon t\u00eb dh\u00ebnat sipas k\u00ebsaj k\u00ebrkese dhe rezultatin e ruan si nj\u00eb vler\u00eb t\u00eb re. Ta shohim me nj\u00eb shembull (po e shkruaj me rreshta p\u00ebr lexueshm\u00ebri, por n\u00eb praktik\u00eb m\u00eb \u00ebsht\u00eb dashur ta fus k\u00ebt\u00eb komand\u00eb n\u00eb nj\u00eb rresht t\u00eb vet\u00ebm)<\/p>\n<pre><code class=\"sql\">CREATE CONTINUOUS QUERY cq_water_hourly ON homeassistant \nBEGIN \n  SELECT max(value) AS value \n  INTO homeassistant.month.water_meter_hour \n  FROM homeassistant.autogen.l \n  GROUP BY time(1h), entity_id fill(previous) \nEND<\/code><\/pre>\n<p>\nKjo komand\u00eb:<\/p>\n<ul>\n<li>Krijon nj\u00eb continuous query me emrin cq_water_cold_hourly n\u00eb baz\u00ebn homeassistant<\/li>\n<li>K\u00ebrkesa do t\u00eb ekzekutohet \u00e7do or\u00eb (time(1h))<\/li>\n<li>K\u00ebrkesa do t\u00eb marr\u00eb t\u00eb gjitha t\u00eb dh\u00ebnat nga measurement homeassistant.autogen.l (litra), p\u00ebrfshir\u00eb leximet e ujit t\u00eb ftoht\u00eb dhe t\u00eb ngroht\u00eb<\/li>\n<li>T\u00eb dh\u00ebnat e agreguara do t\u00eb grupohen sipas entity_id, gj\u00eb q\u00eb do t\u00eb krijoj\u00eb vlera t\u00eb ndara p\u00ebr ujin e ftoht\u00eb dhe t\u00eb ngroht\u00eb<\/li>\n<li>Meqen\u00ebse mat\u00ebsi i litrave \u00ebsht\u00eb nj\u00eb sekuenc\u00eb me rritje monotone, brenda \u00e7do ore duhet marr\u00eb vlera maksimale, prandaj agregimi do t\u00eb kryhet me funksionin max(value) <\/li>\n<li>Vlera e re do t\u00eb shkruhet n\u00eb homeassistant.month.water_meter_hour, ku month \u00ebsht\u00eb emri i retention policy me afat ruajtjeje nj\u00eb muaj. T\u00eb dh\u00ebnat p\u00ebr ujin e ftoht\u00eb dhe t\u00eb ngroht\u00eb do t\u00eb ruhen n\u00eb regjistrime t\u00eb ve\u00e7anta me entity_id p\u00ebrkat\u00ebs dhe vler\u00ebn n\u00eb fush\u00ebn value<\/li>\n<\/ul>\n<p>\nNat\u00ebn ose kur nuk ka njeri n\u00eb sht\u00ebpi, nuk ka konsum uji dhe, p\u00ebr rrjedhoj\u00eb, nuk ka as regjistrime t\u00eb reja n\u00eb homeassistant.autogen.l. Q\u00eb t\u00eb mos ket\u00eb boshll\u00ebqe n\u00eb vlera gjat\u00eb k\u00ebrkesave t\u00eb zakonshme, mund t\u00eb p\u00ebrdoret fill(previous). Kjo e detyron InfluxDB t\u00eb p\u00ebrdor\u00eb vler\u00ebn e or\u00ebs s\u00eb m\u00ebparshme. <\/p>\n<p>Fatkeq\u00ebsisht, continuous query ka nj\u00eb ve\u00e7ori: truku fill(previous) nuk funksionon dhe regjistrimet thjesht nuk krijohen. Madje kjo \u00ebsht\u00eb nj\u00eb problematik\u00eb q\u00eb duket e pazgjidhshme dhe q\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/influxdb\/issues\/3220\">diskutohet prej vitesh<\/a><\/noindex>. Me k\u00ebt\u00eb problem do t\u00eb merremi m\u00eb von\u00eb, nd\u00ebrsa fill(previous) le t\u00eb mbetet n\u00eb continuous query \u2014 nuk pengon. <\/p>\n<p>Le t\u00eb kontrollojm\u00eb \u00e7far\u00eb kemi marr\u00eb si rezultat (natyrisht, duhet t\u00eb prisni disa or\u00eb):<\/p>\n<pre><code class=\"python\">&gt; select * from homeassistant.month.water_meter_hour group by entity_id\n...\nname: water_meter_hour\ntags: entity_id=water_meter_cold\ntime                 value\n----                 -----\n...\n2020-03-08T01:00:00Z 370511\n2020-03-08T02:00:00Z 370513\n2020-03-08T05:00:00Z 370527\n2020-03-08T06:00:00Z 370605\n2020-03-08T07:00:00Z 370635\n2020-03-08T08:00:00Z 370699\n2020-03-08T09:00:00Z 370761\n2020-03-08T10:00:00Z 370767\n2020-03-08T11:00:00Z 370810\n2020-03-08T12:00:00Z 370818\n2020-03-08T13:00:00Z 370827\n2020-03-08T14:00:00Z 370849\n2020-03-08T15:00:00Z 370921\n<\/code><\/pre>\n<p>\nVini re se vlerat n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave ruhen n\u00eb UTC, prandaj n\u00eb k\u00ebt\u00eb list\u00eb ato ndryshojn\u00eb me 3 or\u00eb \u2014 vlerat p\u00ebr or\u00ebn 7 t\u00eb m\u00ebngjesit n\u00eb daljen e InfluxDB p\u00ebrputhen me vlerat p\u00ebr or\u00ebn 10 t\u00eb m\u00ebngjesit n\u00eb grafiqet m\u00eb sip\u00ebr. Gjithashtu, vini re se midis or\u00ebs 2 dhe 5 t\u00eb m\u00ebngjesit thjesht nuk ka regjistrime \u2014 kjo \u00ebsht\u00eb pik\u00ebrisht ajo ve\u00e7ori e continuous query.<\/p>\n<p>Si\u00e7 mund ta shihni, edhe vlera e agreguar \u00ebsht\u00eb nj\u00eb sekuenc\u00eb monotone n\u00eb rritje, vet\u00ebm se regjistrimet shfaqen m\u00eb rrall\u00eb \u2014 nj\u00eb her\u00eb n\u00eb or\u00eb. Por kjo nuk \u00ebsht\u00eb problem \u2014 mund t\u00eb shkruajm\u00eb edhe nj\u00eb query tjet\u00ebr q\u00eb do t\u00eb nxjerr\u00eb t\u00eb dh\u00ebnat e sakta p\u00ebr grafikun.<\/p>\n<pre><code class=\"sql\">SELECT difference(max(value)) \nFROM homeassistant.month.water_meter_hour \nWHERE entity_id='water_meter_cold' and time &gt;= now() -24h \nGROUP BY time(1h), entity_id \nfill(previous)<\/code><\/pre>\n<p>\nPo e shpjegoj:<\/p>\n<ul>\n<li>Nga baza homeassistant.month.water_meter_hour do t\u00eb nxjerrim t\u00eb dh\u00ebnat p\u00ebr entity_id=&#8217;water_meter_cold&#8217; p\u00ebr 24 or\u00ebt e fundit (time &gt;= now() -24h). <\/li>\n<li>Si\u00e7 e p\u00ebrmenda m\u00eb sip\u00ebr, n\u00eb sekuenc\u00ebn homeassistant.month.water_meter_hour mund t\u00eb mungojn\u00eb disa regjistrime. K\u00ebto t\u00eb dh\u00ebna do t\u2019i gjenerojm\u00eb s\u00ebrish duke ekzekutuar query me GROUP BY time(1h). K\u00ebt\u00eb her\u00eb fill(previous) do t\u00eb funksionoj\u00eb si\u00e7 duhet, duke gjeneruar t\u00eb dh\u00ebnat q\u00eb mungojn\u00eb (funksioni do t\u00eb marr\u00eb vler\u00ebn e m\u00ebparshme)<\/li>\n<li>Pjesa m\u00eb e r\u00ebnd\u00ebsishme n\u00eb k\u00ebt\u00eb query \u00ebsht\u00eb funksioni difference, i cili llogarit diferenc\u00ebn midis pikave orare. N\u00eb vetvete ai nuk funksionon dhe k\u00ebrkon nj\u00eb funksion agregues. Le t\u00eb jet\u00eb max(), i p\u00ebrdorur m\u00eb par\u00eb.<\/li>\n<\/ul>\n<p>\nRezultati i ekzekutimit duket k\u00ebshtu<\/p>\n<pre><code class=\"python\">name: water_meter_hour\ntags: entity_id=water_meter_cold\ntime                 difference\n----                 ----------\n...\n2020-03-08T02:00:00Z 2\n2020-03-08T03:00:00Z 0\n2020-03-08T04:00:00Z 0\n2020-03-08T05:00:00Z 14\n2020-03-08T06:00:00Z 78\n2020-03-08T07:00:00Z 30\n2020-03-08T08:00:00Z 64\n2020-03-08T09:00:00Z 62\n2020-03-08T10:00:00Z 6\n2020-03-08T11:00:00Z 43\n2020-03-08T12:00:00Z 8\n2020-03-08T13:00:00Z 9\n2020-03-08T14:00:00Z 22\n2020-03-08T15:00:00Z 72<\/code><\/pre>\n<p>\nNga ora 2 deri n\u00eb 5 t\u00eb m\u00ebngjesit (UTC) nuk ka pasur konsum. Megjithat\u00eb, k\u00ebrkesa do t\u00eb kthej\u00eb t\u00eb nj\u00ebjt\u00ebn vler\u00eb konsumi fal\u00eb fill(previous), nd\u00ebrsa funksioni difference do ta zbres\u00eb k\u00ebt\u00eb vler\u00eb nga vetja dhe n\u00eb dalje do t\u00eb marrim 0, q\u00eb \u00ebsht\u00eb pik\u00ebrisht ajo q\u00eb na duhet.<\/p>\n<p>Mbetet vet\u00ebm hapi i fundit \u2014 t\u00eb nd\u00ebrtojm\u00eb grafikun. P\u00ebr k\u00ebt\u00eb hapim Grafana, hapim nj\u00eb dashboard ekzistues (ose krijojm\u00eb nj\u00eb t\u00eb ri) dhe shtojm\u00eb nj\u00eb panel t\u00eb ri. Cil\u00ebsimet e grafikut do t\u00eb jen\u00eb si m\u00eb posht\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/c6f551590cd141438b644b24aa4ddebf.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nUn\u00eb do t\u00eb shfaq t\u00eb dh\u00ebnat p\u00ebr ujin e ftoht\u00eb dhe t\u00eb ngroht\u00eb n\u00eb t\u00eb nj\u00ebjtin grafik. K\u00ebrkesa \u00ebsht\u00eb sakt\u00ebsisht e nj\u00ebjt\u00eb si\u00e7 e p\u00ebrshkrova m\u00eb sip\u00ebr. <\/p>\n<p>Parametrat e shfaqjes vendosen k\u00ebshtu. N\u00eb rastin tim do t\u00eb jet\u00eb nj\u00eb grafik me vija (lines), i paraqitur me hapa (stairs). Parametrin Stack do ta shpjegoj pak m\u00eb posht\u00eb. Ka edhe disa parametra t\u00eb tjer\u00eb t\u00eb shfaqjes, por nuk jan\u00eb aq interesant\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/cb47fc8570b7fd1305ce3451e0518f11.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nP\u00ebr t\u00eb shtuar grafikun e krijuar n\u00eb home assistant, duhet:<\/p>\n<ul>\n<li>t\u00eb dilni nga modaliteti i redaktimit t\u00eb grafikut. P\u00ebr ndonj\u00eb arsye, cil\u00ebsimet e sakta p\u00ebr ndarjen e grafik\u00ebve ofrohen vet\u00ebm nga faqja e dashboard-it<\/li>\n<li>T\u00eb klikoni mbi trek\u00ebnd\u00ebshin pran\u00eb emrit t\u00eb grafikut dhe n\u00eb menu t\u00eb zgjidhni share<\/li>\n<li>N\u00eb dritaren q\u00eb hapet, kaloni te skeda embed<\/li>\n<li>Hiqni shenj\u00ebn te current time range \u2014 diapazoni kohor do t\u00eb p\u00ebrcaktohet p\u00ebrmes URL-s\u00eb <\/li>\n<li>Zgjidhni tem\u00ebn e nevojshme. N\u00eb rastin tim \u00ebsht\u00eb light<\/li>\n<li>Kopjoni URL-n\u00eb e krijuar n\u00eb kart\u00ebn e cil\u00ebsimeve t\u00eb lovelace-UI<\/li>\n<\/ul>\n<p><\/p>\n<pre><code class=\"python\">      - type: iframe\n        id: graf_water_hourly\n        url: &quot;http:\/\/192.168.10.200:3000\/d-solo\/rZARemQWk\/water?orgId=1&amp;panelId=2&amp;from=now-2d&amp;to=now&amp;theme=light&quot;\n<\/code><\/pre>\n<p>\nVini re se diapazoni kohor (2 dit\u00ebt e fundit) p\u00ebrcaktohet pik\u00ebrisht k\u00ebtu, jo te cil\u00ebsimet e dashboard-it. <\/p>\n<p>Grafiku duket k\u00ebshtu. Uj\u00eb t\u00eb ngroht\u00eb nuk kam p\u00ebrdorur gjat\u00eb 2 dit\u00ebve t\u00eb fundit, prandaj shfaqet vet\u00ebm grafiku i ujit t\u00eb ftoht\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/d18c82712d3b829a97ada8c8e2adce24.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nUn\u00eb ende nuk kam vendosur se cili grafik m\u00eb p\u00eblqen m\u00eb shum\u00eb: ai me vij\u00eb n\u00eb form\u00eb shkall\u00ebsh apo shtyllat reale. Prandaj po jap thjesht nj\u00eb shembull t\u00eb grafikut ditor t\u00eb konsumit, por k\u00ebt\u00eb her\u00eb me shtylla. K\u00ebrkesat nd\u00ebrtohen n\u00eb t\u00eb nj\u00ebjt\u00ebn m\u00ebnyr\u00eb si m\u00eb sip\u00ebr. Parametrat e shfaqjes jan\u00eb k\u00ebta:<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/557297e666f9cd73c3d2aa2fd80c0a2d.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKy grafik duket k\u00ebshtu:<\/p>\n<p><img decoding=\"async\" alt=\"Sht\u00ebpi e men\u00e7ur: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant\" src=\"\/wp-content\/uploads\/2020\/03\/ac8c53569c6b05aeb22e05969de4cd6d.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSa p\u00ebr parametrin Stack. N\u00eb k\u00ebt\u00eb grafik, shtylla e ujit t\u00eb ftoht\u00eb vizatohet mbi shtyll\u00ebn e ujit t\u00eb ngroht\u00eb. Lart\u00ebsia totale p\u00ebrputhet me konsumin e p\u00ebrgjithsh\u00ebm t\u00eb ujit t\u00eb ftoht\u00eb dhe t\u00eb ngroht\u00eb p\u00ebr periudh\u00ebn. <\/p>\n<p>T\u00eb gjith\u00eb grafik\u00ebt e paraqitur jan\u00eb dinamik\u00eb. Mund ta vendosni miun mbi pik\u00ebn q\u00eb ju intereson p\u00ebr t\u00eb par\u00eb detajet dhe vler\u00ebn n\u00eb at\u00eb pik\u00eb t\u00eb caktuar. <\/p>\n<p>Fatkeq\u00ebsisht, nuk shp\u00ebtuam pa disa mang\u00ebsi. Te grafiku me shtylla (ndryshe nga grafiku me vija-shkall\u00eb), qendra e shtyll\u00ebs nuk bie n\u00eb mes t\u00eb dit\u00ebs, por n\u00eb 00:00. Pra, gjysma e majt\u00eb e shtyll\u00ebs vizatohet n\u00eb vendin e dit\u00ebs s\u00eb m\u00ebparshme. P\u00ebr k\u00ebt\u00eb arsye, grafiqet p\u00ebr t\u00eb shtun\u00ebn dhe t\u00eb diel\u00ebn dalin pak m\u00eb majtas se zona me nuanc\u00eb blu. Deri tani nuk kam gjetur ende si ta zgjidh k\u00ebt\u00eb. <\/p>\n<p>Nj\u00eb problem tjet\u00ebr \u00ebsht\u00eb pamund\u00ebsia p\u00ebr t\u00eb punuar sakt\u00eb me intervalet mujore. \u00c7\u00ebshtja \u00ebsht\u00eb se gjat\u00ebsia e or\u00ebs\/dit\u00ebs\/jav\u00ebs \u00ebsht\u00eb fikse, nd\u00ebrsa gjat\u00ebsia e muajit ndryshon \u00e7do her\u00eb. InfluxDB di t\u00eb punoj\u00eb vet\u00ebm me intervale t\u00eb nj\u00ebjta. Deri tani zgjidhja ime ka qen\u00eb t\u00eb vendos nj\u00eb interval fiks prej 30 dit\u00ebsh. Po, gjat\u00eb vitit grafiku do t\u00eb zhvendoset pak dhe shtyllat nuk do t\u2019u korrespondojn\u00eb plot\u00ebsisht muajve. Por, meq\u00eb kjo gj\u00eb m\u00eb duhet thjesht si nj\u00eb tregues vizual, kjo p\u00ebr mua \u00ebsht\u00eb n\u00eb rregull. <\/p>\n<p>Shoh t\u00eb pakt\u00ebn dy zgjidhje:<\/p>\n<ul>\n<li>T\u00eb heq dor\u00eb nga grafiqet mujore dhe t\u00eb kufizohem te ato javore. 52 shtylla javore n\u00eb vit duken mjaft mir\u00eb<\/li>\n<li>Vet\u00eb konsumin mujor ta llogaris me metod\u00ebn nr. 2, nd\u00ebrsa Grafana ta p\u00ebrdor vet\u00ebm p\u00ebr grafik\u00eb t\u00eb bukur. K\u00ebshtu do t\u00eb dal\u00eb nj\u00eb zgjidhje mjaft e sakt\u00eb. Madje mund t\u00eb mbivendosen edhe grafiqet e vitit t\u00eb kaluar p\u00ebr krahasim \u2014 Grafana e mb\u00ebshtet edhe k\u00ebt\u00eb.<\/li>\n<\/ul>\n<h2>P\u00ebrfundim<\/h2>\n<p>\nNuk e di pse, por m\u00eb p\u00eblqejn\u00eb shum\u00eb k\u00ebto lloj grafik\u00ebsh. Ato tregojn\u00eb se jeta \u00ebsht\u00eb n\u00eb l\u00ebvizje dhe gjith\u00e7ka ndryshon. Dje kishte shum\u00eb, sot ka pak, nes\u00ebr do t\u00eb jet\u00eb ndryshe. Tani mbetet t\u00eb punohet me familjar\u00ebt p\u00ebr tem\u00ebn e konsumit. Por edhe me k\u00ebt\u00eb nivel aktual shpenzimi, shifra e madhe dhe e pakuptueshme n\u00eb fatur\u00eb tashm\u00eb po kthehet n\u00eb nj\u00eb pamje mjaft t\u00eb qart\u00eb t\u00eb konsumit.<\/p>\n<p>Pavar\u00ebsisht nj\u00eb karriere pothuajse 20-vje\u00e7are si programues, me bazat e t\u00eb dh\u00ebnave pothuajse nuk jam p\u00ebrballur fare. Prandaj, instalimi i nj\u00eb baze t\u00eb dh\u00ebnash t\u00eb jashtme m\u00eb dukej si di\u00e7ka tep\u00ebr e nd\u00ebrlikuar dhe e paqart\u00eb. Gjith\u00e7ka e ndryshoi <noindex><a rel=\"nofollow\" href=\"https:\/\/dummylabs.com\/ru\/post\/2019-01-13-influxdb-part1\">artikulli i p\u00ebrmendur m\u00eb sip\u00ebr<\/a><\/noindex> \u2014 doli se lidhja e mjetit t\u00eb duhur b\u00ebhet me vet\u00ebm disa klikime, dhe me nj\u00eb mjet t\u00eb specializuar detyra e nd\u00ebrtimit t\u00eb grafik\u00ebve b\u00ebhet disi m\u00eb e thjesht\u00eb.<\/p>\n<p>N\u00eb titull p\u00ebrmenda konsumin e energjis\u00eb elektrike. Fatkeq\u00ebsisht, p\u00ebr momentin nuk mund t\u00eb paraqes asnj\u00eb grafik. Nj\u00ebri mat\u00ebs SDM120 m\u00eb \u00ebsht\u00eb prishur, nd\u00ebrsa tjetri ka probleme kur aksesohet p\u00ebrmes Modbus. Megjithat\u00eb, kjo nuk ndikon aspak n\u00eb tem\u00ebn e k\u00ebtij artikulli \u2014 grafiqet do t\u00eb nd\u00ebrtohen n\u00eb t\u00eb nj\u00ebjt\u00ebn m\u00ebnyr\u00eb si p\u00ebr ujin.<\/p>\n<p>N\u00eb k\u00ebt\u00eb artikull kam p\u00ebrshkruar qasjet q\u00eb i kam provuar vet\u00eb. Me siguri ka edhe m\u00ebnyra t\u00eb tjera p\u00ebr organizimin e mbledhjes dhe vizualizimit t\u00eb t\u00eb dh\u00ebnave, p\u00ebr t\u00eb cilat un\u00eb nuk di. M\u00eb tregoni p\u00ebr to n\u00eb komente, do t\u00eb ishte shum\u00eb interesante p\u00ebr mua. Do t\u00eb jem i lumtur t\u00eb marr kritika konstruktive dhe ide t\u00eb reja. Shpresoj q\u00eb materiali i paraqitur t\u2019i ndihmoj\u00eb edhe dikujt tjet\u00ebr.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/492314\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u043f\u043e\u043b\u0443\u0447\u0430\u044f \u043f\u043b\u0430\u0442\u0435\u0436\u043a\u0443 \u0437\u0430 \u044d\u043b\u0435\u043a\u0442\u0440\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0438 \u0432\u043e\u0434\u0443 \u044f \u0443\u0434\u0438\u0432\u043b\u044f\u044e\u0441\u044c \u2014 \u043d\u0435\u0443\u0436\u0435\u043b\u0438 \u043c\u043e\u044f \u0441\u0435\u043c\u044c\u044f \u0441\u0442\u043e\u043e\u043e\u043e\u043e\u043b\u044c\u043a\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u044f\u0435\u0442? \u041d\u0443 \u0434\u0430, \u0432 \u0432\u0430\u043d\u043d\u043e\u0439 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d \u0442\u0435\u043f\u043b\u044b\u0439 \u043f\u043e\u043b \u0438 \u0431\u043e\u0439\u043b\u0435\u0440, \u043d\u043e \u0432\u0435\u0434\u044c \u043e\u043d\u0438 \u0436\u0435 \u043d\u0435 \u043a\u043e\u0447\u0435\u0433\u0430\u0440\u044f\u0442 \u043f\u043e\u0441\u0442\u043e\u044f\u043d\u043d\u043e. \u0412\u043e\u0434\u0443 \u0442\u043e\u0436\u0435 \u0432\u0440\u043e\u0434\u0435 \u044d\u043a\u043e\u043d\u043e\u043c\u0438\u043c (\u0445\u043e\u0442\u044f \u043f\u043e\u043f\u043b\u0435\u0441\u043a\u0430\u0442\u044c\u0441\u044f \u0432 \u0432\u0430\u043d\u043d\u043e\u0439 \u0442\u043e\u0436\u0435 \u043b\u044e\u0431\u0438\u043c). \u041d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043b\u0435\u0442 \u043d\u0430\u0437\u0430\u0434 \u044f \u0443\u0436\u0435 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u043b \u0441\u0447\u0435\u0442\u0447\u0438\u043a\u0438 \u0432\u043e\u0434\u044b \u0438 \u044d\u043b\u0435\u043a\u0442\u0440\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u043a \u0443\u043c\u043d\u043e\u043c\u0443 \u0434\u043e\u043c\u0443, [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":74422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-74421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0423\u043c\u043d\u044b\u0439 \u0434\u043e\u043c: \u0421\u0442\u0440\u043e\u0438\u043c \u0433\u0440\u0430\u0444\u0438\u043a\u0438 \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f \u0432\u043e\u0434\u044b \u0438 \u044d\u043b\u0435\u043a\u0442\u0440\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u0432 Home Assistant | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-17T05:43:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-17T05:43:08+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Sht\u00ebpia inteligjente: Nd\u00ebrtojm\u00eb grafik\u00eb t\u00eb konsumit t\u00eb ujit dhe energjis\u00eb elektrike n\u00eb Home Assistant | ProHoster","description":"\u00c7do her\u00eb.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0423\u043c\u043d\u044b\u0439 \u0434\u043e\u043c: \u0421\u0442\u0440\u043e\u0438\u043c \u0433\u0440\u0430\u0444\u0438\u043a\u0438 \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f \u0432\u043e\u0434\u044b \u0438 \u044d\u043b\u0435\u043a\u0442\u0440\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u0432 Home Assistant | ProHoster","og:description":"\u041a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/umnyj-dom-stroim-grafiki-potrebleniya-vody-i-elektrichestva-v-home-assistant","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-03-17T05:43:08+00:00","article:modified_time":"2020-03-17T05:43:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"74421","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 18:15:28","updated":"2022-09-27 16:07:45","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/74421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=74421"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/74421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/74422"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=74421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=74421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=74421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}