Table box shows more values than Straight table?

[twanqlik]

I've uploaded a sample set with 3 records from the same customer, the only difference between the 3 records is the house number and the address type.

The table box shows the 3 records with the house number and the address type.

The straight table shows 1 record with no value (- value) for the house number and the address type.

How can i show all the 3 records in the straight table? Now it looks for the user that this customer doesn't have a 'house number' and an 'address type' in the database.

[Clever_Anjos · Accepted solution]

When you have a table it shows the records of your loaded data.

When you have a straight table you have

     . Dimensions (it´s supposed to have one for each combination of your dimensions)

     . Expressions (you´re supposed to have expressions here, not only fields).

Expressions means that you have a function (Sum, Concat, count, etc)

Into your example, put "Address Type" as Dimension too, it will show what you want

[twanqlik]

Thanks Clever that indeed works!

Suppose at this moment i don't have any expressions like a Sum, Concat, count etc, whould you then suggest to work with a Table box, or still with a straight table?

Suppose i continue with the straight table which fields should i define as a dimension and which as an expression? I assume i need to have at least one expression to show any data.

[avinashelite]

For your info Table box doesn't have the option to add the expression ..it will be just the plain representation of your data and could not format anything

[Clever_Anjos]

It depends what you need, if you need a plain representation of your data (no calculations at all) go with table.

Any other case, go with straight table