Do you mean "out of the 100 reports using extract "xyz" the 10 views (sheets) that have the most views are?"
Just want to be clear about the question.
There is the view in the Tableau Server db named "_views_stats" that may be of help. The column "nviews" is the number of times the view has been consumed by the users.
So I think by using the views in the server db you'd use the following views (Tableau Server naming convention is anything with an underscore is a view):
Try playing with those. It would help to know at least your answer for one situation ahead of time to check that the report is working correctly.
I don't know the exact answer but I hope this will point you in the right direction.
To answer your question, yes. I'm basically trying to identify the top 10 sheets with the most views for each extract. I'm looking at analyzing and possibly redesigning some of these sheets in order to optimize and therefore reduce the load on the server when they're being accessed heavily by multiple users. In my case, I'm trying to look at our largest Tableau extracts first, then work my way down.
I'll take a look at that thread, it looks like it gets me partway there but I think it just pulls all most actively used sheets overall without consideration of extract.
So far no luck. I found a couple of handy references to the Tableau 7 and Tableau 8 views but nothing seems to indicate a way to tie the number of times a view has been viewed with the data source that it's referencing. I can get a count of the number of times a view has been viewed and that's it.
It looks like Tableau just doesn't include data source ids when logging viewing events...
Just out of curiosity, how good are you with SQL? How long have you been developing, and how long have you been working in databases to figure out where info comes from, like how to join one table to another?
I've been doing data warehousing for about 9 years now so I'm decent at SQL and can do fairly complex logic and analysis of data.