mysql - How to get avg time taken by grouping a particular column using sql? -


I have a table like this for which I am getting the total number of a specific call_count Datacenter for Model_ID in PHX , slc and SJC data meta_date. 

  machine_name hour_of_day sec_of_hour meta_date client_id MODEL_ID CALL_COUNT average median datacenter machine 13 168 2014-07-30 00:00:00 Test13N 65 100 38,6382 5 PHX machineâ 13 170 2014-07-30 00 : 00: 00 Test13N 65 200 34382 4 PHX machineB 13 168 2014-07-30 00:00:00 Test 13 N 65 200 33.62 3 SLC Machine B 13 170 2014-07-30 00:00:00 Test 13 N 65 300 32 60 2 SLC Machine C 13 168 2014-07-30 00:00:00 Test 13 N 65 400 31.20 6 SJC Machine C 13 170 2014-07-30 00:00:00 Test 13 N 65 500 39.82 8 SJC

then with the following question - 

  select client_id, model_id, sum (case when datacenter = 'PHX' then call_count END) phx, sum (case When datascent = 'SLC' So call_count END) SLC, sum (case when Datacenter = 'SJC' So CALL_COUNT end) Model B SJC where meta_date = CURDATE () - 1 group client_id, client_id, MODEL_ID ordered by MODEL_ID;

For ME Model_ID 65, this means 300 calls were made from PHX, 500 calls were made from SLC and 900 calls were made from SGC datacenter.

Issue Statement: -

What should I do, I have to show average time taken in PHX, SLC and SJC datacenters for all calls of a particular Model_ID. Similarly for PHX, SLC and SJC datacenters for median as well.

The mean mean time is taken by PHX datacenter taken by 300 calls in PHX datacenter and 300 calls in median time. Similarly for SLC and SJC

And I'm thinking about using the weighted average here. Since with the above table for the machineâ, 100 calls took an average of 34.382 ms in 170 seconds of hours taken for 168 seconds of call and 38 hours in an average PHX datacenter of 38.6382 MS.

So I am thinking of calculating the average weighted average of the PHX data center using 

  (100 * 38.6382 + 200 * 34.382) / ( 100 + 200)

In this end I need to show results like this - 

  client_id MODEL_ID PHX SLC SJC phx_avg phx_median slc_avg slc_median sjc_avg sjc_median test13n 65 300 from 500 900

adjust the above formula in my current SQL how do I so I 300 calls were taken by 300 calls in Piacaks average time Piacaks the May be an average calculation of time taken by. Similarly for SLC and SJC I am working with mysql database

calculating the average time Your idea of ​​using a weighted average for is correct.

This query () fixes the work. 

 Select  yoga (case when datascentor = 'PHX' then CALL_COUNT end) PHX, sum (case when datacenter = 'PHX' then callcount * average ADD) / zodiac ( case when datacenter = 'Piacaks so call_count END) phx_avg,

you do not have enough information to calculate your average number; That requires the presence of expansion records that went into the mediators shown in your table. You can calculate in any way the counterfeit, but if your traffic engineers base their work on a simulated median calculation, then your company will apologize. Do not do this!


-

Comments

Post a Comment

Popular posts from this blog

sqlite3 - UPDATE a table from the SELECT of another one -

I have the first table article where some data is missing. In the table, articles_tmp I have a part of the missing data. So I want to update the articles. Where the path path is data in articles_tmp.path where the path is not zero . With SQLite , it does not work: update article SET path = (SELECT at.path FROM Articles_tmp as AS, WHERE at.article_id = a.id and a.asp, the text is in the form and not on. It has been transmitted) where the path is null MS Access Along with, it works fine: Update Articles Join the Inner Articles at articles_tmp articles.id = articles_tmp.id SETP articles.path = articles_tmp.path Can anyone help? Sin CE SQL Server Syntax, which I provided, was not working, here this solution With whom I have come. A little modification of your original query, but with my "correlation" suggestion added. There is a SQL Bella for this: Here is the code: update article SET path = (SELECT path from articles_tmp AS T WHERE t.id
Read more

c# - Showing a SelectedItem's Property -

So I have enabled a rightclick option for my DataGrid. I want to display the only chosen property but it is not behaving like what I would like it to display my name and additional. Public category Paymentinfo {public int PaymentNo {get; Set; } Public string date {get; Set; } Public Double Pay {get; Set; } Public Double Principle {get; Set; } Public Double Interest {get; Set; } Public Double Balance {Received; Set; }} Private Zero MenuItem_OnClick (Object Sender, RoutedEventArgs e) {MessageBox.Show (AmortGrid.SelectedItem.ToString ()); } I'm trying to apply it without using a View Module! If I place a breakpoint where the messagebox and the recipient place it on selected ITEM, then this property will display the payment. A date-payment-principle-interest-balance is the only value that needs payment. Was hoping that it would be something like this MessageBox.Show (AmortGrid.SelectedItem.PaymentNo.ToString ()); When you call ToString () So you get the class typ
Read more

javascript - Render HTML after each iteration in loop -

I'm trying to gradually increase the font size of text on a web page. The code works in my place, although the new HTML / CSS does not render after every iteration of the loop and when all this is done, then display only the text of 100 px size. To see the text as if it is slowly zooming, I need to do this JavaScript is down because it is being used from a different file here is what I have ... < Pre> & lt; P class = "game-title" style = "font-size: 50px" & gt; Test & lt; / P & gt; Function sleep (milliseconds) {var start = new date (). GetTime (); For (var i = 0; i & lt; 1e7; i ++) {if ((new date). GetTime () - start) & gt; Milliseconds {break; CSS ('font-size', 'parseInt ($ (' game-title '). CSS (' font-size ')) + 1 + "pixels"); } While (parasont ($ ('# text'). Css ('font-size')) & lt; = 100) {sleep (1000); IncreaseSize (); Using CSS: Use of jQuery (sample):
Read more