Question: How can I change the chart legend label in a Summary and Drilldown chart?
To change the legend in a chart to something more user-friendly, you cannot use Rich Data Definition as you can for a table. To change the legend in a chart, you'll need to specify a Locale Data Variable input in the Summary & Drilldown builder.
Question: I have a Summary and Drilldown chart whose X axis shows the date in the format yyyy-mm-dd. How can I change it to show the format "dd" to prevent the X axis labels from overlapping?
You can edit the chart style file. You can find the default chart style file mapping in solutions/dashboard/chartstyles/charttypes.properties. You can use WebCharts3D Designer to edit the chart's style file.
To prevent the X axis labels from overlapping, use the "Slanted" orientation:
To change the X axis label pattern, change the style and pattern:
<labelFormat style="**" pattern="**"/>
IBM WebSphere Dashboard Framework includes a license to a full-function version of WebCharts3D Designer, which can be downloaded from http://www.webcharts3d.com/website/WebCharts50/download/index.jsp
. For more information about the license, see the Dashboard Framework Set Readme file (Readme_dashboards.txt). A User's Guide and Developer's Guide install with WebCharts3D Designer and can be opened from the Start
menu. Both guides include in-depth information about designing charts for use with WebSphere Dashboard Framework.
Question: How do I set up a Summary and Drilldown builder that drills down to a second one?
When you set up the first Summary and Drilldown Builder, select "Call an Action" and call the action that invokes the second Summary and Drilldown Builder.
Question: I have connected two Summary and Drilldown builders together. How do I add navigation to return to the first Summary and Drilldown page after going to the second one?
Use the Breadcrumbs builder to build in navigation between the Summary and Drilldown builders.
Question: How do I remove columns from the Summary and Drilldown chart and table?
To hide columns in a chart:
In the Summary and Drilldown builder, go to the Summary Chart Properties section. Set Column Selection to "Exclude specific columns." This will expose the Columns For Y-Axis input. Any columns you enter here will be hidden. To add a column, click on the row to enable the drop-down list, and select the column to hide from the drop-down list -- do not use the reference chooser (... button). You can hide as many columns as you wish by adding them to this list. For best results, your data should have a schema. Hiding a column in the chart does not affect how columns are displayed in the table.
To hide columns in a table:
Add a Data Column Modifier builder to your model. In the Data Column Modifier builder call, set Container Field to the Row of the table created by your Summary and Drilldown builder. This will allow you to control how the table's columns are displayed. To hide a column, set its Status to Hide. Hiding a column in the table does not affect how columns are displayed in the chart.