What are ways to use json to take the top 10 averages of max statistics over time?

Multi tool use
Multi tool use








up vote
0
down vote

favorite












I have a metric of performance for different reporters down to the second over several weeks. I'd like to use normal Kibana or json into Kibana to do the following:



It would: 



1) Find the max within hour for each reporter
2) Average this max by week
3) Pick the Top 10 reporters (of weekly avg of hourly max)
4) Display max metric vs. date histogram of this Top 10


I've searched online and have trouble finding good examples.






json elasticsearch data-visualization kibana







share|improve this question

























    up vote
    0
    down vote

    favorite












    I have a metric of performance for different reporters down to the second over several weeks. I'd like to use normal Kibana or json into Kibana to do the following:



    It would: 



    1) Find the max within hour for each reporter
    2) Average this max by week
    3) Pick the Top 10 reporters (of weekly avg of hourly max)
    4) Display max metric vs. date histogram of this Top 10


    I've searched online and have trouble finding good examples.






    json elasticsearch data-visualization kibana







    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have a metric of performance for different reporters down to the second over several weeks. I'd like to use normal Kibana or json into Kibana to do the following:



      It would: 



      1) Find the max within hour for each reporter
      2) Average this max by week
      3) Pick the Top 10 reporters (of weekly avg of hourly max)
      4) Display max metric vs. date histogram of this Top 10


      I've searched online and have trouble finding good examples.






      json elasticsearch data-visualization kibana







      share|improve this question













      I have a metric of performance for different reporters down to the second over several weeks. I'd like to use normal Kibana or json into Kibana to do the following:



      It would: 



      1) Find the max within hour for each reporter
      2) Average this max by week
      3) Pick the Top 10 reporters (of weekly avg of hourly max)
      4) Display max metric vs. date histogram of this Top 10


      I've searched online and have trouble finding good examples.






      json elasticsearch data-visualization kibana




      json elasticsearch data-visualization kibana






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 11 at 2:33









      Mark McGown

      697




      697



























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53245359%2fwhat-are-ways-to-use-json-to-take-the-top-10-averages-of-max-statistics-over-tim%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















           

          draft saved


          draft discarded















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53245359%2fwhat-are-ways-to-use-json-to-take-the-top-10-averages-of-max-statistics-over-tim%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          vI3FJ,h8 iNmM Lp rRD Z 4OH6LTTuUFdH
          -
          3nFpLpWeMIeb87BT9 X6JSHjqgCnVpsos941mA,h AvwNnbTS,ti9DtgEb,HO1CoH80J exgzDUCuQv,2 iziopgg0784S,mAjD7,5p3

          這個網誌中的熱門文章

          How to read a connectionString WITH PROVIDER in .NET Core?

          圖片
          6 I added .AddJsonFile("Connections.json", optional: true, reloadOnChange: true) in public Startup(IHostingEnvironment env) Connections.json contains: "ConnectionStrings": "DefaultConnection": "Server=(localdb)\mssqllocaldb;Database=DATABASE;Trusted_Connection=True;MultipleActiveResultSets=true", "COR-W81-101": "Data Source=DATASOURCE;Initial Catalog=P61_CAFM_Basic;User Id=USERID;Password=PASSWORD;Persist Security Info=False;MultipleActiveResultSets=False;Packet Size=4096;", "COR-W81-100": "Data Source=DATASOURCE;Initial Catalog=Post_PS;User Id=USERID;Password=PASSWORD;Persist Security Info=False;MultipleActiveResultSets=False;Packet Size=4096;", "MSEDGEWIN10": "Data Source=DATASOURCE; Initial Catalog=COR_Basic; Persist Security Info=False;Integrated Security=true;MultipleActiveResultSets=False;Packet Size=4096;Application Name="COR_Basic"", "server...
          閱讀完整內容

          Spillway

          圖片
          Chute spillway of Llyn Brianne dam in Wales A spillway is a structure used to provide the controlled release of flows from a dam or levee into a downstream area, typically the riverbed of the dammed river itself. In the United Kingdom, they may be known as overflow channels . Spillways ensure that the water does not overflow and damage or destroy the dam. Floodgates and fuse plugs may be designed into spillways to regulate water flow and reservoir level. Such a spillway can be used to regulate downstream flows – by releasing water in small amounts before the reservoir is full, operators can prevent sudden large releases that would happen if the dam were overtopped. Other uses of the term "spillway" include bypasses of dams or outlets of channels used during high water, and outlet channels carved through natural dams such as moraines. Water normally flows over a spillway only during flood periods – when the reservoir cannot hold the excess of water entering the reservoir ove...
          閱讀完整內容

          Americas

          圖片
          For other uses, see America (disambiguation). The Americas Area 42,549,000 km 2 (16,428,000 sq mi) Population 1,001,559,000 (2016 estimate) Population density 23.5389551 23.53896/km 2 ( 60.965614 60.9656/sq mi) GDP (nominal) $24.6 trillion (2016 estimate) GDP per capita $25,229 (2015) [1] HDI 0.736 [2] Demonym American, [3] New Worlder [4] (see usage) Countries 35 Languages Spanish, English, Portuguese, French, Haitian Creole, Quechua, Guaraní, Aymara, Nahuatl, Dutch and many others Time zones UTC−10:00 to UTC Largest cities Largest metropolitan areas Largest cities List 1.São Paulo 2.Lima 3.Mexico City 4.New York City 5.Bogotá 6.Rio de Janeiro 7.Santiago 8.Los Angeles 9.Caracas 10.Buenos Aires CIA political map of the Americas in Lambert azimuthal equal-area projection The Americas (also collectively called America ; French: Amérique , Spanish/Portuguese: América ) comprise the totality of the continents of North and Sou...
          閱讀完整內容