How to get higher up value for the columns in my chart when ceil isn't working?

[Vish]

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 ?

[ITWhisperer · Accepted solution]

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)

[Vish]

Thanks alot it worked

[yuanliu]

You mean |chart eval(round(avg(FIRST_RESPONSE), 1)) as FIRST_RESPONSE?

[SanjayReddy]

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