Mails Sample Dashboard
Description: The data displayed in the Aconex - Mails dashboard, and in any out-of-the-box or custom dashboard is based on the projects that you have access in Aconex.
Use the Aconex - Mails dashboard to discover information such as (but not limited to):
- Identify existing red flags on your projects like delayed correspondences
- Identify the most/least active organizations based on mail correspondences/responses
- Compare and analyze mail activity across the project portfolio
- Track KPIs, view mail details, etc.
You can also create your own data sets and/or data flows to:
- Implement custom logic to get deeper insights like Avg. RFI turnaround time, Mails overdue >N days, etc.
- Achieve custom dashboard requirements using Mail Project Fields
- Create use cases that need linking other subject areas with Mails, etc.
Number of Canvases: 4
Default Canvas: Activity
Canvas/Dashboard Name: Mails Sample Dashboard
Data Source(s): Aconex
Subject Area: not applicable
Dataset: Mail DS 1-11-23
Dashboard
Figure 45: Aconex - Mails Sample Dashboard - Activity
Figure 46: Aconex - Mails Sample Dashboard - Overview
Figure 47: Aconex - Mails Sample Dashboard - Details
Figure 48: Aconex - Mails Sample Dashboard - Mail Thread
Table 74: Project Status - Dimensions
Canvas | Dimension / Attribute | Subject Area / Dataset |
---|---|---|
Activity Details Mail Thread | Sent Date | Mail DS 1-11-23 |
Activity Overview Details | Project Name | Mail DS 1-11-23 |
Overview Details Mail Thread | Mail Type | Mail DS 1-11-23 |
Overview Details Mail Thread | To Organization | Mail DS 1-11-23 |
Overview Details Mail Thread | From Organization | Mail DS 1-11-23 |
Details Mail Thread | Reference Number | Mail DS 1-11-23 |
Details Mail Thread | Mail Number | Mail DS 1-11-23 |
Details | From User | Mail DS 1-11-23 |
Details | To User | Mail DS 1-11-23 |
Details Mail Thread | Mail Status | Mail DS 1-11-23 |
Details | Reason for Issue | Mail DS 1-11-23 |
Mail Thread | Reply Type | Mail DS 1-11-23 |
Table 75: Project Status – Measures
Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
---|---|---|---|
Activity Overview | # of Mails (Inbox) | Fact | Mail DS 1-11-23 |
Activity Overview | # of Mails (Sent) | Fact | Mail DS 1-11-23 |
Activity Overview | # of Mails (Sent + Inbox) | Fact | Mail DS 1-11-23 |
Table76: Budget Insights - Filters
Canvas | Filter Type | Is Expression Filter | Dimension / Attribute | Subject Area / Dataset |
---|---|---|---|---|
All Canvas | Canvas | No | Project Name | Mail DS 1-11-23 |
Activity Details Mail Thread | Canvas | No | Mail Type | Mail DS 1-11-23 |
Overview | Dashboard | No | Mail Type | Mail DS 1-11-23 |
Overview | Visualization | No | Mail Status | Mail DS 1-11-23 |
Overview | Visualization | Yes | RANK(FILTER(XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."# of Mails (Sent)" USING XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."Mail Status"='Overdue') BY XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."Project Name") <=5
| Mail DS 1-11-23 |
Overview | Visualization | Yes | RANK(FILTER(XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."# of Mails (Inbox)" USING XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."Mail Status"='Overdue') BY XSA('blue2'.'Mail DS 1-11-23')."Aconex - Mails"."Project Name") <=5
| Mail DS 1-11-23 |
Details Mail Thread | Canvas | Yes | Mail Status | Mail DS 1-11-23 |
Details | Canvas | No | From Organization | Mail DS 1-11-23 |
Details | Canvas | No | To Organization | Mail DS 1-11-23 |
Mail Thread | Canvas | No | Reply Type | Mail DS 1-11-23 |
Mail Thread | Canvas | No | Recipient Type | Mail DS 1-11-23 |
Related Topics
Data Visualizations Using Oracle Aconex Data
Users, Projects, and Organizations Sample Dashboard
Last Published Friday, December 8, 2023