Build Custom Charts

Dashboards in Cascade set a real nice tone for different meetings and tell a story about the progress at a high-level! While there are a couple of quick widgets, custom charts provide a BI-Tool alike experience and complete flexibility to help you conduct in-depth analysis by slicing and dicing different types of data, and provide a visual insight with bar, line and pie charts. The different chart types pull up the health or progress of each data all the way from a single KPI to performance of strategic portfolio, thereby letting you deep dive into how aligned you’re with the organization's vision! 

While it’s not mandatory to use custom charts, its ability to aggregate data from various data sources helps you with:

• Flexibility
• Alignment
• Drive strategic decisions

There is a very wide scope of use cases when it comes to building custom charts. It is best to be used when you want to have complete flexibility to conduct an in-depth analysis. You can build custom charts to get insights like 

• best performing plan
• performance of team(s) or individuals, and compare workloads
• project analytics (see Custom Charts: Project Analytics for details)
• track a team's metrics or KPIs
• the health of your tasks or projects
• health or performance of different owners, and make data-driven decisions for resource allocations!
• progress trend of different metrics over time
• understand the correlation between: actions and measures, or teams and actions, or focus areas and objectives, or any combination of data sets that you wish!

Click Dashboards > Add or Configure Widget > Custom Chart, and click Next.

The chart takes the default title "Custom Chart". Click on it to edit the name of the chart! Select the type of chart that you wish - Bar, Line, Double y-axis Line, or Pie charts! 

In most cases, a 

• bar chart is built when looking at the performance across a plan by focus areas, or to understand how individual team members are doing on their respective goals,
• line chart is built for looking at how revenue has progressed over a time period, or the number of tools manufactured in a quarter,
• double y-axis line chart is built to look at how the funding allocations on a goal is distributed across projects, or to understand the profit margin vs the net debt ratio,
• pie chart is built to look at how the progress or performance is sliced across entities!

More details on each type of chart, and their use cases are discussed is in the upcoming articles! 

Click Give Feedback, and fill in the form to share your thoughts - this'll help us improve this feature better! Click Save to add the chart to the dashboard or Cancel to revert!

The chart can take a while to load if you've chosen a breakdown that has lots of data! If there're too many legends that makes the chart look very small in the preview, you can resize them when its added to the dashboard.

How to interpret the data from these charts?

Hover the mouse over the charts to see the progress over different dates. In the case of "line", or "double y-axis line" charts, or when you've chose time in x-axis in a "bar chart", then you can change the date or time (hourly, daily, etc.) ranges by clicking on those components, and view the real-time changes in the chart! Also, in these charts, if you chose Average tracked value of measures in the data arrangement section, then you can toggle the Show target switch to display the target in the charts! This helps you understand how the performance is with respect to the target, and lets you decide further!

With line charts, or when time is chosen in x-axis of bar charts, if you wish to see how your data progressed when compared to a period back in time, then you can click Compare to, and select either year on year, month on month or week on week, and the number of periods to see the visualization accordingly! If you're tracking your company's financial performance like the ARR, market share, net profit, or sales' revenue generated, this "compare to" feature will let you understand the historical trend, and guide you in decision-making!

Furthermore, with bar charts, you've the option to look at the performance of your measures or metrics at a very granular level, i.e., when you choose Average progress of measures (%), or Average tracked value of measure in y-axis, then the Non-cumulative and Cumulative options are displayed which lets you to decide how to represent the measure's progress over time! Throughout our platform, be it manually or with integrations, goalhub, or reports, your data is always calculated cumulatively, and displayed. To help you understand how your measure progressed individually every day, week, or month, like in website's performance, number of tickets handled, NPS, etc., selecting non-cumulative option gives you the clear picture!

With pie charts, hover the mouse over it, or click on the pieces of the pie to see the breakdown of data for each slice.

Click on a bar in bar chart, a dot in the line chart, or a portion of pie in the pie chart to open the chart context table - you'll see the details like owner, due date, progress, health of the objective/measure/action, and the relevant plan! You can sort the fields, the way you want! If the objectives are chosen, you can further expand or drilldown to view its associated success criteria! Click into any of these rows to open the relevant entity from the Sidebar!

Hover the mouse over the widgets, and click the three dots against it, to edit or delete the widget!

What happens once the free trial is over?

You'll still see all the custom charts that you've built over the free trial period, but you'll not be able to edit it unless you upgrade your plan.