Ever feel like you're drowning in data but still thirsty for understanding? That's where smart visualization tools come in, and one of the most straightforward yet powerful is the KPI chart. Think of it as your data's personal trainer, focusing on the key metrics that truly matter.
At its heart, a KPI (Key Performance Indicator) chart is designed to take a single, important piece of data – a 'measure' – and perform a simple calculation on it. This could be a sum, an average, or a count. For instance, if you're tracking sales, you might want to see the average 'billed amount' from a specific column. It’s about distilling complex numbers into a single, digestible figure.
But it gets more interesting. You can add a 'series' column, and suddenly, that single KPI chart blossoms. Imagine you have a list of client projects, each with a unique matter ID. By adding 'matter ID' as a series, the KPI chart automatically breaks down that average billed amount, showing you the average for each individual matter. It’s like zooming in on specific areas of your data without losing sight of the overall picture.
Who can play with these charts? If you have the permissions to create or edit dashboards and the data visualization module is switched on, you're good to go. And here’s a neat little feature: click on a KPI chart, and it’ll whisk you away directly to the iSheet where that data lives. Super handy for digging deeper when a number sparks your curiosity.
Setting one up is pretty intuitive. You'll navigate to your site, hit 'Add panel,' then select 'Data visualisation.' After giving your panel a title and choosing your data source (remember, KPI charts are specifically for iSheet data), you'll pick your iSheet and the specific view you want to work with. Then, scroll down and select 'KPI Card' as your chart type.
From there, you'll define your 'Value' – that's the core measure you want to calculate (sum, average, or count). If you've opted for a series, you can even get an 'Average (Count),' which tells you, for example, the average number of records per distinct item in your series. It’s a nuanced way to understand distribution.
'Series' and 'Filter' are your optional power-ups. The 'Series' allows you to segment your data, as we discussed with the matter IDs. The 'Filter' lets you narrow down your focus even further, perhaps looking at data only from a specific date range or client type. Once you've made your selections for Value, Series, and Filter, you can hit 'Preview' to see your chart come to life.
It’s worth noting a couple of special cases. If you're working with file metadata iSheets, you might see a 'file status' column available. This can be used across various chart types, including KPI charts, as a category, value, series, or filter. Similarly, you can select 'eSignature' as a source type, and even choose to show the 'eSignature status' directly on your panel. This adds another layer of insight, especially for workflows involving electronic signatures.
And for those managing tasks, you can now use 'Assignee' columns as a series. This means you can see counts, sums, or averages broken down by who is assigned to what. If a task has multiple assignees, the system intelligently handles it. Just remember, if you need to filter for specific assignees, that's best done within the iSheet view itself before you create the chart.
Ultimately, KPI charts are about clarity. They take the guesswork out of understanding your most critical data points, making it easier to track progress, identify trends, and make informed decisions. They’re not just pretty pictures; they’re windows into what’s really driving your performance.
