Differences

This shows you the differences between two versions of the page.

--- tableau [2021/04/16 00:57]
windsor_ai created
+++ tableau [2021/07/08 02:12] (current)
windsor_ai [Custom SQL lab queries]
@@ Line 5: / Line 5: @@
 To get data from Windsor.ai connectors directly:
-  - On your [[http://onboard.windsor.ai/|Windsor.ai configuration]] head to **2. Select Destination** and select tableau
+==== Connectors ====
+  - On your [[http://onboard.windsor.ai/|Windsor.ai configuration]] head to **2. Select Destination** and select Tableau
   - Select the fields you would like to have streamed into Tableau
   - Copy the URL link shown in the instructions
@@ Line 11: / Line 14: @@
 In the window you enter the URL https://tableau.windsor.ai
+==== Windsor.ai attribution table ====
 To get modelled or transformed data from [[http://charts.windsor.ai|Windsor.ai charts]]
-  * Head to the slice you would like to export into Tableau
+  * Head to the slice you would like to export into Tableau \\ {{ :charts-to-tableau-1.png?nolink&800 |}}
-{{ :charts-to-tableau-1.png?nolink&800 |}}
-  * Customise your slice and then click on the **JSON** button. Now your JSON link is in your clipboard
+  * Customise your slice and then click on the **JSON** button. Now your JSON link is in your clipboard \\ {{ :charts-to-tableau-2.png?nolink&800 |}}
-{{ :charts-to-tableau-2.png?nolink&800 |}}
   * Open Tableau Desktop, go to
@@ Line 27: / Line 30: @@
   * In the window which opens, paste the URL link from charts
+==== Custom SQL lab queries ====
+To get your custom SQL queries into Tableau you will need to convert your query to a dynamic data source. Start by writing your SQL query in [[https://charts.windsor.ai/w/sqllab|SQL lab]].
+  * Write your SQL query
+  * Click on **EXPLORE** \\ {{ :sqllab-to-tableau1.png?nolink&800 |}}
+  * Give the query a name and click **SAVE & EXPLORE** \\ {{ :sqllab-to-tableau2.png?nolink&800 |}}
+  * From here you can follow the same steps as in the section above (Windsor.ai attribution table)
+=== Formatting of dates from Windsor.ai charts ===
+When working with dates from Windsor.ai charts they are displayed in millis (Epoch format). So your dates will appear in a format like **1609977600000**
+  * To convert dates in Tableau right click on the date you want to format \\ {{ :tableau_dates_1.png?nolink&800 |}} \\
+  * And format the number using this formula \\ <code> dateadd('second',INT([event date]/1000),#1970-01-01#) </code> \\ {{ :tableau_dates_2.png?nolink&800 |}}
+=== Automatically refreshing data ===
+{{ :refresh_tableau.png?nolink&800 |}}
+To keep the data refreshed once you publish your report online simply head to **Extract Refreshes**  and set up the refresh.

Knowledge Base

User Tools

Site Tools

Differences

Page Tools