CODEWITHSUNDEEP
pentaho
PentahoUser
PentahoUser

Reputation: 1

Data tables in Pentaho User Console dashboard don't show numbers correctly

I'm trying to insert a table in a Pentaho User Console dashboard which shows in the first column the name of a company and in the second column how much they have bought in a specified period of time. However, when previsualizing the numbers from the second column they are displayed in the form null + number, like null23456 and then when the table is created NaN is displayed instead of the numbers.

Oddly enough, the table is using the correct number (after the null) and even the order is correct when changing it, it just doesn't show up in the dashboard. It fails for both integers and floating point numbers.

The SQL query I'm using to retrieve the data is the following:

SELECT Nombre AS Empresa, EXTRACT(YEAR FROM F_factura) AS Año, EXTRACT(MONTH FROM F_factura) AS Mes, EXTRACT(DAY FROM F_factura) AS Día, I_monemp AS Importe FROM Facturas, Rsocial WHERE Facturas.rsocial_cod = Rsocial.cod

Import is the number I am trying to display in the second colum.

Data correctly shown on PUC analysis report

Data in previsualizing mode

Data in dashboard

I expect that a numbers like 2865 is shown, instead of null2865 in previsualizing mode and NaN when finished editing. In the end it seems that Pentaho correctly processes the numbers and makes operations like ordering based on them, but it doesn't display said numbers at all. I have no problem working with that data when doing any other task, like creating an Analysis Report, do you know what's happening here?

Upvotes: 0

Views: 347

Answers (1)

Cyrus
Cyrus

Reputation: 2195

It looks like the Table Component is applying incorrect formatting to the column.

Check the "Column Formats" property first, there might be a missing comma there.

If that setting is empty, there might be a mistake in Column Types or in one of the extra functions if you have defined any.

enter image description here

Upvotes: 0

Related Questions