I have some tables like below extracting from a csv file.
BusinessUnit Status SLAMET
Finance Mailed On-Time
Finance Mailed Late
Finance Mailed Early
Finance Processed No Status
Finance Processed No Status
HR Mailed On-Time
HR Mailed Late
HR Mailed Early
HR Processed No Status
HR Processed No Status
I want to write a search query which returns the counts and percentages as below.. Can someone please help?
BusinessUnit Total OnTime %OnTime Late %Late Early %Early
Finance 5 1 20% 1 20% 1 20%
HR 5 1 20% 1 20% 1 20%
Try like this
your current search giving fields BusinessUnit, Status, SLAMET
| stats count as Total count(eval(SLAMET="On-Time")) as OnTime count(eval(SLAMET="Late")) as Late count(eval(SLAMET="Early")) as Early | eval "%Ontime"=tostring(round(OnTime*100/Total,1))."%" | eval "%Late"=tostring(round(Late*100/Total,1))."%" | eval "%Early"=tostring(round(Early*100/Total,1))."%"
| table BusinessUnit Total OnTime "%OnTime" Late "%Late" Early "%Early"
Try like this
your current search giving fields BusinessUnit, Status, SLAMET
| stats count as Total count(eval(SLAMET="On-Time")) as OnTime count(eval(SLAMET="Late")) as Late count(eval(SLAMET="Early")) as Early | eval "%Ontime"=tostring(round(OnTime*100/Total,1))."%" | eval "%Late"=tostring(round(Late*100/Total,1))."%" | eval "%Early"=tostring(round(Early*100/Total,1))."%"
| table BusinessUnit Total OnTime "%OnTime" Late "%Late" Early "%Early"
Thank You.. I just added the "stats by BusinessUnit" in the query. Thanks so much again.