Min date per attribute & Total Sum in graph

[#1]

Hi all,

Question 1)

Is there and way to use Total Mode Sum as a dimention in a graph.

For example illustrate the sum of these specific values in comparison with all the other values, is it possible in a pie chart??

Question 2)

I have a table like this:

Test date	Sensor Status	Unit Serial
28/11/2007 16:47	Fail	1787
28/11/2007 16:53	Fail	1787
28/11/2007 16:54	Fail	1787
05/12/2007 14:39	Fail	1795
05/12/2007 14:42	Pass	1795

My desired table would look like this

Test date	Sensor Status	Unit Serial
28/11/2007 16:47	Fail	1787
05/12/2007 14:39	Fail	1795

So what i have to do is to select the first date per Unit serial.

Any suggestion ideas are welcome.Thank you in advance.

[Gysbert_Wassenaar]

Use an expression like min({<SensorStatus={'Fail'}>}Testdate)

See attached qvw

[#3]

Thanks for answering Gysbert i will try that now.

What about the frist question is there any solution to that???

[#4]

I want in 2 cases to use the total sum of expresions OutOfBoundValues and FirstTimePass to form pie charts comparion the selected percentage with the total.

In the case of OutOfBoundValues i want to create a pie chart to illustrate that the 48.2 percent out of 100 is out of bounds

In the second case i want to create a pie chart to illustrate that 147 values out of ???(total number of selected values) passed right at first time.

See attached file below

[#5]

Any help around this problem???

[Gysbert_Wassenaar]

The Out of Bounds pie chart:

expression 1: =ceil((count({<SensorValue={'>$(=High)','<$(=Low)'}>} SensorValue)/count({$} Total SensorValue) *100),0.01)

expression 2: =100 -  ceil((count({<SensorValue={'>$(=High)','<$(=Low)'}>} SensorValue)/count({$} Total SensorValue) *100),0.01)

The First Time Pass pie chart:

expression 1: count(aggr(min(TestDate),UnitSerial))

expression 2: count(UnitSerial) - count(aggr(min(TestDate),UnitSerial))