You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

This option is related to views. Always refer to views or particulat view types (table, chart, Geo map or KPI label) before proceeding with this section.

You can access Date interval options from the Add view dialog by selecting the "Date interval" checkbox.

If left blank, view displays values aggregated for the whole date interval.

When multiple date attributes are available, BellaDati will prompt you to choose the desired one.

There are three different types of intervals:

  • absolute - (common setting) displays time from the first to the last day of the selected time unit (granularity)
  • relative - indicates the range of the time interval from actual day according to selected time unit (granularity)
  • custom - allows user to choose the interval on daily basis and keep arbitrary time granularity

You can set up following options:

  • Unit: Granularity of time period. Available options include: Day, Week, Month, Quarter and Year.
  • Interval type: Type of the interval used to restrict data. Available options inlude: Absolute, Relative and Custom.
  • From - To: Starting and ending boundary of desired time period. Format depends on selected Unit and Interval type.
  • Aggregate: aggregates the data according to the indicator's time aggregation type
  • Set according data availability: Populates From and To inputs with frontal date values.

For Geo map and KPI label the Time interval option is available through view settings.

Entering custom date/time values

  • you can enter time (date) absolutely in two different formats: dd.MM.yyyy (e.g. 1.12.2010), or yyyy-MM-dd (e.g. 2010-12-01)
  • it's also possible to enter date relatively:
    • now - represents actual date
    • actualyear - represents the first day of actual year (1.1.20XX). For example actualyear selected on 21.9.2010 represents date 1.1.2010
    • actualquarter - represents the first day of actual quarter (1.1.20XX, 1.4.20XX, 1.7.20XX, 1.10.20XX). For example actualquarter selected on 21.9.2010 represents date 1.7.2010
    • actualmonth - represents the first day of actual month (1.1.20XX, 1.2.20XX, ...). For example actaulmonth selected in 21.9.2010 represents date 1.9.2010
    • actualweek - represents first day of actual week (Monday). For example actualweek selected on 21.9.2010 represents date 20.9.2010 (Monday of this week in calendar)

    • relative and absolute enterig of date can be adjusted by operators using this syntax: date +|- n[d|w|m|q|y], where n is integer, d represents day, w represents week, m represents month q represents quartal and y represents year. We can for example define time in this way:  actualyear + 2m -4d. Today is 21.9.2010, so this value represents 1.1.2010 + 2 months - 4 days, which means date 25.2.2010.

Next Steps

  • No labels