Actions

Reporting - Advanced Options

From VersaVision Support

OVERVIEW


Reporting is where the user can generate reports based on the data collected by the VersaVision software. There are multiple components inside Reporting, this page is focused on the Advanced Options.

When setting up a Cell or Series, there is an Advanced Option setting. Both types have the same settings.

This page will concentrate on providing details on each section/component of the Advanced Settings.

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series

START DATE


Click on the down arrow in the Start Date field.

  • Report-Cell-Prop-60.png


Select the Offset option.

  • Report-Cell-Prop-61.png


Three additional fields will load - What, Units and Offset. Click on the down arrow in the What field.

  • Report-Cell-Prop-62.png


There are 2 options for this field - Start Date & End Date. Select the best option for the report needs.

Start Date - selecting this option will allow the user to set an offset from the Start Date parameter.
End Date - selecting this option will allow the user to set an offset from the End Date parameter.
  • Report-Cell-Prop-63.png


Next the offset unit/time will need to be selected. Click on the down arrow in the Units field.

  • Report-Cell-Prop-64.png


There are 3 options available - Days, Months & Years. Select the best option for the report needs.

Days - allows the user to enter a number of days to offset the Start or End Date.
Months - allows the user to enter a number of months to offset the Start or End Date.
Years - allows the user to enter a number years to offset the Start or End Date.
  • Report-Cell-Prop-65.png


Next the Offset amount will need to be entered. Click on the Up or Down arrows in the Offset field to increase or decrease the number.

  • Report-Cell-Prop-66.png


Entering a Negative number will cause the offset to go back X days from the Start or End Date.

  • Report-Cell-Prop-67.png


Entering a Positive number will cause the offset to go forward X days from the Start or End Date.

  • Report-Cell-Prop-68.png

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series

END DATE


Click on the down arrow in the End Date field.

  • Report-Cell-Prop-70.png


Select the Offset option.

  • Report-Cell-Prop-71.png


Three additional fields will load - What, Units and Offset. Click on the down arrow in the What field.

  • Report-Cell-Prop-72.png


There are 2 options for this field - Start Date & End Date. Select the best option for the report needs.

Start Date - selecting this option will allow the user to set an offset from the Start Date parameter.
End Date - selecting this option will allow the user to set an offset from the End Date parameter.
  • Report-Cell-Prop-73.png


Next the offset unit/time will need to be selected. Click on the down arrow in the Units field.

  • Report-Cell-Prop-74.png


There are 3 options available - Days, Months & Years. Select the best option for the report needs.

Days - allows the user to enter a number of days to offset the Start or End Date.
Months - allows the user to enter a number of months to offset the Start or End Date.
Years - allows the user to enter a number years to offset the Start or End Date.
  • Report-Cell-Prop-75.png


Next the Offset amount will need to be entered. Click on the Up or Down arrows in the Offset field to increase or decrease the number.

  • Report-Cell-Prop-76.png


Entering a Negative number will cause the offset to go back X days from the Start or End Date.

  • Report-Cell-Prop-77.png


Entering a Positive number will cause the offset to go forward X days from the Start or End Date.

  • Report-Cell-Prop-78.png

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series

DATA FILTER


Click on the down arrow in the Data Filter field. Inherit will be selected by default.

  • Report-Cell-Prop-80.png


There will be 3 options available - Inherit, Append & Override. Select the best option for the report cell needs.

Inherit - selecting this option will allow the report cell to use the Data Filter parameters already setup.
Append - selecting this option allows the report cell to add Data to the Data Filter parameter already setup.
Override - selecting this option allows the user to specify what data is to be used in the report cell.
  • Report-Cell-Prop-81.png


When Append is selected, an additional Tag Filter field will be shown. Select this field and type in the tag that should be used.
The Tag Advanced mode allows the user to type in tags and use the AND & OR commands between them.

AND - use this separator to indicate that data is considered when an event has all the tags entered.
OR - use this separator to indicate that either of the tag(s) entered can be considered in the filter.
  • Report-Cell-Prop-82.png


Example of a filter using the AND separator is in the image below.
Using this setup our report cell will only show data for events that have both the "location 22" and "team lead" tags.
Any event that does not contain both of these tags will be omitted.

  • Report-Cell-Prop-83.png


