Adding and editing dates

Follow

If your dataset includes dates, you have more options for manipulating your results by adding date-based attributes to your query. In addition to slicing your results by date, you can also limit your results to a selected date range or across a rolling period. For information on adjusting dates to match your calendar see, Modifying your calendar using fiscal attributes

This article contains the following sections:

Adding dates

To be recognized as a date by BIME, a field has to contain at least year, month, and day information. A field containing results like Jan-2014 or Feb-2014 will not be recognized as a date field. While dates can be presented in a variety of different formats, BIME will always convert dates into Date ISO format (YYYY-MM-DD). A timestamp in the field will also be picked up and converted into the YYYY-MM-DD T:00-00-00 format. 
Note: If your connection is a CSV file, you must specify the format of any date field when establishing your connection.
 
To select or exclude dates from your results
  •  Click on the added date attribute.

The date attribute is located on the columns axes of the Query builder. The columns axes is located at the top of the Query Builder, above your chart.

Editing date ranges

Once you have added a date attribute to your query, you can specify the period of time by editing the date range options. You can edit your date ranges by clicking on a date attribute, then selecting Edit date ranges

There are two types of date range options, Simple and Advanced. In the Simple panel, you can select from a list of named periods. You can also select the 'Custom' option to pick a specific calendar start and end date. 

A second panel called Date range will appear next to the date attribute panel, after clicking on the Edit date ranges button. The image shows the Date range panel with the Simple options.

In the Advanced panel, you can choose separate beginning and end dates. For each beginning and end date you can select from a list of named periods, enter in a calendar date, view all history, or select a rolling period. In a rolling period, you can select options like seven days in the past or a year in the future. 

The image shows the advanced Date range options. The first section is 'From the beginning of' and the second is 'To the end of'

You can also repeat the selected range Advanced Add repeat pattern. The repeat option provides a more detailed comparison for period on period results. With the repeat option, you compare to exactly the same point last year. For example, if your range date is 'This year' to 'Today', and today is September 16th, a repeat pattern of 'one year in the past' will compare figures for this year with January 1st to September 16th of last year. Without the repeat option selected, the results would compare the figures for this year with the overall total of last year. 

The repeat pattern window shows the header 'Repeat for' then shows the options listed in the paragraph below. Under the options is a button saying 'Add repeat pattern' and then another button saying 'Apply'.

If you do not have a 24/7 working pattern, you can use the repeat option to look at a single day's results. There are three options for checking your most recent full day of work. 
  • Yesterday will show results for the previous day. This choice is ideal for web analytics or social media tracking. 
  • Yesterday (working day) will show either the previous day's results if the current day is between Tuesday through Saturday, or the previous Friday if the current day is a Sunday or Monday. This suits a Monday-Friday working week for sales teams, order processing, etc. 
  • Yesterday (workable day) will show the previous day's results if the current day is between Tuesday and Sunday, or the previous Saturday if the current day is Monday. This suits shops or call centers that don't operate on Sundays.
Have more questions? Submit a request

1 Comments

  • 0

    I bring several date fields into BIME, all of them without a timestamp. Yet BIME is converting them to datetime in the drill-through function. Is this a bug, and if so is there a work-around to only show the date in drill-through?

Please sign in to leave a comment.
Powered by Zendesk