Filter Time Elements [BIME TIP]

There are so many things you can do with Bime but this week we've chosen to focus on one of Bime's cool pivot table features: filtering time elements by picking 2 dates from a calendar. But that's just the start.. Let's walk through a simple analysis.

Create your dashboard and include time data on the columns axis. Say you don't want to simply filter by month; you want very precise and accurate data analysis between two specific dates. Click the arrow attached to your time dimension to display your data range filter options.

range.jpg

The drop-down menu from each date tab allows you to select specific years, months etc. to focus on a particular period.

In addition, you have ability to 'change time level' to show different periods from those automatically assigned, including half-years, quarters, weekdays, or if your data is especially high level, even hours, minutes and seconds!

timedetail.jpg

The running total function is also accessed from here. This allows you to undertake calculations on a cumulative basis. At its simplest, in the grid view, this changes your figures from those relevant to the stated period to cumulative figures over the whole period shown, on a row-by-row basis, but it is available in all visualizations if required. Look at it in action with the column chart for example:

withrunning.jpg

And compare it without the running total function applied:

withoutrunning.jpg

It's features like this which make a huge difference to the quality of your analysis and reporting, and with Bime we are pleased to say that you can go that one step further and really drill into your data at the high level it deserves.

Tweet