DS.SERIES
Ths function will return the value of the specified measure from the dataseries.
Syntax
Example
Find the Variance between sales values of 2020 & 2021.
Sales (Data Source)
To achieve this, the following formula should be written in the [Sales variance] node:
SUBTRACT
(
DS
._Sum_of_Sales_2021.Sales.
GET
(
CPI
),
DS
._Sum_of_Sales_2020.Sales.
GET
(
CPI
))
Result
Sales Variance
The function will take the respective values from the Datasource and give the result in the visual. By using the DS function we can avoid adding too many Datasource nodes to the ValQ Models.
Last updated