With my below query, how can I convert the value of %Empty and %Occupied to Percentage instead of decimal? then add the % sign?
Thanks a lot!
| chart values(NOOFEMPTYLOCATIONS) AS EMPTY eval(values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS)) as OCCUPIED eval(values(NOOFEMPTYLOCATIONS)/values(NOOFLOCATIONS)) as %EMPTY eval((values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS))/values(NOOFLOCATIONS)) as %OCCUPIED by Aisle
@auaave when you are aliasing the field name it is better you do not have special character i.e.
%. That should be your final step before presenting to users i.e.
| rename EMPTY_PERC as "Empty %"
Which is the visualization you are using? Most Visualization settings allow you to round off the value without decimal using
Number Formatting and also change the display unit as per your needs like
In other words if you can give your current output with expected, the solution can be directly in
UI Edit options to