Evaluation Measurements for a bar chart

[#1]

Evaluation Measurements for a bar chart

I have a list of measurements from various sensors to be displayed in a barchart. At the X achse I like to arrange the Sensor names. At the y achse I like to display the average value of the 10 measurements for each sensor.

Mears.  Sens1     Sens2     Sens3

1          1200      3400        4500

2          1200       3400       4500

3          1200       3400       4500

4           1200      3400       4500

5          1200        3400      4500

6          1200      _3400      4500

7          1200        3400       4500

8          1200       3400       4500

9           1200        3400     4500

10         1200           3400   4500

I defind Sens1-3 for the dimension. But I can't find the rigt expression for the formular. The Amount of sensors may vary. What is the correct setting for the formular?

Thanks an best regards

[Anonymous]

Hi Ludger

i am trying to understand your question but failing would u kindly ellaborate further probably with an example of expected results

[Anonymous]

Hi,

if you insert a coloumn with the number of measurements, you can use the crosstable syntax.

In this way you can create your bar chart, where the number of items in the dimension is dynamic.

Find some attachements.

KR,

Elena