I have a tableau server extract which I think is not quite optimized for my use. For example,
The extract returns me 3 rows, however, for my use, it would be sufficient if even if it's 1 row. For example,
My question is, is there a way to create an extract and modify it to my use like a group by clause in a sql statement?
If ID is not needed, before the extract is taken, right click on ID (in the data box) and select Hide. Then, in the Extract Data dialog box, check the Aggregate data for visible dimensions box--this will only include the fields that are showing in the extract.
Hope this helps!