Hello,
I am combining two numbers charts and they are showing like in the picture below.
I would like them to show as normal bar charts, not like these lines. When I restore the visualization options to default it shows them as bars but it does not save them like that. I am not sure if it's a bug.
Ideally I would like to show them stacked on top of each other but I could not find any option to do that.
Can anyone help me?
Thank you!
Hi @Luiz_Huallpa
Please post "Diagnostic Info" from Admin > Troubleshooting.
I cannot reproduce on the latest 0.39.4: https://github.com/metabase/metabase/releases/latest
Hello,
Here it is.
Metabase was on 0.39.3 before. I updated and tried to put the graph together again but the same behavior is happening.
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 Edg/91.0.864.59",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.10+9-LTS",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": "https://www.redhat.com/",
"java.version": "11.0.10",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.10+9-LTS",
"os.name": "Linux",
"os.version": "3.10.0-1160.15.2.el7.x86_64",
"user.language": "pt",
"user.timezone": "America/Recife"
},
"metabase-info": {
"databases": [
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.3.28-MariaDB"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-06-15",
"tag": "v0.39.4",
"branch": "release-x.39.x",
"hash": "f538050"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}
@Luiz_Huallpa If the data in both questions comes from the same database, then you can create a single question instead, which will let you stack them - and all the other Bar settings.
Redirecting…
But something makes me think that the two questions perhaps got some visualization settings defined somewhere, which contaminates something - this are two newly created SQL Number-questions combined on dashboard:
I am having some issues combining both questions in a single one.
The SQL for my first question is this
SELECT sum(`Soft Proposta`.`PP_ValorTotalProposta`) AS `sum`
FROM soft_negocio
LEFT JOIN soft_produto Soft Produto ON soft_negocio.NG_IdProduto = Soft Produto.PR_Id LEFT JOIN soft_unidade Soft Unidade ON soft_negocio.NG_IdUnidade = Soft Unidade.UN_Id LEFT JOIN soft_etapa Soft Etapa ON soft_negocio.NG_IdEtapa = Soft Etapa.ET_Id LEFT JOIN soft_cliente Soft Cliente ON soft_negocio.NG_IdCliente = Soft Cliente.CL_Id LEFT JOIN soft_proposta Soft Proposta ON soft_negocio.NG_Id = Soft Proposta.PP_IdNegocio
WHERE (soft_negocio.NG_Status = 1
AND soft_negocio.NG_Fila = 1 AND soft_negocio.NG_IdEtapa = 3)
I want to add the question #47 to it. How do I do it?
@Luiz_Huallpa Create a new question and then do something like this:
select (#123) as Q1, (#321) as Q2
Otherwise try to recreate the two questions, since you must have added some visualization settings at some point, which is then causing problems.
I recreated the questions and they are working as intended now.
Thank you for the help!