Create chart from Workflow and Document items, group by creation date (without time)

[amatei]

Hello,

- I would like to create a chart from some Workflow and Document items

- We use Open Issues, Change Requests, Risk Issues, etc. Each item has a creation date and time

- I create a simple query filtering these items by  a text field named "Rubric" .

Please see the attached image.

Then I would like to  create a chart:

- on the x-axis of the chart I would like the item creation date (of course without time )

- on the y-axis is the count, i.e. the number of items created in that date, again of course without time

I tried the Distribution, Item Fields and Item Fields Trend  types of chart which accept a query, but I didn't succeed.

Please help, thank you.

[awalsh]

I'm not sure it's possible. See the Idea here:

https://community.ptc.com/t5/Integrity-Ideas/INTEGRITY-DISTRIBUTION-CHART-Add-Grouping-by-Date-or-Date-Period/idi-p/500506

[AnitaD]

Hello Amatei,

We're still using v 10.  No, I am sorry to say, cannot chart by date period (day, week, month, etc.).  I have created a request (cannot remember PTC's word for it) years ago; over the past year, I even faxed an appeal to Integrity executives to provide a solution for what, IMHO, is very high priority need.  No response. 

Integrity has some cool OOB functionality with regard to Workflows and Documents "reporting objects" ...  unfortunately, it doesn't include this BASIC charting capability.

I have developed a work around for charting item counts created during "last 7 days" by "day" that works.  If you want the solution, just reply to this post.

Isn't v 12 being released soon?  Maybe.... maybe...

[amatei]

Hi,

> If you want the solution, just reply to this post.

Sure, please explain the details.