This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tableau [2021/05/18 05:24] windsor_ai |
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: | To get data from Windsor.ai connectors directly: | ||
- | ====== Connectors | + | ==== Connectors ==== |
- | - On your [[http:// | + | - On your [[http:// |
- Select the fields you would like to have streamed into Tableau | - Select the fields you would like to have streamed into Tableau | ||
- Copy the URL link shown in the instructions | - Copy the URL link shown in the instructions | ||
Line 15: | Line 15: | ||
- | ====== Windsor.ai attribution table ====== | + | ==== Windsor.ai attribution table ==== |
To get modelled or transformed data from [[http:// | To get modelled or transformed data from [[http:// | ||
- | * Head to the slice you would like to export into Tableau | + | * Head to the slice you would like to export into Tableau |
- | {{ : | + | |
- | * 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 |
- | {{ : | + | |
* Open Tableau Desktop, go to | * Open Tableau Desktop, go to | ||
Line 33: | Line 31: | ||
- | ====== Custom SQL lab queries | + | ==== 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:// | + | 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:// |
* Write your SQL query | * Write your SQL query | ||
Line 41: | Line 39: | ||
* Give the query a name and click **SAVE & EXPLORE** \\ {{ : | * Give the query a name and click **SAVE & EXPLORE** \\ {{ : | ||
* From here you can follow the same steps as in the section above (Windsor.ai attribution table) | * 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 \\ {{ : | ||
+ | * And format the number using this formula \\ < | ||
+ | |||
+ | |||
+ | === Automatically refreshing data === | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | To keep the data refreshed once you publish your report online simply head to **Extract Refreshes** | ||
+ |