Is there a way to create a report from the information that is populated into the calendar?

[Ryan Mulcahy]

I want to track day/time of failures on the calendar and then be able to create a report at the end of each month.  Is this possible? 

[Andrey Khaneev _StiltSoft_]

Hi Ryan,

What calendar do you use? Team Calendars or another?

[Ryan Mulcahy]

Hello Andrey,

We are not using any calendar currently.  Our goal is to use a calendar format to keep track of failures.  Then if possible be able to run a report at the end of each month using the data tracked on the calendar.  

[Andrey Khaneev _StiltSoft_]

It is possible, I think. Lets imagine you track failures data in the table format:

• Column with date/time
• Other columns with some data.

The table is placed within Pivot Table macro that aggregates data against months. You can count number of failures occurred each month, or sum of some data, for example.

Also can build a chart on the basis of the pivot table.  Those macros a part of Table Filter and Charts app.

There are many things can be done actually. How the report should look like?