Data Analysis – Simple View Summary

Simple Data Analysis Using View Summary Metrics

Did you know you can perform basic summary metric calculations without having a metric licence in Cradle?

Setting up a view summary metric
View Summary Metric

We all run queries to produce lists of data that match certain criteria.

In the example shown it would be possible to run the query to return only water constituents with the Group set to Harmful. Whilst this would produce useful results,  it may be more important that other items are showing too, so they can be seen in context. By setting a View Summary Metric Operation of count and Action of = with a Value of ‘Harmful’ it is possible to see a simple count of the constituents grouped as ‘Harmful’ in the sidebar.

Read our help for more information about simple Summary Metrics.

 

Quick Data Analysis

What percentage of our windows are mandated to use safety glass?

With a change in the overall cost for safety glass this may be one of the questions asked at the board level. You may now be tasked to provide some quick data analysis. Cradle provides a metrics module which can provide a range of data analysis options.

In this case, applying the coverage metric to the windows in the database, it can be seen that 25% of the windows in the range mandate safety glass. A further 62.5% have it as an option. Therefore, from a costing point of view, the firm must revisit the pricing of a quarter of their range.  Additional work will be needed for those customer or location based offerings.

Showing a simple use of metrics
Simple Metrics – Illustrating quick data analysis

Why windows? We produce biological markers for flu viruses!

For illustration, hopefully this is a simple topic understandable by all. It is an example of quick data analysis. With such a diverse range of customers and industries, it would not be possible to pick a universal example. Metrics that find mean or highest values would not make sense for the above pick-list values, but would be really useful for analysing test results. Read on to discover the full range of metric options in Cradle’s data analysis.