Differences

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

--- tableau [2021/05/18 05:25]
windsor_ai
+++ tableau [2021/07/08 02:12] (current)
windsor_ai [Custom SQL lab queries]
@@ Line 8: / Line 8: @@
-  - On your [[http://onboard.windsor.ai/|Windsor.ai configuration]] head to **2. Select Destination** and select tableau
+  - 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 18: / Line 18: @@
 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 35: / Line 33: @@
 ==== 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]
+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
@@ Line 41: / Line 39: @@
   * 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