Differences

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

--- currency_conversions [2021/12/28 17:06]
windsor_ai created
+++ currency_conversions [2021/12/28 19:30] (current)
windsor_ai
@@ Line 21: / Line 21: @@
-==== 3.
+==== 3. Setup the new conversions
+Go to https://charts.windsor.ai/w/sqllab/
+Enter your queries for the currency conversion. In this example we convert the costs from CLP to USD with this query:
+<code>
+SELECT costs.date, SUM(costs.totalcost/currency_usdclp.usdclp::DECIMAL)
+FROM costs
+JOIN currency_usdclp
+ON TO_CHAR(costs.date, 'YYYY-MM-DD') = currency_usdclp.date
+GROUP BY costs.date
+</code>
+{{::2021-12-28_21-29.png?600|}}
+You can then select to visualise the results and save them in your dashboard.

Knowledge Base