View source for Mixed - Moving Average - Series

<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''OVERVIEW'''</u></span></div>
<BR>
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 Series - Moving Average component for a Mixed Type report cell.
<BR>
<BR>
A series is a way to define data to be used on a Bar, Line or Area of the report. The Moving Average type allows the user to take a Series total and Average it out over multiple days, weeks or months.
<BR>
<BR>
A good example of the use of a Moving Average would be to see the Average Downtime for the Week.
<BR>
<BR>
'''NOTE:''' In order to create or use a Moving Average Series, the user must setup the Data Series first. Using the example above, the Total Downtime Series would have to created first.
<BR>
<BR>
This page will concentrate on providing details on Adding, Editing, Duplicating, Deleting, Moving or Expanding a Data Series from a Mixed Report Cell.
<BR>
----
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''NAVIGATION'''</u></span></div>
<BR>
When a Report Cell has been selected on the layout and it is setup as a Mixed type, the Series field will be visible on the right side of the layout under the Cell heading
<BR>
All sections available under this heading are addressed in the information on this page.
<BR>
<gallery widths=600px heights=404px>
File:Mixed-Series-Main.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="ADD"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''ADD A NEW SERIES'''</u></span></div>
<BR>
Select a Cell in the Report Layout. Click on the Add a Series button under the Series heading.
<BR>
<gallery widths=600px heights=139px>
File:Mixed-Moving-Series-1.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
A pop-up menu will load above the Add a Series button - select Moving Average from the menu.
<BR>
<gallery widths=600px heights=214px>
File:Mixed-Moving-Series-2.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The Series Properties will load. Click in the Name field to enter a name for the series.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-3.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
By default, the Visible switch will be ON. This indicates that the Moving Average Series being created will show on the report. Select the best option for the report being created.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-4.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
By default, the Show Values option will be OFF. Turning the option ON will display the Moving Average Result on the Bar, Line or Area of the report.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-5.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the swatch in the Color field.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-6.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
A color picker interface will load on the screen. Pick a preset color or mix a custom color.
<BR>
The color selected will be the Bar, Line or Area color on the report.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-7.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the down arrow on the Series Type field. This is where the user will define how the Moving Average Result will appear on the report (Bar, Line or Area).
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-8.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
On the drop down list select an option.
::'''Bar''' - this will represent the result on the report as a bar.
::'''Line''' - this will represent the result on the report as a horizontal line.
::'''Area''' -  this will represent the result on the report as a wave.
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-9.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Y-axis arrow to see the available list.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-10.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The Y-axis is defined in the Appearance section. There are 2 Y-axes available - Right & Left.
<BR>
Select which Index (Axis) the Moving Average Series is to be associated with. By default the system will show Index 1 & Index 2 until they have been defined/named in the Appearance section.
::'''Example:''' User creates a Mixed Average Series for Total Downtime. The user would select Minutes as it would be an average number of minutes.
Select the appropriate Axis Name for the Series being created.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-11.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Decimal Places arrow to see the available list and change the setting. By default, 1 will be selected. 
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-12.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The list will show 0 to 5. If the Moving Average Result needs to show a specific number of decimal places on the graph, select a 1, 2, 3, 4 or 5. If the Moving Average Result should only show a whole number, select 0.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-13.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the down arrow in the Series field. Depending on the setup of the report, there may be multiple Series available to select from. Select the appropriate Series for the report being created
<BR>
Using the example of Average Downtime, the Total Downtime Series would be selected.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-14.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Using the example of Average Downtime, the Total Downtime Series would be selected.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-15.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Number of field. The field Name will switch depending on what Dimension is selected in Cell Properties. Enter the appropriate number for the report being created.
::The Dimension field has the following selections that may show in this field - Months, Weeks, Days, Location, Name, Reason, Tag Filters and Shift Tag Filters. The most common selection would be Months, Weeks or Days.
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-16.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Using the example of Average Downtime, the Dimension is set to Days. This example is based on a 7 day work week, so the Number of Days is 7.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-17.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="EDIT"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''EDIT A SERIES'''</u></span></div>
<BR>
Click on the Expand icon to open the Series Properties.
<BR>
<gallery widths=600px heights=220px>
File:Mixed-Moving-Series-20.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The Series Properties will show. Click in the Name field to change the name of the series.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-21.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Visible toggle to either show the Moving Average Result or not to show it.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-22.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Show Values toggle to either show the Moving Average Result on the report cell or not show it.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-23.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the swatch in the Color field to change the color of the Moving Average Result Bar, Line or Area.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-24.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
A color picker interface will load on the screen. Pick a preset color or mix a custom color.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-25.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the down arrow on the Series Type field to change the current graphic type (Bar, Line or Area).
<BR>
On the drop down list select the appropriate option.
::'''Bar''' - this will represent the result on the report as a bar.
::'''Line''' - this will represent the result on the report as a horizontal line.
::'''Area''' -  this will represent the result on the report as a wave.
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-26.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Y-axis arrow to see the available list.
<BR>
The Y-axis is defined in the Appearance section. There are 2 Y-axes available - Right & Left.
<BR>
Select which Index (Axis) the Moving Average Series is to be associated with.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-27.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Decimal Places field to change what is displayed for the Moving Average Result.
<BR>
The list will show 0 to 5. If the Formula being created needs to show a specific number of decimal places on the graph, select a 1, 2, 3, 4 or 5. If the Formula Result should only show a whole number, select 0.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-28.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the down arrow in the Series field to select a different series to be averaged.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-29.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Number of field to change the dimension range.
::The Dimension field has the following selections that may show in this field - Months, Weeks, Days, Location, Name, Reason, Tag Filters and Shift Tag Filters. The most common selection would be Months, Weeks or Days.
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-30.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="COPY"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''DUPLICATE A SERIES'''</u></span></div>
<BR>
Once a Series has been setup, it can be Duplicated. Click on the Duplicate icon for the series that needs to be duplicated.
<BR>
<gallery widths=600px heights=202px>
File:Mixed-Moving-Series-70.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The duplicated series will show at the bottom of the Series list as "(Name) Copy".
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-71.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click on the Expand icon for the duplicated series.
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-72.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Click in the Name field to enter the correct name.
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-73.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
Edit any of the other fields that need to be changed.
<BR>
Refer to the "Edit a Series" section about for details on altering the fields - [[#EDIT|'''Click Here''']].
<BR>
<gallery widths=600px heights=323px>
File:Mixed-Moving-Series-74.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="DELETE"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''DELETE A SERIES'''</u></span></div>
<BR>
Once a Series has been setup, it can be removed from the report. Click on the Delete icon for the Series that needs to be removed.
<BR>
<gallery widths=600px heights=220px>
File:Mixed-Moving-Series-40.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
There will be no warning message, the Series will be automatically removed.
<BR>
<gallery widths=600px heights=220px>
File:Mixed-Moving-Series-41.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="MOVE"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''MOVE A SERIES'''</u></span></div>
<BR>
When there are multiple Series in a report, the user can change the order.
<BR>
If the Series is set to be Visible, the order will change where the Bar, Line or Area is on the report cell.
<BR>
For a Series at the Top of the order, click on the Down icon to move it down in the order.
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-50.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
For a Series at the Bottom of the order, click on the Up icon to move it up in the order.
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-51.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
For a Series in the Middle of the order, click on the Up or Down icon to move it up or down in the order.
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-52.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
<span id="OPEN"></span>
<div style="text-align: center;"><span style="color:#0054a6; font-size:150%;"><u>'''OPEN/EXPAND A COLLAPSED SERIES'''</u></span></div>
<BR>
When there are multiple Series in a report, only the active/selected Series will show. To change between series the user will need to open/expand the closed series.
<BR>
Click on the Expand icon.
<BR>
<gallery widths=600px heights=269px>
File:Mixed-Moving-Series-60.png|link=Mixed - Moving Average - Series
</gallery>
----
<BR>
The Series selected will open/expand to show the details. Any Series that was previously opened/expanded will automatically collapse.
<BR>
<gallery widths=600px heights=391px>
File:Mixed-Moving-Series-61.png|link=Mixed - Moving Average - Series
</gallery>
----
<div style="text-align: right;">
[[#ADD|'''Add''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  [[#EDIT|'''Edit''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#COPY|'''Duplicate''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#DELETE|'''Delete''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#MOVE|'''Move''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[#OPEN|'''Open/Expand''']] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</div>
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="230" align="right" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="right"
|
|[[File:Reports Button.png|200px|Return to Reporting Page|link=Reporting - Main]] || [[File:Reports-Btn.png|Return to Reports|200px|link=Reporting - Reports]]
|}
</div>
----
{|style="background:transparent; color:black" border="0" height="200" align="center" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="center"
|
|[[File:VC Footer.png|center]]
|}
<div class="logo_img" >
{|style="background:transparent; color:black" border="0" height="200" align="center" valign="bottom" cellpadding=10px cellspacing=10px
|+style="background:transparent|
|-align="center"
|
|[[File:LinkedIn.png|Follow Us On LinkedIn|link=https://www.linkedin.com/company/versacall/]]
|
|[[File:BlogIcon.png|View our Blog|link=https://www.versacall.com/blog/]]
|}
</div>