Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Click on one entry of this table list, to see its columns at Choose Columns. After choosing a column, a third area Choose Function might appear (depending on the data type of your selected column). For example, if you would like to select Year of Credit Applications as a Dimension, you might choose the EventTime column from the Cases table (in the following example, the column Application_Date has been selected). Choose Function allows you to specify your time (as the datatype in this column will be a Date, you can choose between Year, Month, Day, and rounded Years/Months/Days). Click on the right Function or on the right Column, and your selection will be stored at Selected Dimension(s), with the respective PQL query.

 

 

 

 

 

 

 

 

 

You may add as many dimensions as you want to. 

...


On the right side, you will again see the Column selection, as well as the PQL query, that will be created while selecting a table/column/function. Of course, you are free to customize this Formula with any PQL statementShow Functions will give you a list of available functions. Choose one and click on it, to apply this function. It will automatically appear in the PQL query.

...