Report Offerings – MRC

There are a number of Report Offerings available with MRC. Similar to the Dashboards, the reports are powered by Power BI and a combination of Bootstrap and JavaScript.

The first report we will look at uses Power BI.


MRC - Admin - Reporting

This report is available by expanding the "MRC - Admin" section and clicking "Reporting"


MRC - Admin - Reporting - Today


The first page that loads is for "Today"


The far right of the report navigation bar allows the user to "Choose Zone(s):".

This allows for filtering the contents of the page to a specific Zone.


The upper right chart is the "Hourly Scans" and allows for the user to examine the number of scans performed by hour for the day.

Hovering over a datapoint will provide tooltip showing the details.


You can also hover your mouse over the upper right corner to reveal “Focus mode”. Clicking this will open the chart in a larger view.


Like in the Dashboard, the upper right consists of six tiles. The first show a count of “Scans Today” which displays the number of scans that were conducted.


Next to the Scans is “Tasks Today” which provides the number of Tasks completed for the day. Remember a Scan can have up to 25 Tasks associated with it.


The last tile of the row is the number of “Images” that have been uploaded for the day. Each scan that is submitted into the system has the opportunity to have an image attached.


Below the “Scans Today” tile you will see “Sat Today” This is a count of the “Sat”, or Satisfactory, Tasks that were completed for the day. Adding “Sat Today” and “UnSat Today” will equal the value in the “Tasks Today” tile.


After the Sat Tasks count you will find the “UnSat Today” count. This is the number of “UnSat” or Unsatisfactory Tasks for the day.


The last tile in this section is the “Fast” Scans that were flagged for the day. Please refer to the “Terminology” article for any definitions that are unfamiliar.


The large chart in the second row is the “Hourly Tasks Sat vs UnSat” records. Here you will see the number of tasks conducted throughout the day. Green represents “Sat Tasks” and Red represents “UnSat Tasks”.


Moving to the right from the “Hourly Tasks...” chart you will see “Scans by User”. This will provide a breakdown of the total number of Scans conducted by each person within your organization.

Try clicking the bar above a User. It will filter the rest of the page for the selected User.


The next tile is “Fast Scans by User”. As indicated in the title of the chart, it is the “Fast Scans” that were flagged in the system for the day, by User.

Similar to the previous tile, try clicking the bar above the User to filter some of the other charts.


The third row is covered by a single table of information. This is the "Fast Scans Today - Detail" where the user will see the times of the scans, the difference in time, the Zones, areas and who conducted the fast scans.


The large table of information on the lower left corner is the "Scans Today - Detail". This is where each of the Scans conducted is listed.

Click a row within this table to show the details, including the image in the visual to the left.


The final part of the page is the "Scan Details" card.

When the user selects one of the rows in the "Scans Today - Detail" the details of that scan, including the image, will be displayed in the "Scan Details" card.


MRC - Admin - Reporting

This report is available by expanding the "MRC - Admin" section and clicking "Reporting", then clicking the "Daily" button.


MRC - Admin - Reporting - Daily


pbi-nav-daily

Here you can see the details of the Scans and Tasks by Day.


To the right the user can select specific "Zone(s):". Click the drop down and check, or uncheck, Zones of interest.

This allows for filtering the contents of the page to a specific Zone.


All the way to the right, there is a section for "Choose Date(s):". Clicking on the date will drop down a calendar to select the start date, and end date, for a report.

The user can also type directly in the date fields without the need to use the calendar selection method.

The report page will automatically update based on the selection.


The first chart, in the upper left corner of the page, is the "Daily Scans".

This will show you the number of scans performed each day.

Like other reports, hovering over a datapoint will display the numbers behind the report.


In the upper row of the page, the first tile is a count of the "Scans" done for the period of the report.

If you chose a month, it is the total scans for the month. If you chose one year, it is the total scans for the year.


