Full Outer Join using chart expression.

[#1]

Hi,

I use two charts:

Chart 1: GL Summary Report

MonthEnd	GLDatasetID	Count(GLDatasetID)
Jan-16	259733	17
Jan-16	334197	9
Jan-16	243901	56
Jan-16	527735	12

Chart 2: DW Summary Report

MonthEnd	DWDatasetID	Count(DWDatasetID)
Jan-2016	259733	17
Jan-2016	492315	31
Jan-2016	243901	50
Jan-2016	527735	4

From these two charts I need another chart which has a result set like this:

Chasrt 3: Final Required result (Chart 1's expression minus Chart 2's expression) on status if Dataset ID matched or not

MonthEnd	Dataset ID	Net Result (Count(GLDatasetID) - Count(DWDatasetID))	Status
Jan-2016	259733	0	Matched
Jan-2016	334197	9	Not Matched
Jan-2016	492315	-31	Not Matched
Jan-2016	243901	6	Not Matched
Jan-2016	527735	8	Not Matched

Is it possible to achieve this result in in Chart expression? I know we can use the script and achieve this goal, but I would like to know if a solution exists using chart expression directly.

Thanks!

[Chanty4u]

//=count( DISTINCT if(count(glddatasetid)-count(DWDatasetid),if(Status = 'Matched','Notmatched', DatasetID)))

[#3]

Suri - Thanks for your reply.

But Status is a derived column. Status is based on if the result is 0 or not.

Another point is what should be the dimension values in order to calculate count(GLDatasetID)-count(DWDatsetID)