hi Mohamed. does the standard report work for you? It goes against the http_request table and has the join relationships required. Also, there's quite a complicated windows calc to determine total elapsed time.
If not, also have a look at this post. I created a dashboard that shows overall elapsed time and takes much of the same logic that is in the default report. It just renders in a different method. And if you want to keep the data longer, then you can run an incremental extract.
thank you for reply
I don't have access to management dashboard on the Tableau server.
I have only access to the database workgroup to create personalized dashboards with more indicators on users activities . So I use the data model that attached to my first message. I need to know how calculate the load time with workgroup's tables (load time by user/view).
I hope that was clear.
did you have a look at the second link? Tableau vizql rendering
this has the connections and calcs already in there and you should be able to leverage this.
I will try it.