New user and first question about visualization

Get Help
1

Howdy-

I discovered Metabase last week, my company suddenly needs metrics and dashboards and I was officially heralded for the task :slight_smile:

I am still learning how it works, I am comfortable with SQL requests though.

I have this simple table of results, first question: how come I cannot choose a Row visualization?

02%20PM
02%20PM1500Ă—922 106 KB

And second question (I guess it's related): if I choose Pie, I cannot select my Measure data, drop down says "no valid fields". Can you help?

Thanks and have a great day!

2

Thanks for checking out Metabase!

Both the Row and Pie problems you’re running into seem to be caused by the fact that it seems like your Nbre j-p column is a string rather than a number (assuming you’re trying to use that column as your metric/measure in both cases). What you can do is go to the Admin Panel from the gear in the top-right of Metabase, then go to the Data Model section, select the database that column is in from the dropdown in the top-left, pick the table the column is in from the sidebar, then scroll to the column and see what its “Type” is set to. Change it to “Number” if it’s not set to anything else and let me know if that fixes these issue for you.

Cheers,
Maz

3

Thanks @maz

Success. It was something like this, in my request I had FORMAT(SUM(charge)/420,1) AS 'j-p' that outputted a string. I changed for ROUND(SUM(cdt.charge)/420,1) AS 'j-p' and now it works fine, I can get all the visualizations that I need.

Thank you :slight_smile:

4

Nice, glad you figured it out!

1 Like