BellaDati allows you to add to each axis multiple:

    • Date Aggregation
    • Drill-down path

    Click on Add time or formula or Add drill down path links to place them onto the axis.

     

    Adding Date Aggregation to the Axis

    To add date aggregation:

    1. click on Add time or formula link
    2. click on newly added Times and formulas
    3. select Add time interval

    You can place following date aggregations on the axis:

    • Time Series
      • by Days - displays axis with all days from the data set or days from the date filter (1/1/2013 - 1/3/2014)
      • by Weeks - displays axis with all weeks from the data set or weeks from the date filter (1/2013 - 48/2014)
      • by Months - displays axis with all months from the data set or months from the date filter (1/2013 - 8/2014)
      • by Quarters - displays axis with all quarters from the data set or quarters from the date filter (I/2013 - III/2014)
      • by Years - displays axis with all years from the data set or years from the date filter (2013 - 2014)
    • Date Units
      • Day of Week - displays axis with days of week (Su - Sa)
      • Day of Month - displays axis with days of month (1 - 31)
      • Day of Year - displays axis with days of year (1 - 366)
      • Week of Year - displays axis with weeks of year (1 - 53)
      • Month of Year - displays axis with months of year (1 - 12)
      • Quarter of Year - displays axis with quarters of year (I - IV)
      • Year by Weeks - displays axis with years taking in consideration to weeks (2013 - 2014)

    Additionally, you can place following time aggregations (if available):

    • Time Series
      • by Seconds - displays axis with all seconds from the data set or seconds from the time filter
      • by Minutes - displays axis with all minutes from the data set or minutes from the time filter
      • by Hours - displays axis with all hours from the data set or hours from the time filter
    • Time Units
      • Seconds of Minute - displays axis with seconds of minute (1 - 59)
      • Minutes of Hour - displays axis with minutes of hour (1 - 59)

     

    Changing date format

     

    Icon

    This feature is available since BellaDati 2.9.4

    It is possible to change the format of the date when date aggregation is used. To change the format, edit the Time interval and specify the format in the Options box. The format is specified by using standard date format string (e.g. dd/MM/yyyy). This function is available only when Simple value appearance is used.

     

    It is also possible to use @l to get the last day of each date aggregation unit (e.g. last day of each week). For example, by using format dd/MM - @l/MM, the labels will display first and last day of each aggregation unit.

    Drill Down Path

    You can add Drill down path from Table settings dialog after selecting Add drill down path.

    From Drill down path dialog you can perform following operations:

    • Add new Drill down path to the view.
    • Mask members with custom URLs
    • Setup Limit for members in the drill down path. Displayed memebers depend on current sorting setup.
    • Select if all values in subset will be displayed.
    • Select if date set custom members shouldn't be displayed.
    • Display Total value. New consolidated element will be added to the drill down path. Input title which will be displayed for total value.
    • Input label which will be displayed instead of blank fields.
    • Format total value's font color, style and background.

     

    Resetting custom drill-down

    Custom drill-down can be reset by clicking on the "Collapse all drill-downs" button or by clicking on a drill-down member and clicking on Reset drill-down.