{"id":1923,"date":"2021-11-15T21:39:01","date_gmt":"2021-11-15T20:39:01","guid":{"rendered":"http:\/\/sickel.net\/blogg\/?p=1923"},"modified":"2021-11-15T21:44:03","modified_gmt":"2021-11-15T20:44:03","slug":"presentere-fortid-og-fremtid-sammen-i-grafana","status":"publish","type":"post","link":"http:\/\/sickel.net\/blogg\/?p=1923","title":{"rendered":"Presentere fortid og fremtid sammen i Grafana"},"content":{"rendered":"\n<p>N\u00e5r man logger meteorologiske data er det spennende \u00e5 se hvordan \u00f8yeblikksdataene henger sammen med varslede data. N\u00e5r man bruker Grafana til \u00e5 presentere data, kan disse kobles sammen og presenteres som en enhet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" data-attachment-id=\"1929\" data-permalink=\"http:\/\/sickel.net\/blogg\/?attachment_id=1929\" data-orig-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1.png\" data-orig-size=\"1598,685\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot_2021-11-15-Hjemmelog-Grafana-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-1024x439.png\" src=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-1024x439.png\" alt=\"\" class=\"wp-image-1929\" srcset=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-1024x439.png 1024w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-300x129.png 300w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-768x329.png 768w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1-1536x658.png 1536w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana-1.png 1598w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Loggede data sammen med varslet v\u00e6r. Tempereratursensoren er for n\u00e6r huset og viser gjerne litt for h\u00f8y temperatur. For \u00e5 f\u00e5 trykket til \u00e5 passe, m\u00e5tte jeg justere for h\u00f8yde.<\/figcaption><\/figure>\n\n\n\n<p>Data fra meteorologisk institutt er tilgjengelige p\u00e5 https:\/\/api.met.no. For eksempel for \u00e5 hente v\u00e6rvarsel for 60N 15E p\u00e5 json format, bruk <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><a href=\"https:\/\/api.met.no\/weatherapi\/locationforecast\/2.0\/complete?lat=60.000&amp;lon=15.000\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/api.met.no\/weatherapi\/locationforecast\/2.0\/complete?lat=60.000&amp;lon=15.000<\/a><\/pre>\n\n\n\n<p>Dette datasettet oppdateres ca hver 6. time. For \u00e5 la api.met.no v\u00e6re mest mulig i fred, henter jeg ned dataene med cron med passende mellomrom og lagrer lokalt i en katalog som er tilgjengelig for en webserver (sett inn din gyldige epost for &#8220;din epost&#8221;) :<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/bin\/curl -s -A \"&lt;din epost&gt; \"https:\/\/api.met.no\/weatherapi\/locationforecast\/2.0\/complete?lat=60.000&amp;lon=15.000\" &gt; \/var\/www\/html\/forecast\/weather.json 2&gt;\/dev\/null<\/pre>\n\n\n\n<p>Dermed kan jeg f\u00e5 tak i v\u00e6rvarselet p\u00e5 http:\/\/minserver\/forecast\/weather.json<\/p>\n\n\n\n<p>I Grafana kan jeg da installere json api data source plugin. Den m\u00e5 settes opp for hver adresse det skal hentes data fra og konfigureres med urlen som dataene kan hentes fra. Da kan denne defineres som en datakilde for et grafana panel. For \u00e5 f\u00e5 ut tidspunkter og temperaturer, m\u00e5tte jeg sette opp to felter:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"106\" data-attachment-id=\"1928\" data-permalink=\"http:\/\/sickel.net\/blogg\/?attachment_id=1928\" data-orig-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1.png\" data-orig-size=\"1471,152\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot_2021-11-15-Hjemmelog-Grafana1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1-1024x106.png\" src=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1-1024x106.png\" alt=\"\" class=\"wp-image-1928\" srcset=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1-1024x106.png 1024w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1-300x31.png 300w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1-768x79.png 768w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana1.png 1471w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Grafana viser normalt data for noe som har skjedd. For \u00e5 vise fremtidig varslet v\u00e6r, m\u00e5 tidsskalaen forskyves for panelet:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"187\" data-attachment-id=\"1931\" data-permalink=\"http:\/\/sickel.net\/blogg\/?attachment_id=1931\" data-orig-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2.png\" data-orig-size=\"1471,268\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot_2021-11-15-Hjemmelog-Grafana2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2-1024x187.png\" src=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2-1024x187.png\" alt=\"\" class=\"wp-image-1931\" srcset=\"http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2-1024x187.png 1024w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2-300x55.png 300w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2-768x140.png 768w, http:\/\/sickel.net\/blogg\/wp-content\/2021\/11\/Screenshot_2021-11-15-Hjemmelog-Grafana2.png 1471w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Her er det dyttet 20 dager ut og s\u00e5 trukket 11 dager tilbake. Jeg fikk det ikke til \u00e5 fungere ved \u00e5 bare skyve 9 dager ut.<\/p>\n\n\n\n<p>Data for logget v\u00e6r henter jeg fra en vanlig tidsseriedatabase (i mitt tilfelle fra PostgreSQL, men alle slags datakilder som Grafana kan plotte en graf fra kan brukes). V\u00e6rvarselet er satt opp som et kombinert s\u00f8yle- og linjediagram. Dermed vises det tydelig for hvilken tidsperiode dataene kommer inn med h\u00f8yere oppl\u00f8sning.<\/p>\n\n\n\n<p>Husk \u00e5 kreditere met.no p\u00e5 panelet. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>N\u00e5r man logger meteorologiske data er det spennende \u00e5 se hvordan \u00f8yeblikksdataene henger sammen med varslede data. N\u00e5r man bruker Grafana til \u00e5 presentere data, kan disse kobles sammen og presenteres som en enhet. Data fra meteorologisk institutt er tilgjengelige &hellip; <a href=\"http:\/\/sickel.net\/blogg\/?p=1923\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1923","post","type-post","status-publish","format-standard","hentry","category-div"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pnVtD-v1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/posts\/1923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1923"}],"version-history":[{"count":4,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/posts\/1923\/revisions"}],"predecessor-version":[{"id":1935,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=\/wp\/v2\/posts\/1923\/revisions\/1935"}],"wp:attachment":[{"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1923"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sickel.net\/blogg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}