This API is based on a data engine in which forecasting and statistical analysis can be done quickly, safely and reliably.
The only thing the application engineer or developer
has to do is send the POST request with the appropriate json structure to the
body of the API.
This is a SAAS and is completely in the
cloud with availability 24/7, 365 days a year.
The service is offered free of charge for evaluation, giving access to a token and url.
FIRST PART
STATISTICAL ANALYSIS
1.- File (Example): Call_Center.csv (Jan-2023 to Apr-2023) = 100,000 records
2.- Upload file: Call_Center.csv (In postman POST):
URL
https://microcarsil.ddnsfree.com:9089/services/receivers/stream?sourcetype=csv&index=demo
HEADERS
Authorization = Bearer "Code"
BODY
form-data: Call_Center.csv
3.- Delete file: Call_Center.csv
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | delete |
4.- Total records (In postman POST):
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total |
5.- Organize by month:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | timechart
span=1mon count as Calls | table _time, Calls |
|
count |
0 |
span=1w span=1d span=1h
| tail 50 or | head 50
Friendly view
6.- Organize by Direction:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by Direction |
|
count |
0 |
Friendly
view
7.- Organize by SLA:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by SLA |
|
count |
0 |
8.- Date (Epoch):
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" |table
"Date" | eval Date = strptime('Date',"%d/%m/%Y") | stats
max(*) AS *."max", min(*) as *."min" |
Friendly
view
9.- Organize by DOW:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by DOW |
|
count |
0 |
Friendly
view
10.- Organize by Phone Number:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by "Phone Number" |
|
count |
0 |
Friendly view
11.- Organize by Queue Duration:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | filldown | table
"Queue Duration" | stats max(*) AS *."max", min(*) as
*."min" |
Friendly
view
12.- Organize by Queue Seconds:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | table "Queue
Seconds" | stats max(*) AS *."max", min(*) as
*."min" |
Friendly
view
13.- Organize by Queue:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by Queue |
|
count |
0 |
Friendly
view
14.- Organize by Username:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by Username |
|
count |
0 |
Friendly view
15.- Organize by Region:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | stats count as
Total by Region |
|
count |
0 |
Friendly
view
16.- Average call time per agent in seconds:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | eval
duration=strptime('Handle Time',"%H:%M:%S")| eval
base=strptime("00:00:00","%H:%M:%S") | eval secs=duration-base|
stats avg(secs) as Handel_Time_avg_sec by Username |
|
count |
0 |
Friendly view
17.- Average call time of all agents in seconds:
URL
https://microcarsil.ddnsfree.com:9089/services/search/jobs
HEADERS
Authorization = Bearer "Code"
BODY
x-www-form-urlencoded:
|
Key |
Value |
|
output_mode |
json |
|
exec_mode |
oneshot |
|
search |
search
index="demo" source="Call_Center.csv" | eval
duration=strptime('Handle Time',"%H:%M:%S")| eval
base=strptime("00:00:00","%H:%M:%S") | eval
secs=duration-base| stats avg(secs) as Handel_Time_avg_sec |
Friendly view
10.5 minutes
No hay comentarios:
Publicar un comentario