MyWraps Reports

Tags: Help, MyWraps, Definitions

Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-mywraps-reports/.

MyWraps reports looks at wrap cell values over all available wrap instances to plot in live charts or in tables. Switching between chart and table is a simple one click button and both charts and tables can be filtered, sorted and ordered to give you exactly the information you require. Live links between MyWraps reports and Excel data are easy to create if you are more comfortable working in Excel. Administrators can export (and import) between the site to a local device so administrators have complete control over all data collected by the site.

Action = The default action is 'Insert Wrap Instance'. If instances are selected and a bulk action wrap is available you get an option to use a bulk action wrap.
Setup = Define wrap cell values to be placed in table columns. [AdminTenant Only]
Filter = Existing "Creator Filter" and "State Filters".

'Create' shows you only those instances you have created or all those on the system. The second filter control is call state where you can select:

Live - Show all wrap instances not yet frozen. Wraps freeze when the last signature has been made to indicate completion of a process. Show Work in progress.
Frozen - Show instances are frozen. Shows legacy data.
AwaitingSignature - Show wrap instances that are waiting for my signature.
SignedByMe - Show wrap instances that I have signed (live and frozen)
Any - Show me everything.

Column filters are now set up using the button adjacent to text boxes in each column. Alternatively text may be entered directly into the text boxes, for example:

eq(10) - equal to 10
10 - equal to 10, eq is the default operator if not specified (apart from strings where co is the default)
ne(10) - does not equal 10
eq(hello) - equals 'hello'
co(hello) - contains 'hello'
nc(hello) - does not contain 'hello'
hello - contains 'hello', co is the default operator for strings
gt(1) - greater than 1
ge(1) - greater than or equal to 1
lt(1) - less than 1
le(1) - less than or equal to 1
eq() - blank values
ne() - non-blank values
Date filters must be in universal time format [yyyyMMdd] (e.g. lt(20181225) means before Christmas 2018) DateTime filters are [yyyyMMddHHmmss]


ΣAggregate = Column aggregates placed in column headers (AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR and VARP). [AdminTenant Only]
Download = Export CSV or HTML
Chart = Chart setup options. [AdminTenant Only]
 Chart Range = Chart Range setup options. [AdminTenant Only]
View (toggle) = Table view/chart view

Please note that the search is limited to 500 records to ensure a reasonable response from the server (this may be increased by adjusting the MaxRows=500 parameter if required).

MyWraps Live Reports (Tabular View)

Navigating to MyWraps will present a list of Wrap instances available to you. Filter controls show you Wrap instances that are ‘Mine’ (i.e. created by the logged in user) or ‘Any’ (i.e. created by anyone). The state of a Wrap instance at any time is ‘Live’ or ‘Frozen’. Some ‘Live’ Wrap instances will be in the state ‘AwaitingSignature’ (i.e. waiting for the logged in user to sign). The state ‘Any’ means ‘Live’ or ‘Frozen’ and will list everything. All this is available to any user by clicking the site menu option.

MyWraps Live Reports (Chart View)
The power of a MyWraps report is how easily you can add columns of additional data items, filter any column of data and sort the data. We provide tools to help create custom reports but generally users will ask their subdomain administrator to create one for them. Any MyWraps report can be stored as a single URL which can be stored as a browser bookmark, added as a hyperlink on a webpage or added to the site menu. From a tabular data view simply click the 'Chart' button to visualize the data. Charts have interactive pinch-zoom controls and each data-point is click-able to open the wrap data source. It's an amazing feeling to be have your data literally at your fingertips.

Import to Excel

MyWraps Import to Excel - Any My wraps reports can be exported as a csv file or a html file and Excel can read then both (File>Open). csv files contain the bare numbers with no formatting and html files contain all the numbers and hyperlinks to take you back to the source information on your ExcelWraps subdomain.

MyWraps Live Link to Excel - Did you know that Excel has an embedded browser? Amazingly it reads a MyWraps report and pulls it through to Excel for additional calculations and charting! What’s more a ‘Refresh’ button immediately updates your Excel wookbook with live information. Now data is truly at your fingertips to investigate as you wish. This functionality is not well known but the ExcelWraps team will guide you through the process using our screen sharing utility.

WrapPack Zip Exports

Administrators of your ExcelWraps subdomain can export the data in a zip file. This file contains the Wrap and all the Wrap instance information and can be imported to another ExcelWraps subdomain. Inside an exported zip file you’ll find an XML file (Extensible Markup Language) this is a structured data file that can be read by Excel. To ease you into learning how Excel manages XML data files we have prepared some workbooks that can read any XML exported from your ExcelWraps subdomain. Our WrapReader.xlsm workbook splits the data it contains into Excel filtered lists and pivot tables presented on separate tabs. The workbook reads the whole data set but native Excel Filter controls allows you to filter down to single items or multiple data items. It is easy to determine aggregate values over the selected data items using functions like AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR and VARP. Our Worksheet contains macros that will find the source URL of any data item, we even highlight the data item so it is easily identified. Signature data has a slightly different data structure but is similarly interrogated using our WrapReaderSig.xlsm workbook. These tools can be used offline to generate both simple and complex reports and they can be completely customised using Excel’s native commands. We have taken data reporting out of the hands of specialists in the IT department and put them in the hands of any Excel user. As we promise “all you need to know is Excel, we do the rest”.

Bespoke Reports
The ExcelWraps team use powerful database reporting tools to make any report no matter how complex. These reports can be made available through your subdomain.