In the below chart if u can see i have used round and avg to first_response and closure time.
But my values are not accurate, i want the values like if its 1.3 or 1.9 also it should display 2 but mine is shown as 1.3 is 1 and 1.9 is 2.
But to perform the above function ceil isnt working what to do ?
ceil() doesn't work as part of an aggregation but you can perform it afterwards.
| chart avg(FIRST_RESPONSE) as FIRST_RESPONSE avg(CLOSURE_TIME) as CLOSURE_TIME over MONTH
| eval FIRST_RESPONSE = ceil(FIRST_RESPONSE)
| eval CLOSURE_TIME = ceil(CLOSURE_TIME)
ceil() doesn't work as part of an aggregation but you can perform it afterwards.
| chart avg(FIRST_RESPONSE) as FIRST_RESPONSE avg(CLOSURE_TIME) as CLOSURE_TIME over MONTH
| eval FIRST_RESPONSE = ceil(FIRST_RESPONSE)
| eval CLOSURE_TIME = ceil(CLOSURE_TIME)
Thanks alot it worked
You mean |chart eval(round(avg(FIRST_RESPONSE), 1)) as FIRST_RESPONSE?
Hi @Vish
to get decimal values please use 2 instead of 0 in round function
----
Regards,
Sanjay Reddy
----
If this reply helps you, Karma would be appreciated