I do have a database with a table as below:
CREATE TABLE `error_monitoring` (
`id` int(11) NOT NULL,
`error_monitoring_page` varchar(256) NOT NULL,
`error_code` varchar(64) NOT NULL,
`monitoring_country` varchar(64) DEFAULT NULL,
`platform` varchar(64) NOT NULL,
`total` int(64) NOT NULL,
`visits` int(64) NOT NULL,
`unique_visitors` int(64) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
In this table is stared data that comes from a .csv file. The .csv fila has only 5 columns:
- date
- error_monitoring_page
- total
- visits
- unique visitors
The rest of the information like country and platform is taken from the and error_code from the field "error_monitoring_page" in which this information is contained and then added into the corresponding field.
In the .csv file the information comes as below example:
2017/03/13 03:00:00,us:es:website:track-transfer:moneytransfer-tab|C1620,16,3,3
2017/03/13 03:00:00,us:es:website:price-estimator:continue|PS9999,4,3,3
2017/03/13 03:00:00,us:es:website:send-money:register|C6003,0,0,0
2017/03/13 03:00:00,us:es:website:send-money:sendmoneylogin|C1131,0,0,0
2017/03/13 03:00:00,us:es:website:send-money:start|PS9999,3,1,1
2017/03/13 03:00:00,us:es:website:price-estimator:continue|C1053,0,0,0
2017/03/13 03:00:00,us:es:website:send-money:start|C5000,8,4,4
This field "us:es:website:track-transfer:moneytransfer-tab|C1620" is containing :
error code : last 5 characters os the string.
monitoring_country: first 2 characters of the string.
and the platform: website
The .csv file is received every hours some we have in the database data for every hour of the day for each error_monitoring_page.
I need an MySql query that extracts and calculate the error codes that is exceeding for the total count of the day the Upper Control Limit.
Said that:
UCL = average+(2*standard deviation)
For example:
if total count of the current day for the error code C1620 is higher that the UCL the query should extract all the information of this error code:
- Error code
- average
- standard deviation
- total of the day
The average and the standard deviation should be calculated based on the total by day for the last 30 days.
Been working for several years on MySQL queries and having a great knowledge of MySQL queries.
Relevant Skills and Experience
MySQL, SQL, PHP
Proposed Milestones
$22 USD - Understanding and writing optimized query
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
10 freelancers are bidding on average $39 USD for this job
Hi arayafr.
do you need an mysql query that extracts and calculate the error codes that is exceeding for the total count of the day the upper control limit ?.I sure i can help you
We have experience in thoses skills: PHP, SQL, MySQL
SAVE your time and SAVE my time is my goal, do this project fast as possible and support you all time: now and feature
Please text me via inbox to discuss with me about this task
Relevant Skills and Experience
PHP, SQL, MySQL
Proposed Milestones
$20 USD - for starting project
We can Discuss custom Milestones
Hello Sir,
hope you are fine,
I ready your job proposal closly and gather all the requirement which you are written proplerly
I am interested in your work "to create mysql query".
Relevant Skills and Experience
I have 5 year experience in Web Development Service.
You can view my profile for details to skills and customer feedback
https://www.freelancer.com/u/kazimking
Proposed Milestones
$50 USD - Task 1
task is start after insertion of data from CSV or before ?
Hello,
i have completed project in PHP, LARAVEL, CodeIgniter, Symfony and MYSQL. I shall complete project in short time.
Regards,
Nitu Patel
Relevant Skills and Experience
I have 2.8 years experience in CSS3, HTML5, JQUERY, PHP, LARAVEL, CodeIgniter, Symfony AND MYSQL.
Proposed Milestones
$30 USD - initial milestones
$25 USD - second milestones