Remove decimal points and digits from count(*)

  • Resolved jamescarley

    (@jamescarley)


    3 years, 9 months ago

    Hi,

    I have a query that counts the amount of times something appears in a column. When I run the query it returns a whole number, but in the chart legend it shows the number as well as .00000.

    Is there a way to stop this? I’ve tried round(count(*)) but that still returns the same result.

    Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author joeyoungblood

    (@joeyoungblood)

    Hi James,

    Apologies for the delay in responding to you.

    I have reported this to our dev team as a bug and we are actively looking for a fix for this now.

    Do you have a link I can share with our developers so we can better see the issue? Examples of data in your db column (demo / fake data please), chart type, and your query would be helpful too.

    Note: You can also use our contact form to send information privately: https://www.wpbusinessintelligence.com/contact/

    • This reply was modified 3 years, 9 months ago by joeyoungblood.
Viewing 1 replies (of 1 total)
  • The topic ‘Remove decimal points and digits from count(*)’ is closed to new replies.