To GoodData homepage

Replies posted by Allan Talver

1 Reply

A
Allan TalverNew Participant
asked in Metrics and MAQL

Linking two unrelated datasets in MAQL

Hi Iva,Thank you for your response! Yes, the datasets were not connected at all. So I actually implemented a few data model changes in my development environment and I think I have some good progress. I created a new dataset “Currencies” and created reference column into both “Exchange rates” and “Contracts” dataset. Now I was able to create a metric that finds the respective exchange rate for the contract currency and is able to convert the contract currency to our company base currency. The metric for this is:SELECTSUM(Contract Annual Amount) /( SELECT SUM(Rate) BY Date, Currency Code ALL OTHER WHERE Date = THIS)However, I am now struggling with my second step of the conversion. How can I create a dropdown in the dashboard which would allow me to choose the currency for the second conversion (from company base currency to the selected currency)? If I just add a currency filter in my dashboard, then it does not behave as a destination currency selector, but would instead act as a

3
U
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings