Your data is visually illustrated as a vertical bar chart when you analyze and filter KPIs. You can, however, change the default chart type displayed to best present your data to other viewers or readers.
Select the type of chart you want to use from the first drop-down menu.
- Bar Chart - Use this type of chart to compare or see relationships in your data.
Selecting the bar chart displays the second drop-down menu where you can select the type of bar chart you want to represent your data.
The Bar Chart below shows a comparison of data for two different periods.
- Line Chart - Use this type of chart to show how your data changes over time. You can select to show the vertical or the horizontal line by toggling the icon right beside the Show Label icon.
The Line Chart below show comparisons for two periods.
- Area - Use this type of chart to show the change in quantities over time. An area chart is a combination of a line and bar chart. Data points are arranged and connected by line segments similar to a line graph but the area below the line is shaded.
The Area Chart shows two differing data.
- Pie Chart - Use this type of chart to illustrate your data according to segments as proportion to a whole. The Pie Chart is enabled when the Group By feature is used.
Selecting the Pie Chart displays the drop-down menu where you can select which circle-type chart should represent your data.
- Table - Use the table chart type to arrange your data into columns and rows.
- Number - Use the Number chart option to display data as a big number.
Click the Compare with last period icon at the top right corner of the chart to compare the current data with the previous parallel period.
For example, underneath the big number showing the current data in the last 30 days, the corresponding number for the previous 30 days and the % change between the two data points are displayed.
- Gauge - This type of chart or graph is also known as a dial chart or speedometer chart, which uses needles to show information as a reading on a dial. Use this type of visual representation to display data as key business indicators used in dashboard reports.
The gauge initially starts out as red, becomes yellow, and then green. This fits the scenario where you have a target to meet.
In the example shown in the image below, you are halfway through the target of 23730 (1), so the gauge dial is on the yellow part of the gauge 2). As you approach the target, the dial would move towards the green part of the gauge.
You can also reverse the color order of gauge so that it starts out as green and gradually becomes yellow and then red. This will fit a scenario where you are tracking a budget. Initially the dial will point to the green part, and as you start using up your budget, the dial will approach the yellow and then red parts.
Toggle the circular arrow icon in the image below (1) to reverse the color order of the gauge.
In the example shown in the image below, you have already spent half of the budget, which is 23730 (2), so the gauge dial is in the middle (3). As you spend more, the dial would move towards the red part of the gauge, approaching the limit of your budget.
You can opt to show or hide labels on your chart.
By default, the labels are not shown.
Click the appropriate button to show the labels.
You can further filter your charts using the time dimension filters. By default, charts will display data corresponding to the last 30 days in a daily representation.
The Time Period buttons: Last 30 Days and Daily to display the drop-down options.
The first time dimension (Last 30 days) corresponds to how far back in time the data is displayed. For example, today, last week, last month, last 90 days, etc.
The second time dimension (Daily) corresponds to the time frequency in which the data is displayed. For example, hourly, daily, weekly, etc.
- You can Custom a specific range of dates by clicking the last option of the Last 30 Days drop-down list.
- Clicking Custom displays the Start Date - End Date button.
- Specify a start and end date from the calendar that displays when you click Start Date or End Date.
- The bar chart reflects data filtered for the selected Start and End Date.
Comparisons are dependent on the availability of historical or future data. If no data is available from the previous or future period, there won't be comparisons on your chart.
Your chart will reflect the Time Period filter selection and the number of days PRIOR to your current Time Period filter selection.
If you selected Last 30 days in the Time Period Filter, you will see a comparison to the 30 days prior to the current 30 day period in your chart. If you selected This year, you'll see a comparison to last year. If you created a custom date range that spans 35 days, then the comparison will be to the previous 35-day period.
In the image below, the chart shows a comparison of hourly data of Website Sessions Count for yesterday and the day before yesterday.
Selected Time Period Filters are Yesterday and Hourly (1). Clicking the Compare with Last Period icon (2) updates the chart to reflect two bar colors to distinguish yesterday and the day before yesterday data. The label below the chart shows the date range of the two comparing periods (3).
More actions can be done by clicking the ellipsis button found beside the Save button on the top right corner of the page.
- Copy to Clipboard - This feature allows you to copy the chart to the clipboard and paste it on any document, sheet or slides. A prompt notifies you after clicking Copy to Clipboard that you have successfully copied to the clipboard.
- Download CSV - This feature allows you to download the chart data to a CSV file. This option is disabled when the chart is showing data comparing the current data with the previous parallel period.
- Delete - This feature allows you to permanently delete the chart. The Delete option is disabled if the analysis is not saved.
A chart cannot be deleted if it is being used. Remove the chart from the dashboard before permanently deleting it.
- To save your configured charts, click the Save button on the top right corner of the box.
- In the dialog box that appears, name your chart and enter it in the Title field (1).
- Add your chart to one or more existing dashboards by clicking the Select a dashboard field (2) and selecting an option from the drop-down list. If you do not have a dashboard, refer to the Adding Dashboards section for instructions.
- Click Save (3).
This displays a prompt, informing you that your chart has been successfully saved.
- Clicking Go to Dashboard directs you to the dashboard where you saved the chart.
Clicking Dashboards List directs you the page where all the dashboards you created and others created are listed.
- The Save As button is enabled in charts that have been saved.
- Clicking Save As allows you to save the chart in another Dashboard with the same or a different chart Title. Clicking Save in a saved chart allows you to change the chart Title.
To sign up for a free trial, click here.
Updated 8 days ago