Friday, September 11, 2015

MySQL connector- Date field settings

When you create your database metric, one of the options is Date field. In this post, we will explain how and why to use it. 

Date field enables KPI Watchdog to identify where on the timeline it should place your data point.

For example, if you want to measure number of registrations during Valentine's day, it will count all database entries from your table Users for February, 14th, and display them on your chart. Therefore it is required to have the field in date/date-stamp format. 

What if I do not select Date field ?

Sometimes you cannot add date field simply because you do not record such date-stamps in your database. In such case, KPI Watchdog creates so-called Snapshot metric.

Snapshot metric obviously cannot get the history data but it starts collecting your data from now on. At the end of each day, it will save the actual status to your KPI Watchdog metric.
It can be of the enormous value in the future for you as it allows you to store the trends and timelines for the metrics without recorded dates. You will not get that with other simple dashboarding tools.