Example of a filter using the OR separator is in the image below.
Using this setup means our report cell will show data for any events that are tagged with "team lead" and "materials".
Any events NOT tagged with "maintenance", "team lead" and "materials will be omitted.

  • Report-Cell-Prop-84.png


When Override is selected the user will be able to access the Tag Filter Builder. Click on the Edit button to access the Builder.

  • Report-Cell-Prop-85.png
Click Here for details on using the Tag Filter Builder.


All of the filters selected in the Tag Filter Builder will show under the Tag Filter heading.

  • Report-Cell-Prop-86.png


The Advanced mode can be enabled by turning the toggle on.

  • Report-Cell-Prop-87.png


The Tag Filter Advanced mode allows the user to type in monitoring point & location tags. This filter can be refined using the AND & OR commands between them. Click in the field to setup the filter.

AND - use this separator to indicate that data is considered when an event has all the tags entered.
OR - use this separator to indicate that either of the tag(s) entered can be considered in the filter.
  • Report-Cell-Prop-88.png


Example of a filter using the AND separator is in the image below.
Using this setup our report will only show data for events that have both the "station 22" and "team lead" tags.
Any event that does not contain both of these tags will be omitted.

  • Report-Cell-Prop-89.png


Example of a filter using the OR separator is in the image below.
Using this setup means our report will show data for any events that are tagged with "team lead" and "materials".
Any events NOT tagged with "team lead" and "materials will be omitted.

  • Report-Cell-Prop-90.png

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series

SCHEDULE


The Schedule field allows the user to override the Schedule setup in the Schedule parameter. Click on the down arrow in the Schedule field.

  • Report-Cell-Prop-100.png


There are 2 options available - Inherit and Override. Select the best option for the report cell.

Inherit - selecting this option will allow the report cell to use the Schedule Filter parameters already setup.
Override - selecting this option allows the user to specify what Schedule is to be used in the report cell.
  • Report-Cell-Prop-101.png


When Override is selected the user will have a toggle switch available. Turn the toggle on to enable the Override

  • Report-Cell-Prop-102.png


A Schedule field will show next to the toggle switch. Click on the down arrow in this field.

  • Report-Cell-Prop-103.png


This list will populate with all of the Schedules that have been setup on the system. Select the appropriate Schedule for the report cell.

  • Report-Cell-Prop-104.png

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series

TIME FILTER


The Time Filter field allows the user to override the Shift(s) setup in the Time Filter parameter. Click on the down arrow in the Time Filter field.

  • Report-Cell-Prop-110.png


There are 2 options available - Inherit and Override. Select the best option for the report cell.

Inherit - selecting this option will allow the report cell to use the Schedule Filter parameters already setup.
Override - selecting this option allows the user to specify what Schedule is to be used in the report cell.
  • Report-Cell-Prop-111.png


When Override is selected the user will have a Shift Filter option. Click on the Edit button to access the Shift Filter Builder.

  • Report-Cell-Prop-112.png
Click Here for details on using the Shift Filter Builder.


The Shift Filters that were selected in the Shift Filter Builder will show under the Shift Filter heading.

  • Report-Cell-Prop-113.png


The Advanced mode can be enabled by clicking on the Advance toggle switch.

  • Report-Cell-Prop-114.png


The Shift Filter Advanced mode allows the user to type in shift tags and use the AND & OR commands between them. Click in the field to setup the filter.

AND - use this separator to indicate that data is considered when an event has all the shift tags entered.
OR - use this separator to indicate that either of the shift tag(s) entered can be considered in the filter.
  • Report-Cell-Prop-115.png


Example of a filter using the AND separator is in the image below.
Using this setup our report will only show data for events that have both the "first" and "second" shift tags.
Any event that only happened on first shift will be omitted and vice versa. The event must have occurred on both 1st & 2nd Shifts.

  • Report-Cell-Prop-116.png


Example of a filter using the OR separator is in the image below.
Using this setup means our report will show data for any events that are tagged with "second" or "third" shift tags.
Any events NOT tagged with "first" will be omitted.

  • Report-Cell-Prop-117.png

Start Date       End Date       Data Filter       Schedule       Time      

Return to Reporting Page Return to Mixed Data Series Return to Pie Chart Data Series
VC Footer.png
Follow Us On LinkedIn View our Blog
Retrieved from "https://vv-support.versacall.com/index.php?title=Reporting_-_Advanced_Options&oldid=3889"