In the upper row of the page, the second tile is the count of "Tasks" done for the period of the report.

As with the previous tile, if you chose a month, it is the total tasks for the month. If you chose one year, it is the total tasks for the year.


The final tile, is the number of images uploaded for the period of the report.

As with the other tiles, and sections within this page, if a period of one month was selected, it is the images uploaded for the month. If a year was selected, it is the number of uploaded images for the year.


Below the “Scans” tile you will see “Sat Tasks”. This is a count of the “Sat”, or Satisfactory, Tasks that were completed for the period of the report. Adding “Sat Tasks” and “UnSat Tasks” will equal the value in the “Tasks” tile.


After the Sat Tasks tile, you will find the “UnSat Tasks”. This is a count of the “UnSat”, or Unsatisfactory, Tasks that were completed for the period of the report. Adding “Sat Tasks” and “UnSat Tasks” will equal the value in the “Tasks” tile.


The last tile in this section is the “Fast Scans” that were flagged for the period of the report. Please refer to the “Terminology” article for any definitions that are unfamiliar.


The large chart in the second row is the “Daily Tasks by Sat vs UnSat”. Here you will see the number of daily tasks conducted throughout the period of the report. Green represents “Sat Tasks” and Red represents “UnSat Tasks”.

Like the other charts, within most parts of the reporting and dashboards, hovering over the datapoint will provide additional detail and the numbers behind the chart.


Moving to the right from the "Daily Tasks..." chart you will see "Scans by User". This will provide a breakdown of the total number of Scans conducted by each person within your organization for the period of the report.

Try clicking the bar above a User. It will filter the page for the selected User.


The next tile is “Fast Scans by User”. As indicated in the title of the chart, it is the scans that were flagged in the system throughout the period of the report, by User.

Similar to the previous tile, try clicking the bar above the User to filter the other charts.


The third row is covered by a single table of information. This is the “Fast Scans – Detail” where the user will see the times of the scans, the difference in time, the Zones, areas and who conducted the fast scans.

Again, these are all the Fast Scans for the period of the report.


The large table of information on the lower left corner is the “Scan List”. This is where each of the Scans conducted for the period are listed.

Click a row within this table to show the details, including the image in the visual to the right.

Also, note that the "Sat Ratio" within the "Scan List" uses conditional formatting to help highlight Scans that had a lower than 100% Satisfaction.


The final part of the page is the “Scan Details” card.

When the user selects one of the rows in the “Scan List” the details of that scan, including the image, will be displayed in the “Scan Details” card.

In this example, you can also see where "Floor" was marked "Unsat" with some notes about what needs to be done to correct it.

Perfect example of how to best leverage the system.


MRC - Admin - Reporting

This report is available by expanding the "MRC - Admin" section and clicking "Reporting", then clicking the "Zone" button.


MRC - Admin - Reporting - Zone


Here you can see the details of the Scans and Tasks by Day and by Zone.


[su_post field="post_content" post_id="477"]
[su_post field="post_content" post_id="481"]

The first chart in the main body of the "Zone" page is the "Scans by Zone" donut chart.

This displays the percentage of scans that have occurred by Zone.

Hovering over the section of the donut will display the count, the percentage, and Zone it refers to.

Clicking a Zone will select it and filter the page for that zone.


[su_post field="post_content" post_id="488"]
[su_post field="post_content" post_id="493"]
[su_post field="post_content" post_id="495"]
[su_post field="post_content" post_id="497"]

The next tile we will look at is the Sat Ratio.

This is a gauge chart that show the percentage of Satisfactory Tasks for the period of the report.

It is a ratio of Sat Tasks / Total Tasks.

Close to 100% is ideal, however, too close to 100% can indicate more attention to detail is needed during Task completion.


[su_post field="post_content" post_id="503"]
[su_post field="post_content" post_id="505"]
[su_post field="post_content" post_id="509"]
[su_post field="post_content" post_id="517"]
[su_post field="post_content" post_id="512"]
[su_post field="post_content" post_id="521"]
[su_post field="post_content" post_id="533"]
[su_post field="post_content" post_id="534"]


