Variables are used to dynamically load values into formulas and date intervals. 

    Creating variables

    Icon

    Only report author or report editor can create report variables and set their default values. Every other user that has access to the report, can only change report variable values.

    To create a new filter, open the Variables sidebar.

    1. Click on Edit button to enter Variables dialog.
    2. Select which type of variable you would like to create:
      1. Date variable
      2. Text variable
      3. Number variable
    3. Optionally, change the identifier.
    4. Click on Add.
    5. Optionally, select default value. See below.
    6. Optionally, edit the Advanced settings to change the appearance and functionality of the variable. See below.
    7. Save the variable.

    APPLYING VARIABLE AS RELATIVE DATE

    You can also use relative dates in variables. To allow this option, go to Variables and filters, create date variable, go to advanced settings for this variable. 
    This window allows you to:
    • Display default relative dates by selecting option Use relative dates
    • Allow Autosubmit after selection (every timeuser selects a value, the setting will be automatically saved)
    • Select Display mode (Radio, Select, Checklist) 
    • Set Preset values (displayed Name of the value, and Definition of the value - g.e. "now-2d" as the day before yesterday)

    In the definition of the value can be used following date strings:

    Relative dateActual value
    nowCurrent day
    actualDayCurrent day

    actualWeek

    Current week (first day of week)

    For example, actualWeek selected on 21.9.2010 represents date 20.9.2010 (Monday of this week in calendar)

    actualMonth

    Current month (first day of month)

    For example, actualMonth selected in 21.9.2010 represents date 1.9.2010

    actualQuarter

    Current quarter (first day of quarter)

    For example, actualQuarter selected on 21.9.2010 represents date 1.7.2010

    actualYear

    Current year (1st January of current year)

    For example, actualYear selected on 21.9.2010 represents date 1.1.2010

    availableFrom, availableTo

    Represents the first and last available date entry

     

    Relative and absolute 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 quarter 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.
    ModifierValue
    ddays
    wweek
    mmonth
    qquarter
    yyear

     

    TRANSLATING VARIABLES

    It is possible to translate both the name of the variable and the preset values of a date variable. After clicking on the name or the value, users can select the language and add the translation.

    • No labels