GRAPH_EVOLUTION(CONTEXT, FROM_DATE, TO_DATE, DATA_CODES, [FORMAT=""])

This formula generates GRAPH for a date range with data obtained from one or more DATA CODES. The FORMULA will use all the DATA CODES existing in the specified date range and context

The FORMULA returns an URL that can be invoked to generate the GRAPH "on the fly"

Input Parameters

Parameter	Type	Default	Description
CONTEXT	String		(ADMISSION / CASE) the context in which the DATA_CODES will be searched
FROM_DATE	Datetime		(yyyy-mm-dd) starting date. Can be omitted. Can also use a DATE SCOPE, in which case the first day of the selected scope will be used as FROM_DATE. If a DATE SCOPE is used, the date is calculated taking as reference the date provided in the parameter TO_DATE. For example, if FROM_DATE="7DAYS" and TO_DATE="2021-02-20", then the effective FROM_DATE will be "2021-02-13"
TO_DATE	Datetime	Date of the current TASK	(yyyy-mm-dd) end date. If not provided, the default value is the date of the TASK in which the FORMULA is invoked
DATA_CODES	String Array		one or more DATA CODES. This parameter can be a string (to indicate a single DATACODE) or an array of string where each item will correspond to a DATACODE. Example: ["FEV6","FVC"]. It is possible to split a single DATACODE in several categories. See DATACODE categorization
FORMAT	JSON		JSON expression with formatting options. See GRAPH FORMAT (JSON)

Return value

An URL link to display the generated graph

Execution

On FORM creation
On FORM open
During FORM completion

DATACODE categorization

Sometimes a DATACODE refers to a value that only makes sense in combination with another DATACODE

For example: suppose that we have a patient that has reported the intake of several drugs. The DATACODE with name "DOSAGE" represents the dosage intake of a drug. The problem is that the "DOSAGE" DATACODE may correspond to different drugs and we want to create a different graph for each drug.

In this case we can indicate that the serie must be categorized based on the value of another DATACODE named "DRUG" that should exist in the same FORM than the "DOSAGE" DATACODE.

To indicate that we want to categorize a DATACODE we must indicate the DATACODE name with the following format:

    DATACODE_NAME[CATEGORY_DATACODE=CATEGORY_VALUE]

Where:

DATACODE_NAME: name of the DATACODE whose value will be represented in the graph
CATEGORY_DATACODE: Name of another DATACODE that will be used to categorize the values of DATACODE_NAME in one or more graphs
CATEGORY_VALUE: This value is optional.
- If a value is provided, then the values of DATACODE_NAME will be represented only if there also exist a DATACODE with name "CATEGORY_DATACODE" and it takes the value specified in CATEGORY_VALUE
- If no value is provided, then the values of DATACODE_NAME will be separated in as many graphs as different CATEGORY_DATACODE values exist

Examples

	Description
GRAPH_EVOLUTION("ADMISSION", , TASK.DATE, "FEV6")	Evolution graph from any date in the past until the date of the current TASK. The representation will include a single DATACODE called "FEV6"
GRAPH_EVOLUTION("ADMISSION", , TASK.DATE, ["FEV6","FVC"])	Evolution graph from any date in the past until the date of the current TASK. The representation will include two DATACODEs called "FEV6" and "FVC"
GRAPH_EVOLUTION("ADMISSION", , TASK.DATE, "DOSAGE[DRUG=Augmentine]")	Evolution graph from any date in the past until the date of the current TASK. The representation will include a single DATACODEs called "DRUG", but only if in the same FORM exists a categorizing DATACODE called "DRUG" with value "Augmentine"
GRAPH_EVOLUTION("ADMISSION", , TASK.DATE, "DOSAGE[DRUG]")	Evolution graph from any date in the past until the date of the current TASK. The representation will include a single DATACODEs called "DRUG", but only if in the same FORM exists a categorizing DATACODE called "DRUG". Now suppose that there exist two different values for the "DRUG" DATACODE which are "Augmentine" and "Paracetamol". This means that the graph will include the representation of two series: A serie for for each "DOSAGE" where the categorizing DATACODE called "DRUG" takes the value "Augmentine" A serie for for each "DOSAGE" where the categorizing DATACODE called "DRUG" takes the value "Paracetamol"

Browser not supported