Data ExplorationCross-domain transaction

Combine two parameters from different domains

Data from two domains meets on a shared linking key, a lecturer, a student, or a study programme, and is then counted by faculty, study programme, or year.

Parameter AHuman Resources · Doctorate
Parameter BScholarly Publication · First author
GroupingBy faculty
ResultTable, chart, donut

Highest qualification = Doctorate ∩ Collaboration = First author

Change grouping Another transaction

No	Faculty	A · lecturers	B · lecturers	A ∩ B · lecturers	A ∩ B / A
01	FE	57	46	20	35.1%
02	FH	30	20	10	33.3%
03	FT	102	75	42	41.2%
04	FK	73	58	18	24.7%
05	FP	112	74	48	42.9%
06	FKIP	100	69	34	34%
07	FISIP	31	41	13	41.9%
08	FMIPA	84	66	35	41.7%
09	Fasilkom	25	43	15	60%
10	FKM	15	39	12	80%

No	Faculty	A · lecturers	B · lecturers	A ∩ B · lecturers	A ∩ B / A
01	FE	57	46	20	35.1%
02	FH	30	20	10	33.3%
03	FT	102	75	42	41.2%
04	FK	73	58	18	24.7%
05	FP	112	74	48	42.9%
06	FKIP	100	69	34	34%
07	FISIP	31	41	13	41.9%
08	FMIPA	84	66	35	41.7%
09	Fasilkom	25	43	15	60%
10	FKM	15	39	12	80%

Combine two parameters from different domains

Doctorate with collaboration First author, by faculty

Doctorate with collaboration First author, by faculty