Basic Statistics with DataFlux

[margautz]

Hello,

I am new in the community and I am new using DataFlux.

I am wondering if it possible to create a DataJob with basics statistics on row and not on column.

I try to explain better my idea with an example:

I have three columns: family, products, price

family	product	price
AAA	x	1000
AAA	y	1500
BBB	z	100
AAA	w	1000
BBB	d	2000
CCC	f	500
CCC	e

and I would like to have Basic Statistics like

family	max	min	avg	null_value
AAA	1500	1000	1166	0
BBB	2000	100	1050	0
CCC	500	500	500	1

beacuse if I do a simple "Basic Statistics" Node on 'price' column, I will obtain

max	2000
min	500
avg	1016
null	1

Thank you for your time and help!

Margherita

[LinusH · Accepted solution]

Don't know about the possibilities in data flux. What do you want to do with this report?
If you have the possibility to use SAS on your data, this is a simple PROC MEANS (or Summary Statistics task from Enterprise Guide/Addin 4 MS Office).

[margautz]

Thank you Linus for your replay!

That is the answer that I was expecting 🙂 It was a report that one colleague ask to me, but I would like to be sure.

Thank you again