Skip to main content
1-Visitor
Dec 7, 2012 9:30 AM UTC
Question

How to calculate the number of documents having a specific attribute value in a Report?

Hi,

I am working on Reports functionality of Windchill10.1

I need to retrive the total number of documents which have the same value for a given attribute in every attribute.

For example: There is an attribute(IBA) called Color in every document.

Now...we need to retrieve the % of the documents having the color blue.

Assume there are 10 documents out of which 4 have the color blue.

Now.. I am able to retrive the documents having the value for color as blue.

But I am not able to calculate the % of these documents.

I tried some wark-arounds like trying to count the number of documents,etc..but I am not getting the desired result.

If anyone could help, It would be of great help.

Thanks and regards,

Shweta Joshi

6 replies

1-Visitor
Dec 7, 2012 12:24 PM UTC

Hi Guys..

Any help will be highly appreciated...

I need to find the solution as soon as I can..

Thanks and regards,

Shweta Joshi

Translate
1-Visitor
Dec 7, 2012 1:55 PM UTC

Could Advance Search can solve your purpose?

Translate
1-Visitor
Dec 9, 2012 3:46 PM UTC

No...I am trying to achieve this through Query builder..

Translate
22-Sapphire I
Dec 10, 2012 4:20 PM UTC

Set up your query builder report:

- Set the criteria for the attribute on the criteria tab

- On the Select tab select the document object id, then apply the Count function to it

Translate
1-Visitor
Dec 11, 2012 11:40 AM UTC

Hi..

I already did that...I was looking to calculate the % .

Anyway thanks for your help guys.. I found a work-around though..

You can find the % by using the Add a Chart option.

Following is the screenshot of the end result:Percentage.bmp

Translate
1-Visitor
Jan 19, 2016 4:24 AM UTC

I am not very sure about the chart. For some reason it doesn't select all the values if the report is too large.

I like doing it the old way, i.e. export to excel and a insert a pivot table

Thanks

Pardeep

Translate