5 Replies Latest reply: Nov 30, 2012 7:54 AM by Gysbert Wassenaar

# Min date per attribute & Total Sum in graph

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.

• ###### Re: Min date per attribute & Total Sum in graph

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

See attached qvw

• ###### Re: Min date per attribute & Total Sum in graph

Thanks for answering Gysbert i will try that now.

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

• ###### Re: Min date per attribute & Total Sum in graph

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

• ###### Re: Min date per attribute & Total Sum in graph

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))

• ###### Re: Min date per attribute & Total Sum in graph

Any help around this problem???