SkyDesk Reports offers a wide range of interactive options on a chart when accessed by a end-user. The options include interactive chart highlighting, changing chart type, dynamic filtering of data displayed, sorting, viewing underlying data, exporting of charts, sharing and publishing. In this section we will discuss about each of these options in detail.
SkyDesk Reports provides interactive on-mouse-over effects in a chart. You can mouse-over a particular data point in the chart to highlight the corresponding point or view the corresponding data as tooltip. You can also mouse-over a data series provided in the legend to highlight the corresponding data series in the Chart. Refer to the following screenshots which exhibit the on-mouse-over interactive option.
When designing a chart, if you have enabledShow Legend Filter option inSettings -> Legend tab (Refer here), a check box next to each legend item will be added as shown below.
If Legend Filters are exposed then users of the chart can dynamically filter the data series in a chart by selecting/deselecting the corresponding legend item connected to the data series. For instance, in a chart that displays date wise sales in each region, if you want to display onlyEast andWest region data, hover the mouse on the legend and deselect theCentral legend item. This removes the Central region data and will dynamically regenerate the chart with the remaining data as shown below.
Incase, if you want to select/deselect all legends items at a time, select the check box provided adjacent to the legend title.
In SkyDesk Reports, chart owners can add User Filters to their charts, to provide dynamic filtering capability to the users. User Filters in a chart enables users to dynamically filter the data displayed in the chart by selecting or deselecting the appropriate values in the filter columns provided.
Following is brief description on how to use the provided user filters for various column types:
Date type columns:
Incase of a user filter on a Date type column, options to select date ranges or a multiple select combo box to select the required dates will be provided to allow users to select values depending on the component type chosen by the chart owner.
To filter displayed chart data using User Filter provided on a Date type column, do the following:
Numeric type columns:
Incase of a user filter on a Numeric type column, a slider or a multiple select combo box will be provided to allow users to select values depending on the component type chosen by the chart owner.
To filter displayed chart data using User Filter provided on a Numeric type column, do the following:
Category(String) type columns:
Incase of a user filter on a Category(String) type column, a single or multiple select drop down box will be provided to select values depending on the component type chosen by the chart owner.
To filter displayed chart data using User Filter provided on a Category/String type column, do the following:
SelectOthers filter item, if you want to display data corresponding to all other remaining items that are not listed in the user filter drop down.
By default, chart data will be sorted in ascending order by the actual values of the Category/Date column i.e., alphabetically [A to Z] if it is a Category/String type column, earliest date to latest date if it is a Date type column. Apart from this, SkyDesk Reports offers various options in charts to sort the axis data, including custom sort, to meet your needs.
You can sort the chart by invoking the Sort option in the toolbar and choosing the appropriate option in the list given. Below is a brief discussion of various sort options available in SkyDesk Reports.
Sorting based on Actual Values:
When your chart contains Category (String) or Date column in one of the axes but not in both, you can sort the chart data based on actual value either in ascending or in descending order.
Steps to sort chart by actual values:
If the axis value is a Category (String) column, then the values will be sorted alphabetically in ascending or descending order based on the option chosen. If itâ€™s a Date column, then the values will be sorted from earliest to latest or the reverse based on the option chosen.
For example if a chart displays total amount of sales in each region, initially the regions are ordered alphabetically in the ascending order. When you sort the chart with Sort By Actual Value - Descending option, the resultant chart will be as shown below.
Sorting by Y or X Value:
When your chart contains Category (String) or Date column in one of the axes and Numeric column in the other, you can sort the values in the String/Date column based on the values in the numeric column. This is called Sort by Axis Value option. This option will be displayed as Sort by Y-value or X-value in the Sort menu, based on whether the Y axis contains the numeric column or the X axis.
Options when Y- axis has numeric column and X- axis has String/Date column:
Options when X-axis has numeric column and Y-axis has String/Date column:
Steps to sort charts by one of the axes value:
For example if a chart displays yearly sales, by default the years are ordered from earliest to latest date. But the data becomes more organized when you sort Date with reference to the sales data in each year. Following screen shot displays chart with date values ordered based on the sales values.
When your chart contains Category (String) column in one of the axes and Numeric column in the other, you can sort the chart based on your own custom defined order. This is called Custom Sort.
For example if a chart displays medals won by each country in Athletics. By default this will be ordered alphabetically in ascending order (like Bronze, Gold & Silver). Using custom sort, you can order the medals in a natural priority order like Gold, Silver and Bronze, irrespective of the alphabetical order as shown below.
Steps to sort chart by your own custom defined order:
Note: TheCustom Sort Order dialog box will list all values in the column. The filter criteria applied on the chart will not be applied here.In case the value is no longer available in the underlying data, you will find an option to delete it from the Charts custom sort dialog.
When you share the chart, the order that you have defined will be set as the custom sort order for your shared users. They cannot define/modify the custom sort order. When you share the data tables to users for creating their own chart, then the user can define their own custom sort order for the chart they create.
Couple of Points to Note on Sorting:
SkyDesk Reports also provides option to sort the Chart Legend. You can sort the legend values by ascending and descending order. You can also apply a custom sort order for your chart legend.
A chart can be easily changed to another chart type any time at a click of a button. Tool bar provides you with the options to choose between Pie, Bar, Stacked Bar, Line, Scatter and Table chart types at the top level. If you do not find the chart type that you are looking for, then click onOther Charts button in the toolbar and select the chart type that you want to apply, from theChart Options dialog box that appears. After selecting the required chart type in the dialog box, clickOK.
In SkyDesk Reports, when you create a Line, Scatter, Bar and Combination chart with multiple Y-axes, by default each Y-column will be plotted in its own axis i.e., with split (separate) axis as shown below. However, you can choose to combine/merge them so that all the Y-columns will be plotted against a single combined Y-axis scale. To merge split axis clickMerge Axis button in the toolbar. SkyDesk Reports provides this as a toggle option to quickly switch between Split and Merge axis modes.
Following screen-shots displays charts, which compares Sales and Cost across date with Merged Axis and Split axis:
Often you need to view the data that makes up your chart. SkyDesk Reports provides two options to view (drill into) the chart data. These options are:
You can view these options by clicking the corresponding chart series.
The View Underlying Data allows you to view the underlying data of the data point. You can click on any data point in the chart to view the underlying data of that corresponding point in a pop up table. You can also view the entire data making up the chart by clicking on the Underlying Data option in the toolbar.
The following screenshot shows the underlying sales data for "Grocery" for the year "2013"
In case you have created a report by joining two or more tables then you can view the underlying data by selecting the tables from the View Data From dropdown. By default the option displaying the base table along with the related tables will be selected. You can also choose to view the individual tables seperately.
The below example shows the View Underlying Data table of a report that was created by joining the Sales table and the Stores table. By default the option Sales and Related Tables will be selected. This option will display the data from both Sales and Stores in a single table. However if you wish to view the data only from the Stores table you can do so by selecting Stores from the View Data From dropdown.
The View Underlying Data table that opens provides options to Show/Hide colomns, search, filter and sort the data displayed. You can also export the underlying data into variety of file formats like CSV, XLS, PDF and HTML.
The Chart Drill Down option enables you to do deeper exploratory analytics on a chart. You can click on any point in the chart and visualize the underlying data points as a new chart. You can configure the drill path as you wish.
To know how to set the drill down path refer to Set Drill Down Path section.
SkyDesk Reports allows you to export charts that you have created into various file formats like CSV, PDF, XLS, HTML or Image files. To export a chart:
In SkyDesk Reports you can easily share charts that you have created, for other users access. You can also set specific permissions on the shared charts, so that the users would be allowed to do only permitted actions when they access the chart. The various share options are provided under the Share menu in the toolbar.
Refer to the topic Sharing and Collaborationto know how to share your Charts.
SkyDesk Reports allows you to publish/embed charts that you have created, into your websites/web pages or as easy to access URLs. SkyDesk Reports also allows you to control the access privileges and permissions provided to the users who access the chart.
Refer to the topic Publishing Options to know how to Publish your Charts.