Forum Discussion

Ecerv255's avatar
Ecerv255
Regular Visitor
6 years ago
Solved

Statistics Table

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_PRESSUREINSTANT_SI_PRESSURETREATMENT_TEMPERATUREFRAC_GRADIENT
38.231.747.332
39.93247.733.5
40.331.447.831.4
40.831.247.932.2
4132.54832
41.232.548.132.5
41.432.548.234.5
42.131.848.633.3

 

What I want:

 

 MinMax AvgMedian
FORM_BREAK_PRESSURE    
INSTANT_SI_PRESSURE    
TREATMENT_TEMPERATURE    
FRAC_GRADIENT    

 

Thanks for your help!

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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 🙂