MRC - Admin - Reporting

This report is available by expanding the "MRC - Admin" section and clicking "Reporting", then clicking the "Area" button.


MRC - Admin - Reporting - Area


Here you can see the details of the Scans and Tasks by Day and by Area, or Architectural ID.


[su_post field="post_content" post_id="481"]

The first visual available in the main body of the "Area" page is the "Search Architectural ID" box.

Start typing the name of an Area and the list will automatically narrow to include what you are searching for.

Once the Area you are looking for shows in the box you can click it to filter the report.

You can click more than one Area by simply clicking the first, then click a another. Clicking a selected Area a second time will deselect it.

To reset the filter click the "Reset filter" button: mrc-pbi-reset-filter

To select all of the search results click the "Select all" button: mrc-pbi-select-all


The next card is the "Scans by Architectural ID".

This chart provides the name of the Architectural ID and the number of Scans completed for it during the period of the report.

By default it shows the most scanned at the top going to the least scanned at the bottom.

Click one of the Architectural ID's to select it and filter the page.


[su_post field="post_content" post_id="493"]
[su_post field="post_content" post_id="495"]
[su_post field="post_content" post_id="497"]

The next tile we will look at is the Sat Ratio.

This is a gauge chart that show the percentage of Satisfactory Tasks for the period of the report.

It is a ratio of Sat Tasks / Total Tasks.

Close to 100% is ideal, however, too close to 100% can indicate more attention to detail is needed during Task completion.


[su_post field="post_content" post_id="503"]
[su_post field="post_content" post_id="505"]
[su_post field="post_content" post_id="509"]
[su_post field="post_content" post_id="517"]
[su_post field="post_content" post_id="512"]
[su_post field="post_content" post_id="521"]
[su_post field="post_content" post_id="533"]
[su_post field="post_content" post_id="534"]


MRC - Admin - Reporting

This report is available by expanding the "MRC - Admin" section and clicking "Reporting", then clicking the "User" button.


MRC - Admin - Reporting - User


Here you can see the details of the Scans and Tasks by Day and by User.


[su_post field="post_content" post_id="481"]
mrc-pbi-search-user-all

The first visual available in the main body of the "User" page is the "Search Scans for User" box.

Start typing the name of a User and the list will automatically narrow to include what you are searching for.

Once the User you are looking for shows in the box you can click it to filter the report.

You can click more than one User by simply clicking the first, then click a another. Clicking a selected User a second time will deselect it.

To reset the filter click the "Reset filter" button: mrc-pbi-reset-filter

To select all of the search results click the "Select all" button: mrc-pbi-select-all


mrc-pbi-scans-by-user

The next table is the "Scans by User".

This table provides the name of the User, the number of Scans completed, Sat and UnSat Tasks, and the Sat Ratio during the period of the report.

By default it shows the User with the most scans at the top, going to the least scans at the bottom.

Click one of the Users to select them and filter the page.


[su_post field="post_content" post_id="493"]
[su_post field="post_content" post_id="495"]
[su_post field="post_content" post_id="497"]

The next tile we will look at is the Sat Ratio.

This is a gauge chart that show the percentage of Satisfactory Tasks for the period of the report.

It is a ratio of Sat Tasks / Total Tasks.

Close to 100% is ideal, however, too close to 100% can indicate more attention to detail is needed during Task completion.


[su_post field="post_content" post_id="503"]
[su_post field="post_content" post_id="505"]
[su_post field="post_content" post_id="509"]
[su_post field="post_content" post_id="517"]
[su_post field="post_content" post_id="512"]
[su_post field="post_content" post_id="521"]
[su_post field="post_content" post_id="533"]
[su_post field="post_content" post_id="534"]



Leave a Comment