Dealing with dates can be confusing when querying data. Time stamps often need to be converted to more usable minute, hour, day, month, or year fields.
And setting up a trailing date rate (like last 7 days) that is typically means figuring out NOW(), INTERVAL, and CAST functions in SQL.
With our latest release today (1.9.5), Zing does all this for you automatically, configureable with a few taps.
Use relative dates to have a query always return dates in the most recent X days/weeks/months/years, For instance, if you want “Sales of the last 30 days” in SQL you’d select the sum of sales, grouped by sale_time as a date where in the sale_time is within the last 30 days.
With Zing’s visual query editor, you can specify a relative date rage easily:
Optionally, you can choose to group dates by minute, hour, day, month, or year as well.
You can now group dates and timestamps by second, minute, hour, day, month, or year. This makes it easier to aggregate results in a meaningful way and graph them in a way that makes sense.
For instance, for server log data you may want to look at data by second or minute to diagnose when an outage occurred precisely.
But for sales data, you’d likely be more interested in daily or weekly roll-ups versus a second-by-second view (as many seconds might have 0 sales, leading to noisy and difficult to interpret graphs).
Specify date granularity for a question by:
Once you’ve run a query you can display results as a data table.
Zing now supports sorting and filtering data tables in-line. Just tap the column header filter icon:
From here you can filter by:
Multiple filters can be applied on a single column, and filters can be applied on multiple columns at the same time.