Three new Target Dashboard features to check out in February

Last Updated: Wednesday, February 4, 2015 by Sofi Hjalmarsson






New dashboard wizard

Building a dashboard from a new data set, or a new dashboard from existing data, can take a little time, especially if you’re not used to building lots of charts.

With the new dashboard wizard, which can be found by clicking to add a new dashboard, building a whole dashboard takes just minutes. You just need to pick the KPIs that you want to use, what type of dashboard items you want and click “Create”.

Anything that you create using the wizard can be tweaked and afterwards should you want to – once built the dashboard will work no differently from any of your other dashboards.

Why not log on and give it a try?

 

Calculate variance with our new $var() formula

Variance is a really useful metric in many areas, and one that can be tricky to calculate depending on how your data is structured. In a scorecard you are able to see variance from one month to the next by adding % or delta change to your scorecard display.

However, what if you want to see the variance of a figure over a longer period of time? To achieve this we’ve added a new dynamic formula that will work no matter how your data is structured or how you choose to group it in a chart.

$var([columnID])

 

Using this formula in your data will give you access to longer historical trend, and you can compare the variance calculation to other relevant figures.

Another benefit of having it as a calculation in your data is that you can use it in any dashboard item, such as charts, gauges, table summaries, etc. To create one of your own, just head to the Table Designer and create a new calculated column.

 

New table icons in My Data

You may have noticed that the icons for your data tables in the My Data section have changed. They are now different depending on whether you have a regular table, a dropbox table, a database connection or a connection to another cloud service like Google or SurveyMonkey.

You will also notice that they change colour if there is an error in your table. In the picture above for example, the Dropbox icon has turned red because there’s a problem with the connection to Dropbox.

This changes something that was previously a static icon into something that’s informative and gives you a status update at a glance.