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
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