question on displaying duplicate dimension values

[gerrycastellino]

I have a dimension [Ticket Number]  which has 2 recoreds of 'INC0786067' - these are associated with 2 values in the metric field of

351/350.

I have created a simple straight table with Dimension as [Ticket Number] and Metric as OpenTicket_Length.

I'm not seeing the duplicate dimension values as I would like to see - same with the metric.

[maxgro]

you see the distinct dimension

A solution could be: add a counter in the script (ie rowno()), add this new field in the chart as dimension and hide this field in presentation tab (this works for straight table)

[#3]

what have you done on the first table compare to the second one?  Is one a table box and the other a striaght table?

[#4]

does it ahve to be a straight table?  what about a pivot table?

[gerrycastellino]

I could do pivot table,  seems to be the same results though.

[#6]

ws?can you provide a qvw

if you have an expression as =openticketlength and the ticket as the dimension it should work

[MarcoWedel]

‌OpenTicket_Length seems to be field as well, so try a table box instead of a straight table or make it a dimension rather than an expression in the straight table (possibly without expression and unselected suppress null values option).

regards

Marco