Show all values

[#1]

Hi,

I have a excel sheet with the following data.

CID Date Fact

1 22/06/2010 1

1 22/06/2010 1

If I create Table dashboard its showing only 1 record like this (elimanating the duplicate records).

CID Date Fact

1 22/06/2010 1

If I want to get 2 records in the table dashboard where is the option to select show duplicate values.

Thanks,

[jonathandienst]

Hi

Add RowNo() to the load to disambiguate the two rows like this:

LOAD
 CID,
 Date,
 Fact,
 RowNo() AS RowID
FROM DataSource;

Now include RowID in your table (you can hide that column)

Jonathan

[#3]

Thanks, but in table box dashboard we don't have hiding option.

Any best suggestion FYI..I am using 8.2 version.

Thanks,

[#4]

Hi there,

you can set the column to minimum size. You can also rename it with an space and make the font transparent or white.

Regards

[jonathandienst]

You could also use a straight table chart. Use all 4 fields as dimensions and an expression =1 as the expression. Then hide the RowID and expression columns.

Jonathan

[#6]

Actually I am using 8.2 version, so in straight table we don't have hiding option.

Thanks,

[pover]

Would it be reasonable to make the column as narrow as possible and change the text color to white so that you see any value?

I don't remember that hiding a column as somehting new between versions. To hide a column in a table you have to go to the Presentation tab below the list of columns. The hide option is not in the expressions tab like it is for other types of graphs.

Regards.

[#8]

I feel that we need to think in some technical way.

Thanks,