Hi All,
Each time a user clicks on a tab/view on server, I need some measure to calculate the count of views. Can we join the "_http_requests" table of Tableau Postgresql database with the historical tables? If anybody has given this a try, please share your steps.
Thank you.
Best,
Namrata
The best way of doing this is by using the' historical_events' table joined to the 'historical_event_types' and 'hist_workbooks' (see below). You can then filter on event types of "Access View" and count on the ID. Using these tables (including the other hist tables) is the best way to monitor usage within Tableau.
FROM "public"."historical_events" "historical_events"
INNER JOIN "public"."historical_event_types" "historical_event_types" ON ("historical_events"."historical_event_type_id" = "historical_event_types"."type_id")
LEFT JOIN "public"."hist_workbooks" "hist_workbooks" ON ("historical_events"."hist_workbook_id" = "hist_workbooks"."id")
