Straight Table vs Table Box

[#1]

Hi All,

I've just discovered that a Table Box removes duplicates - ie it only displays the unique combinations across the selected fields. I had always thought that the Table Box just showed you what was in your table, dupes and all! It took me some time to work out if the Table Box was removing dupes or if the Straight Table was double counting....

So that got me thinking - how do I see a straight representation of what's in my table? Sorry if this is a stupid question but I had always thought I could use a Table Box for this purpose.

I tried using an expressionless Straight Table, just putting all my required fields in as Dimensions, but that just tells me 'All expressions disabled'.

As always, many thanks for your thoughts,

Tony

[vidyut]

If You go to Presentation Tab, and Remove 'Supress Zero Values' setting, that should show you the data in the chart.

[#3]

Yes, that shows me the data, but i still get grouped results - ie I do not see each individual row from the original import table.

Tony

[#4]

The table box is essentially a group of list boxes put together. List boxes are constrained to the unique values in a given field.

The only way I know to get around it is to include a field in the combination that contains unique values for each record. ie: has no duplicates.

[Anonymous]

That means that if there are duplicate rows, the only way to separate them is to add a uniques field, for example RowNo() as ID.
(On the other hand - what's the reason to have duplicates?)

[#6]

Thanks for the replies guys, they all make sense and to be honest the only reason the duplicates are there is because I hadn't imported the ID field.

I was just surprised to find there was no way of viewing the imported data 'as is'.

cheers,

Tony

[#7]

It's especially disconcerting because aggregating functions like SUM() do not ignore the duplicate. See attached. It only shows AMT numbers which add up to 17; but since the record with ID "1" and AMT "5" is duplicated (i.e. same record appears twice), then it adds "5" twice, showing 22, not 17.

[jaimeaguilar]

Hi,

the thing is that if you use a Straight table then you need to include an aggregation function or any other expression. For example if your expression is Sum(Sales), then in order to get unique (or ungrouped) rows you need to include all the dimensions that get to a unique combination. Another approach to get unique rows is the rowno() solution

In the case of table box, this object is more to visualize the rows you have in your(s) table(s). The problem with this object is that you can't include any calculated dimension nor expressions, it's just like fetching a query, but it can be useful for debugging and test data associations

regards