Creating The Built-in Dashboards

Overview

In order to provide our customers with as much value as possible from the day they install the AppsAnywhere Analytics product, we created a set of pre-defined dashboards that come "out-of-the-box". These dashboards were created based on feedback from customers on what they wanted to see and should give you a comprehensive overview of everything that is going on in the system.

This article describes exactly how each of the AppsAnywhere Analytics built-in dashboards were created. Using the information in this article, you should be able to "follow along" and replicate these dashboards yourself, whether it's just as a learning exercise, to increase your familiarity of the product or inspire you to create reports of your own that better suit your particular needs.

Dashboards

The following are all the dashboards that are provided by default through AppsAnywhere Analytics. For each one, you can see which explore you need to start from, which fields you need to select from the left-hand side and any customization you need to do to get the report looking exactly as it does in the dashboard that we provide.

Monthly Management Summary

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
Report Period	AppsAnywhere Data Launches	Launch Date/Time Date Month Name Year Date (Filter)	Single Value	N/A	Instead of selecting the "Date" field under "Launch Date/Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "1" "complete months". Add a calculation field called "Month & Year" and use the following formula: CODE `concat(${aa_launches.created_month_name}, " ", ${aa_launches.created_year})` Hide the "Month Name" and "Year" columns from the visualization using the cog in the top right of the columns and selecting "Hide from Visualization"
Total Launches	AppsAnywhere Data Launches	Launch Date/Time Date Month Date (Filter) Number of Launches	Single Value	Style Show Title: ON Title Override: "Total Launches" Comparison Show Comparison: ON Style: "Calculate Progress (with Percentage)" Show Label: ON	Instead of selecting the "Date" field under "Launch Date/Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "2" "complete months". You need two months of data to do the comparison. By selecting "complete months", it ensures that this report represents the previous full month Add a calculation field called "Last Month" and use the following formula: CODE `offset(${aa_launches.count_launches},1)`
Active Users	AppsAnywhere Data Launches	Launch Date/Time Date Month Date (Filter) Number of Distinct Users	Single Value	Style Show Title: ON Title Override: "Active Users" Comparison Show Comparison: ON Style: "Calculate Progress (with Percentage)" Show Label: ON	Instead of selecting the "Date" field under "Launch Date/Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "2" "complete months". You need two months of data to do the comparison. By selecting "complete months", it ensures that this report represents the previous full month Add a calculation field called "Last Month" and use the following formula: CODE `offset(${aa_launches.count_distinct_users},1)`
Most Popular Resources (# of Portal Launches)	AppsAnywhere Data Launches	App/Desktop Name Environment Info Organisation Owned? (Pivot) Launch Date/Time Date Date (Filter) Number of Launches	Bar	Plot Series Positioning: "Stacked" Series Collection: "Springfield" Customizations > No > Label: BYOD Customizations > Yes > Label: Organization Owned Values Value Labels: ON	Instead of selecting the "Date" field under "Launch Date/Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "1" "complete months". By selecting "complete months", it ensures that this report represents the previous full month. Instead of selecting the "Organisation Owned?" field, click the "Pivot" button that appears when you hover over that field. This will split the bars to show whether or not the launch was on a user's owned device or a device owned by the organization
Number of Launches and Active Users	AppsAnywhere Data Launches	Launch Date/Time Date Date (Filter) Number of Launches Number of Distinct Users	Line	Series Customizations > Number of Launches Type: "Line" Points: "Circle" Customizations > Number of Distinct Users Type: "Line" Points: "Circle"

Landing Dashboard

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
Logins This Month	AppsAnywhere Data Login Sessions	Session Start Time Date Month Date (Filter) Number of Sessions Custom Fields New Calculation (See Notes)	Single Value	Style Show Title: ON Title Override: "Logins This Month" Comparison Show Comparison: ON Style: "Show as Value" Show Label: ON Label: "Last Month (Total)"	Instead of selecting the "Date" field under "Session Start Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "2" "months". You need two months of data to do the comparison Add a calculation field called "Last Month" and use the following formula: CODE `offset(${aa_sessions.count_sessions},1)`
Portal Users This Month	AppsAnywhere Data Login Sessions	Session Start Time Date Month Date (Filter) Number of Users Custom Fields New Calculation (See Notes)	Single Value	Style Show Title: ON Title Override: "Portal Users This Month" Comparison Show Comparison: ON Style: "Show as Value" Show Label: ON Label: "Last Month (Total)"	Instead of selecting the "Date" field under "Session Start Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "2" "months". You need two months of data to do the comparison Add a calculation field called "Last Month" and use the following formula: CODE `offset(${aa_users.count_users},1)`
Devices Seen This Month	AppsAnywhere Data Login Sessions	Session Start Time Date Month Date (Filter) Number of Devices Custom Fields New Calculation (See Notes)	Single Value	Style Show Title: ON Title Override: "Devices Seen This Month" Comparison Show Comparison: ON Style: "Show as Value" Show Label: ON Label: "Last Month (Total)"	Instead of selecting the "Date" field under "Session Start Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "2" "months". You need two months of data to do the comparison Add a calculation field called "Last Month" and use the following formula: CODE `offset(${aa_devices.count_devices},1)`
Top 10 Resources (# of Portal Launches)	AppsAnywhere Data Launches	App/Desktop Name Number of Launches (Ordered) Launch Date/Time Date Month (Filter)	Bar	N/A	Instead of selecting the "Month" field under "Launch Date/Time Date", click the "Filter" button that appears when you hover over that field and set the filter to "is in the past" "1" "months".
Portal Logins by OS	AppsAnywhere Data Login Sessions	Browser OS Family Number of Sessions	Pie	Plot Label Type: "Label - Percent" Inner Radius: 50	The "Login Sessions" explore represents all devices that log into AppsAnywhere. The "Known Devices" explore only represents those that have been validated, so using that explore for this report would only show Windows or Mac OS devices.
System Access by Location	AppsAnywhere Data Known Devices	Location (Country Code) Number of Devices	Map	Plot Heatmap Gridlines: ON Heatmap Opacity: 0.5 Map Map Position: "Fit to Data"	Location is currently only tracked for devices that have been validated.
All Applications	AppsAnywhere Data Apps/Desktops	App/Desktop ID App/Desktop Name App or Desktop? (Filter)	Table	Plot Table Theme: "White"	Instead of selecting the "App or Desktop?" field, click the "Filter" button that appears when you hover over that field and set the filter to "is" "Application"
All Desktops	AppsAnywhere Data Apps/Desktops	App/Desktop ID App/Desktop Name App or Desktop? (Filter)	Table	Plot Table Theme: "White"	Instead of selecting the "App or Desktop?" field, click the "Filter" button that appears when you hover over that field and set the filter to "is" "Desktop"

Resource Detail Dashboard

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
Resource Type	AppsAnywhere Data Apps & Desktops	App or Desktop?	Single Value	N/A	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID
Resource Name	AppsAnywhere Data Apps & Desktops	App/Desktop Name	Single Value	N/A	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID
# of Portal Launches	AppsAnywhere Data Launches	Number of Launches	Single Value	N/A	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Launch Date/Time Date
Rank	Other Information App/Desktop Rankings	Rank	Single Value	N/A	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Time Period
Launch History	AppsAnywhere Data Launches	Launch Date/Time Date Date Number of Launches	Line	X Axis Name: "Launch Date" Plot Line Interpolation: "Monotone"	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Launch Date/Time Date
Launch Demand - Typical Day	Calculated Data Hourly Launch Totals (Last 30 Days)	Summary Period Date Hour of Day Average Number of Portal Launches	Line	X Axis > Name: "Hour of Day" Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"	Works off the average number of launches for each hour in the previous 30 days Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID
Launch Demand - Typical Week	Calculated Data Daily Launch Totals (Last 90 Days)	Summary Period Date Day of Week Index (Ordered and hidden from visualization) Day of Week Average Number of Portal Launches	Line	X Axis > Show Axis Name: OFF Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID
Launch Demand - Typical Year	Calculated Data Monthly Launch Totals (Last 3 Years)	Summary Period Date Month Num (Ordered and hidden from visualization) Month Name Average Number of Portal Launches	Line	X Axis > Show Axis Name: OFF Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"	Works off the average number of launches for each month in the previous 36 months Hide the month number from the chart using the cog in the top right of the "Month Num" column and selecting "Hide from Visualization" Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID
Overall Concurrency (Metered Delivery Methods)	Calculated Data Daily Metered Concurrency Info	Summary Date Total Minimum Concurrency Total Maximum Concurrency Total Weighted Average Concurrency	Line	Plot Line Interpolation: "Monotone"	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Launch Date/Time Date
Concurrency (By Delivery Mechanism)	Calculated Data Daily Metered Concurrency Info	Summary Date Total Maximum Concurrency Delivery Technology (Metered DMs) (Pivot)	Line	Plot Series Positioning: "Stacked" Line Interpolation: "Monotone" Series Colours > Collection: "Springfield" X Axis Show Axis Name: OFF Y Axis Axis Name: "Peak Concurrency"	Instead of selecting the "Delivery Technology (Metered DMs)" field, click the "Pivot" button that appears when you hover over that field. This will split the graph to show the concurrency split by each delivery technology Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Summary Date
Overall Peak Concurrency	Other Information Daily App-Level Metered Concurrency Summaries	Peak Concurrency	Single Value	N/A	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Summary Date
Peak Concurrency per Delivery Method	Calculated Data Daily Metered Concurrency Info	Delivery Method ID (Pivot) Peak Concurrency	Column	Plot Series Positioning: "Grouped" Legend > Hide Legend: ON Values Value Labels: ON Totals Labels: ON X Axis Axis Value Labels: OFF	Instead of selecting the "Delivery Method ID" field, click the "Pivot" button that appears when you hover over that field. This will split the graph to show the peak concurrency for each delivery method Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID Date Range > Summary Date
Delivery Methods	AppsAnywhere Data Delivery Methods	Delivery Method ID Delivery Method Technology Delivery Method Type Delivery Method Descriptor Is Metered?	Table	Plot Table Theme: White	Dashboard filters are applied to restrict the results: Resource ID > App/Desktop ID

Software Licensing Dashboard

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
Number of Login Sessions	AppsAnywhere Data Login Sessions	Number of Sessions	Single Value	Style Title Override: "Number of Login Sessions"	Dashboard filters are applied to restrict the results: Date Range > Session Start Time Date
Number of Users	AppsAnywhere Data Login Sessions	Number of Users	Single Value	Style Title Override: "Number of Unique Users"	Dashboard filters are applied to restrict the results: Date Range > Session Start Time Date
Number of Validated Devices	AppsAnywhere Data Login Sessions	Number of Devices	Single Value	Style Title Override: "Number of Validated Devices"	Dashboard filters are applied to restrict the results: Date Range > Session Start Time Date
Most Popular Resources (# Portal Launches)	Calculated Data Daily Usage Summaries	App/Desktop Name App or Desktop? Total Number of Portal Launches	Table	Plot Table Theme: "White"	Dashboard has a date filter which acts upon the "Summary Date" field to restrict the results, by default to the past 30 days
Most Popular Resources (# Metered Launches)	Calculated Data Daily Usage Summaries	App/Desktop Name App or Desktop? Total Number of Metered Launches	Table	Plot Table Theme: "White"	Dashboard has a date filter which acts upon the "Summary Date" field to restrict the results, by default to the past 30 days
Most Popular Resources (Metered Runtime)	Calculated Data Daily Usage Summaries	App/Desktop Name App or Desktop? Total Metered Run Time	Table	Plot Table Theme: "White"	Dashboard has a date filter which acts upon the "Summary Date" field to restrict the results, by default to the past 30 days
Resource Usage Summary	Calculated Data Daily Usage Summaries	App/Desktop Name App or Desktop? Total Number of Portal Launches Total Number of Metered Launches Total Metered Run Time	Table	Plot Table Theme: "White"	Dashboard has a date filter which acts upon the "Summary Date" field to restrict the results, by default to the past 30 days

System Usage Trends Dashboard

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
# of Portal Launches - Year on Year	AppsAnywhere Data Launches	Launch Date/Time Date Month Name Year (Pivot) Number of Launches	Line	X Axis > Name: "Month" Y Axis > Name: "Number of Launches"	Instead of selecting the "Year" field under "Launch Date/Time Date", click the "Pivot" button that appears when you hover over that field
Launch Demand - Typical Day	Calculated Data Hourly Launch Totals (Last 30 Days)	Summary Period Date Hour of Day Average Number of Portal Launches	Line	X Axis > Name: "Hour of Day" Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"	Works off the average number of launches for each hour in the previous 30 days
Launch Demand - Typical Week	Calculated Data Daily Launch Totals (Last 90 Days)	Summary Period Date Day of Week Index (Ordered and hidden from visualization) Day of Week Average Number of Portal Launches	Line	X Axis > Show Axis Name: OFF Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"
Launch Demand - Typical Year	Calculated Data Monthly Launch Totals (Last 3 Years)	Summary Period Date Month Num (Ordered and hidden from visualization) Month Name Average Number of Portal Launches	Line	X Axis > Show Axis Name: OFF Y Axis > Name: "Portal Launches (Average)" Plot > Line Interpolation: "Monotone" Series > Average Number of Portal Launches > Type: "Area"	Works off the average number of launches for each month in the previous 36 months Hide the month number from the chart using the cog in the top right of the "Month Num" column and selecting "Hide from Visualization"

BYOD Dashboard

Tile Name	Explore Name	Fields Used	Visualization Type	Visualization Changes	Notes
Device Ownership	AppsAnywhere Data Known Devices	Is Organisation Owned? Number of Devices	Pie	Plot Value Labels: "Labels" Label Type: "Label - Percent" Inner Radius: 50 Series Customizations > No: "BYOD" Customizations > Yes: "Organization Owned"
Device Type	AppsAnywhere Data Known Devices	Device Type Number of Devices	Pie	Plot Value Labels: "Labels" Label Type: "Label - Percent" Inner Radius: 50
Portal Logins by OS	AppsAnywhere Data Known Devices	Browser OS Family Number of Sessions	Pie	Plot Label Type: "Label - Percent" Inner Radius: 50	The "Login Sessions" explore represents all devices that log into AppsAnywhere. The "Known Devices" explore only represents those that have been validated, so using that explore for this report would only show Windows or Mac OS devices.
System Access by Location	AppsAnywhere Data Known Devices	Location (Country Code) Number of Devices	Map	Plot Heatmap Gridlines: ON Heatmap Opacity: 0.5 Map Map Position: "Fit to Data"	Location is currently only tracked for devices that have been validated.