Export of Table widget (.xlsx format) with 2 row dimensions resulting in all combination of row values | XM Community
Skip to main content
Solved

Export of Table widget (.xlsx format) with 2 row dimensions resulting in all combination of row values

  • September 17, 2024
  • 3 replies
  • 57 views
N
Level 4 ●●●●
Forum|alt.badge.img+4

Dear All,

I have a table widget that has 2 dimensions in ROW and 3 calculated metrics in COLUMN.

When I export the data in xlsx format it creates combinations of all values of the 2 row dimensions. for example, if the table looks like this:

When I export the data, it shows:

 

It creates all combination of  Region with Customer and displays the value. 

The Display setting also has below settings disabled:

 

What am I doing wrong ?

 

Regards,

Neha Tank

 

Best answer by Nam Nguyen

@Neha Tank You did nothing wrong, it’s just the way table work. Multiple non-metric column/row will automatically get broken-out.
Can a Customer got 2 or more Region, vice versa? If this is about record, then use record table.
Hope this helps

3 replies

N
Level 4 ●●●●
Forum|alt.badge.img+4
  • Neha Tank
  • Author
  • Level 4 ●●●●
  • 103 replies
  • September 30, 2024

Hello All,

Anyone faced this problem before ?

 

Regards,

Neha Tank

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • Nam Nguyen
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • Answer
  • September 30, 2024

@Neha Tank You did nothing wrong, it’s just the way table work. Multiple non-metric column/row will automatically get broken-out.
Can a Customer got 2 or more Region, vice versa? If this is about record, then use record table.
Hope this helps

Nam Nguyen - XM Technology Consultant | DXCON Vietnam
N
Level 4 ●●●●
Forum|alt.badge.img+4
  • Neha Tank
  • Author
  • Level 4 ●●●●
  • 103 replies
  • October 3, 2024

I shall try the record table and let you know how it went.

Thanks for the reply.


Terms & ConditionsAccessibility statement