Statistics Table

[Ecerv255]

Hello,

I'm attempting to make a stastictics table visualization that aggregates 4 Fields (rows) as columns for each aggregation (1 column for averages, min, max, median.

Data:

FORM_BREAK_PRESSURE	INSTANT_SI_PRESSURE	TREATMENT_TEMPERATURE	FRAC_GRADIENT
38.2	31.7	47.3	32
39.9	32	47.7	33.5
40.3	31.4	47.8	31.4
40.8	31.2	47.9	32.2
41	32.5	48	32
41.2	32.5	48.1	32.5
41.4	32.5	48.2	34.5
42.1	31.8	48.6	33.3

What I want:

	Min	Max	Avg	Median
FORM_BREAK_PRESSURE
INSTANT_SI_PRESSURE
TREATMENT_TEMPERATURE
FRAC_GRADIENT

Thanks for your help!

[SteveCampbell · Accepted solution]

You could unpivot your data. Open power query,  highlight all columns, right click and unpivot. This will give you attribute and value. You can add Attribute to the rows of a table, then drag in value four times and change the summarization to the correct measure.

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on  

[Anonymous]

Hi,

Thank you for this help.

Is it possible to copy the data before unpivot it in order to obtain a file of the form?

FORM / INSTANT / TREATMENT / TEMPERATURE / FRAC / ATTRIBUTE / VALUES

38.2 / 31.7 / 47.3 / 32 / FORM / 38.2

39.9 / 32 / 47.7 / 33.5 / INSTANT / 31.7

etc

Thanks 🙂