Solved

Creating a New Data Field

  • 12 March 2021
  • 2 replies
  • 68 views

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?

icon

Best answer by Moises Morales 12 March 2021, 21:30

View original

2 replies

Userlevel 2

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

Userlevel 3

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

Reply