<...>
Yes, Tableau is a good product, but it still has some issues that have been requested by its users some time ago, but that still have not seen the light. Amongst them are two of the issues you are addressing:
- Tableau Public does not allow export to flat files or excel files (or even to copy the data to the clipboard) unless the Dashboard is “Open”. I can open the Dashboard to this feature, but the drawback is that then not only is the data exportable (which I would really like), but so is the Dashboard itself. So basically, as absurd as it sounds, in order to allow a minimal export I need to allow for the whole source code Dashboard to be exportable too (which I’m not too keen on really).
-> If you need a specific dataset, I can share that for you on a google spreadsheet as @vphasitha01 mentioned.
- Tableau is not great at sorting rolled-up numbers. Basically, for some internal design decision, if there is a dimension (the username) and then a rolled-up number (aggregate of merits), the latter is only ordered as a subset of the dimension entry. That is, it orders by name, and then by merits within the name (if there were more than one data entry). So when trying to order by Merits, it does not have the desired effect.
This has also been requested as a change to Tableau, but it’s still a no go.
I could put Merits as the first column, and then it would sort by the value rather than by the name, but I thought name would be a better choice.
- Tableau Public (the free hosted open to public version I’m using) has a default timeout somewhere in the line of 4 minutes, so an inactivity period of around 4 minutes requires you to reapply your selections. Sometimes, sorting or such can cause that kind of internal error which should be resolved by refreshing the page again (and reapplying the filters). The default timeout cannot be altered by me.
Let me know if you need a specific data selection.
I'll update de Dashboard today with the most recent update.
P.D. The Merit Network on the other hand allows you to export all the contained database (File->Download (csv format)) , so perhaps that could help, but the data is rather raw there (i.e. at TX level) .Edit: On the Merit Network , you can also copy data from the Tabs via the clipboard (i.e. go to the Summary Received tab, filter there, sort and export).