Experience of upgrading to 0.31

lucas.lima · November 12, 2018, 4:15pm

I'm confused, because, for me, MySQL Date columns are being formatted alright:

Usama · November 13, 2018, 6:44am

Did anyone notice that now we can't add data (result of another question) to question that shows numbers. In the previous version I created a graph like this, but after the update. There's no option. Am I missing something? or it is not possible now?
It was a useful feature to compare two different figures and visualize them

AndrewMBaines · November 13, 2018, 7:08am

Still there for me (on hover):

Or is this something else?

Usama · November 13, 2018, 7:17am

No, I'm talking about numbers only (no group by). The picture I shared above was the graph of only numbers (without any group by).
Here is the visualization of what I'm trying to describe.
Screenshot%20from%202018-11-13%2012-16-30

The questions which gives out only a single number aren't working as they used to do.

AndrewMBaines · November 13, 2018, 7:38am

Yep, you’re right. My existing questions comparing 2 numbers work, but it’s not possible to create any new ones.
One for 0.31.1

Usama · November 13, 2018, 8:21am

Yeah.
Dear @maz would you please look on this thing. It will be a great help.

maz · November 13, 2018, 5:39pm

Thanks for all the reports, everyone. I’ll spend some time investigating the things you’ve run into. Thanks for your patience, and I’ll post here if I need more info or if I have any updates.

maz · November 15, 2018, 7:33pm

Hi all.

So for the date formatting issues, are you only experiencing the problem with SQL/native queries? I.e., if you do a “Custom” question with the graphical builder, are your date formatting options working correctly? If so, we have this issue tracking this problem: https://github.com/metabase/metabase/issues/8906
I reproduced the issue with no longer being able to combine Number (scalar) saved questions on dashboard cards, and that’s being tracked here: https://github.com/metabase/metabase/issues/8948

We’ll hopefully address both of these issues in a 0.31.1 release.

AndrewMBaines · November 15, 2018, 8:41pm

I’m getting the date formatting problems on old questions using Custom. The options don’t appear as expected and the options that are available don’t always work.

lucas.lima · November 16, 2018, 1:54pm

I can’t get any time formatting working at all, neither via builder or native SQL. It simply does nothing here.

lucas.lima · November 16, 2018, 8:53pm

@maz, I’m also not unable to apply any of the new nice formatting options to a bar chart

maz · November 16, 2018, 10:28pm

Do you see any JavaScript console log errors (or server log errors) when trying to apply any formatting options, @lucas.lima? Regarding the bar chart formatting, what are you trying to do and what is not working exactly? Like, are you going to the Visualization Options, then the Data tab, then clicking on a gear next to a column to format the way your y-axis numbers look for example?

@AndrewMBaines Thanks for the additional info. I reread your previous comments above real quickly, but just to double check, is it correct that your data formatting problems are only with pre–existing Custom questions?

AndrewMBaines · November 17, 2018, 6:53am

So far, it's only been a problem for existing questions.
Old question, date column:

Same data, created as new:

Both are just raw data, no grouping or summary information,

Chivalry · November 19, 2018, 8:49am

Hi all, v0.31 is a great version, with features I have been looking forard to, and thanks a lot for the fabulous work of the development team. I am running the jar file on a windows7 pc, and I can login to the homepage, however unfortunately without any of the questions and dashboards I bulit in last months. When I switched back to version 0.304, everything looked fine. So is there anyone encountered the same problem with mine? And I hope some great guys can help me look through it. Thanks.

lucas.lima · November 19, 2018, 12:48pm

@maz

That is what I'm trying to do.
When I tried to change to "Scientific", for instance, I could see a JavaScript error, something like "Scientific can't be applied to that field". But, percent returns no error, and, yet, it does nothing to the numbers themselves (using either the decimal or the corresponding percentual values).

lucas.lima · November 19, 2018, 6:15pm

Hey!

I’ve been talking about those issues, but, hey there!

This issue

has been a major drawback for our usage of metabase since I started using it, because our DataBase relies badly on the indexes to perform properly (resulting in questions that, when written in SQL, would take 3 seconds, but, via query builder, 5 minutes).

NO MORE, BABY! Somehow, you MB guys managed to, through the usage of the timezone stuff in the query filters, cast away the usage of a DATE() function over the filtered column, resulting in MUCH improved query perfomance. I’m in love with that!

Maryke · January 25, 2019, 8:57am

Hi Usama,

This is interesting. I’ve just built a scaler question on the new version in our staging environment.

Perhaps you can expand a bit more on how this is not working. I am interested because we are aiming to upgrade in the next week but not having the scaler capability makes it a NO GO for us.

Thanks!
Maryke

flamber · January 25, 2019, 2:38pm

Hi @Maryke
You cannot merge two scalars - by using the Add button. So unless you use the merge feature, then it doesn’t affect you.