2 Replies Latest reply on Jul 31, 2013 5:36 PM by Ramanujam Nathamuni

    Tableau Dashboard/Worksheet performance report by projects

    Ramanujam Nathamuni

      Hello All,

       

      I am in needed of getting the tableau dashboard/worksheet  performance report based on the project. As of now I can see the server activity/user activity but needs to combine these based on the projects. Please give me some insights  an join keys or other ideas of using build in PL/SQL used by tableau to keep track of matrix.

       

      Thanks,

      Ram

        • 1. Re: Tableau Dashboard/Worksheet performance report by projects
          Russell Christopher

          Hi Ram -

           

          Can you explain how this "joined" by-project performance data might look? In other words, how would it be organized? Are you interested in simply grouping per-workbook information together by project? Something more ambitious?

           

          I'm not sure there's a way to DO this one way or the other, but I'm curious.

          • 2. Re: Re: Tableau Dashboard/Worksheet performance report by projects
            Ramanujam Nathamuni

            Hi  Russell,

             

            I was able to play around bring the initial version and filter by projects on tableau servers. I think, I am good now but will fine tune after getting feedback from project leaders. Please have a look and give me feedback or improvement. Using below SQL I am able to use projects as filter for performance report. Please find attached sample image.


            Below will not work if you don't  follow additional steps to give access to PL/SQL.

             

            Monitor User and Requests –  custom SQL

             

            SELECT "_users"."id" AS "users_id",

              "_users"."name" AS "name",

              "_users"."login_at" AS "login_at",

              "_users"."friendly_name" AS "friendly_name",

              "_users"."licensing_role_id" AS "licensing_role_id",

              "_users"."licensing_role_name" AS "licensing_role_name",

              "_users"."domain_id" AS "domain_id",

              "_users"."system_user_id" AS "system_user_id",

              "_users"."domain_name" AS "domain_name",

              "_users"."domain_short_name" AS "domain_short_name",

              "_users"."site_id" AS "_users_site_id",

              "_http_requests"."controller" AS "controller",

              "_http_requests"."action" AS "action",

              "_http_requests"."http_referer" AS "http_referer",

              "_http_requests"."http_user_agent" AS "http_user_agent",

              "_http_requests"."http_request_uri" AS "http_request_uri",

              "_http_requests"."remote_ip" AS "remote_ip",

              "_http_requests"."created_at" AS "created_at",

              "_http_requests"."session_id" AS "session_id",

              "_http_requests"."completed_at" AS "completed_at",

              "_http_requests"."port" AS "port",

              "_http_requests"."user_id" AS "user_id",

              "_http_requests"."worker" AS "worker",

              "_http_requests"."vizql_session" AS "vizql_session",

              "_http_requests"."user_ip" AS "user_ip",

              "_http_requests"."currentsheet" AS "currentsheet",

              "_http_requests"."site_id" AS "_http_requests_site_id",

              "_sessions"."session_id" AS "_sessions_session_id",

              "_sessions"."updated_at" AS "updated_at",

              "_sessions"."user_id" AS "_sessions_user_id",

              "_sessions"."user_name" AS "user_name",

              "_sessions"."system_user_id" AS "_sessions_system_user_id",

              "_sessions"."site_id" AS "site_id",

              "_workbooks"."id" AS "_workbooks_id",

              "_workbooks"."name" AS "_workbooks_name",

              "_workbooks"."workbook_url" AS "workbook_url",

              "_workbooks"."created_at" AS "_workbooks_created_at",

              "_workbooks"."updated_at" AS "_workbooks_updated_at",

              "_workbooks"."owner_id" AS "owner_id",

              "_workbooks"."project_id" AS "project_id",

              "_workbooks"."size" AS "size",

              "_workbooks"."view_count" AS "view_count",

              "_workbooks"."owner_name" AS "owner_name",

              "_workbooks"."project_name" AS "project_name",

              "_workbooks"."system_user_id" AS "_workbooks_system_user_id",

              "_workbooks"."site_id" AS "_workbooks_site_id"

            FROM "public"."_users" "_users"

              RIGHT JOIN "public"."_http_requests" "_http_requests" ON ("_users"."id" = "_http_requests"."user_id")

              LEFT JOIN "public"."_sessions" "_sessions" ON ("_http_requests"."session_id" = "_sessions"."session_id")

              INNER JOIN "public"."_workbooks" "_workbooks" ON ("_users"."name" = "_workbooks"."owner_name")

             

            Thanks,

            Ram