FAQs - Dashboards
Q1:Dashboard progress is lost after adding a report widget in Prolaborate
Description
The customer's scenario is as follows,
The user was working on their new dashboard and wanted to include a report widget.
After the adding the report widget, the user was taken to a new page, for configuring the report widget.
Once the user has completed the report widget, the user navigated again to the dashboard page, but the changes done to the dashboard were gone.
Resolution
On analyzing this scenario, we found that when selecting the "Create Report" option, a new tab will be opened for configuring the report widget so that the ongoing work in the dashboard remains unaffected.
So, when the customer accidentally closed the dashboard page without saving it. As a result, the unsaved dashboard configuration was lost when the customer navigated to the dashboard page from the new tab.
Saving the dashboards before closing it will prevent similar occurrences.
Response
Hi <Customer>,
Thank you for reaching out to Sparx Platform Support.
When you select the 'create report' option, it will open a new tab, ensuring that your ongoing work in the dashboard remains unaffected.
<Screenshot>
The issue might have occurred if you accidentally closed the edit dashboard page without saving your changes. Could you please try this scenario once again and try saving the dashboard this time?
<Screenshot>
If the issue persists, we kindly request you share a short video of the behavior so that we can understand the issue better and assist you accordingly. Please review this information and let us know if you have any questions or need assistance.
Reference
Ticket ID: #8060
Subject: Issue Creating Dashboards
Department: Sparx Platform Support
Tags
dashboard issues, dashboard changes not updated, dashboard lost, dashboard changes lost
Q2:Can I customize the titles of bubbles in a bubble chart based on specific properties, such as the number of applications in a group?
A:Yes, you have the flexibility to display property values as bubble labels while grouping similar values instead of showing the artifact name on the bubble. This can be achieved through slight modifications to the query.
You can specify the desired field in the 'series' condition to determine what appears as the label on the bubble chart. For instance, if you wish to display artifact names on the bubbles, you can use the series syntax 'Name as Series'. To showcase a property name and group it together, you simply need to adjust the series syntax based on the property.
In the modified query below, the bubble label will be based on the values in the 'NumberOfApplicationsInGroup' property. You can customize this according to your requirements. Additionally, the size of the bubble will be determined by the count.
A customer has asked the above question and shared their query for creating a bubble chart. We have altered the sample query below to meet the customer's needs.
Customer query:
SELECT ea_guid AS CLASSGUID, Object_ID as Type, Name as Clickable_Application_Name, Name as series,
xvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Business_Fit'),
yvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Technical_Fit'),
chartvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'NumberOfApplicationsInGroup')
FROM t_object oApp
WHERE Object_Type = 'Class'
AND Package_ID = 6094
ORDER BY Name
Sample query:
SELECT ea_guid AS CLASSGUID, Object_ID as Type, Name as Clickable_Application_Name, ts.value as series,
xvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Business_Fit'),
yvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Technical_Fit'),
chartvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'NumberOfApplicationsInGroup')
FROM t_object oApp
Join t_objectproperties ts on ts.Object_ID=oApp.Object_ID and ts.property = 'NumberOfApplicationsInGroup')
WHERE Object_Type = 'Class'
AND Package_ID = 6094
ORDER BY Name
Reference:
Ticket ID: #6935
Subject: Need to choose bubble title on bubble charts (Realisttic TIME model charts ctd...)
Department: Prolaborate Support
Q3:Need ability to click on a bubble to launch a subquery and open a report. In this case the list of applications in the generated group
A:To enable a report to open when clicking on a bubble, you can either enable the 'MDG-based report,' which loads columns from the Form Designer or enter a custom query in the clickable query field. we have also provided a sample clickable query for reference.
Sample Query:
SELECT ea_guid AS CLASSGUID, Object_ID as Type, Name as Clickable_Application_Name, ts.value as series,
xvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Business_Fit'),
yvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'TIME_Technical_Fit'),
chartvalue = (select tv.value from t_objectproperties tv where tv.Object_ID = oApp.Object_ID and tv.property = 'NumberOfApplicationsInGroup')
FROM t_object oApp
Join t_objectproperties ts on ts.Object_ID=oApp.Object_ID and ts.property = 'NumberOfApplicationsInGroup')
WHERE Object_Type = 'Class'
AND Package_ID = 6094
AND ts.value = '<series>'
ORDER BY Name
Reference:
Ticket ID: #6935
Subject: Need to choose bubble title on bubble charts (Realisttic TIME model charts ctd...)
Department: Prolaborate Support
Related Articles
Known Issues - Dashboard
Filter option unavaliable for all columns Description The customer reported in v3 that we have every column in report widget have filter option but in v4 only one filter option for all tables. Possible Reason This is a feature in v3 but it was ...Build Landscape Chart
Build Landscape Chart In Prolaborate, users can build Landscape charts by any one of the following methods. Build Landscape Chart using Designer Configuration Build Landscape Chart using SQL Queries Build Landscape Chart using Reports Build Landscape ...Build Nested Pie Chart
Build Nested Pie Chart In Prolaborate, users can build Nested Pie charts by any one of the following methods. Build Nested Pie Chart using Designer Configuration Build Nested Pie Chart using SQL Queries Build Nested Pie Chart using reusable reports ...Known Issues - Charts
Q1: Roadmap Displaying EA GUID Values When Grouping by RefGUID Property Description The customer reports that when grouping the roadmap items by a property of type 'RefGUID', the roadmap shows the EA GUID values of the referenced elements. We were ...FAQs- MDG MS Office
Q1:Open-source software used to build the Office MDG for EA. Description In this article we are about to see what all the open-source software used to develop Office MDG for EA. Question 1. what all are the open-source software is used in the Office ...