Loading

The Row Order of Exported Crosstab Is Different from the Worksheet When Field Is Added in [Mark] Card

Udgivelsesdato: Apr 13, 2024
Beskrivelse

When adding a table calculation field in the view and then add another field in Mark Card, Then the downloaded CSV file looks different from Tableau View.
User-added image

For example, when using the RANK field, The exported crosstab are as follows:
When no field is added in the [Color] mark, it works well.
User-added image

When a field is added in [Color], the row order are different.
User-added image

Løsning
1. Instead of exporting CSV, please use [Copy] > [Crosstab]. 
User-added image

2. Please manually set the order of the rows using the [Sort] function.
User-added image

Please check the attached workbook, [Workaround] worksheet.
Yderligere ressourcer
If a table calculation field is added in the following cards, the exported CSV row order will be different from the view in Tableau.
User-added image
 
Vidensartikelnummer

001474307

Vedhæftede filer

Mark_Card.twbx

1233 KB

 
Indlæser
Salesforce Help | Article