Query Help: Trying to truncate data

Need help
1

Hello,

I have been working this query for the past few hours and can’t seem to make it work. All I am trying to do is format the data to only show the whole number on the Y axis (i.e.,100, 90, 80) and not a number with a decimal (i.e., 100.00000). Normally I use the “format” action, but it does not work due to an error that says, “should be list of number but right now it is list of text”. If anyone know a way to truncate the decimal data that would be great.

bubble
bubble1391×1218 123 KB

Thanks,
Jim

2

This topic was automatically closed after 70 days. New replies are no longer allowed.