Recreate this output from the two inputs within EazyBI

[Marcel]

I am looking to recreate this output from the two inputs within EazyBI. Can anyone help or point me in the right direction?

[roberts.cacus]

Hi @Marcel,

Welcome to the eazyBI community ! We had an internal support conversation, and I will share my suggestions with the community.

Such a report, from two data sources is possible. For convenience, I recommend splitting the Product and Version in two separate columns. I recommend the following file structure for file A:

For file B, I recommend having multiple rows for each customer, and again, for each customer specifiying the product and version columns:

First add the file A as a data source and map its data as the following example:

Import its data. Next, add file B, specify the same data cube name, and the same dimensions and levels for product and version columns:

Add a row count measure just to allow the data mapping to import data. Please review our documentation pages regarding data mapping and file import.

The report then could look similar to the one below:

The measure “Overdue” is a calculated one, and the formula is as follows:

DateDiffDays(
  Now(),
  [Measures].[Version end date]
)

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures.

Let me know if you have any questions or suggestions.
Best,