I have a workspace with several datasets; dataset 1 and dataset 2. each dataset has a dollar value fact that I’m plotting. I’d like to provide an insight that splits the sum of dataset 1 value and dataset 2 value. Is this possible in GoodData or does my model need to calculate the totals outside of GoodData and inport into another dataset?
Best answer by Moises Morales
View original
It is certainly possible to sum two facts from different datasets, but please note that you will need to make sure your Logical Data Model (LDM) structure allows you to do so, i.e., both datasets must be connected/referenced correctly. Please see Connection Points in Logical Data Models. Once you do this, you will need to create a slightly complex metric that may look as follows:
SELECT SUM (Fact1 + Fact2)You could then reference this metric in a compound metric, for example:
SELECT FactsSum / Revenue_Last_Year
Hi Rick.
Please share you data model and description of what you would like to calculate. Then it will be possible to provide a better advice.
Best,
Martin
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.