DS.SERIES

Ths function will return the value of the specified measure from the dataseries.

Syntax

Arguments	Datatype	Description
DS.SERIES_Title	Series reference	Returns the data source value for the mentioned data series

Example

Find the Variance between sales values of 2020 & 2021.

Sales (Data Source)

Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2021	121100	124200	120900	118300	116600	114900	123000	116500	112200	117500	119700	116100
2020	194971	199962	194649	190463	187726	184989	198030	187565	180642	189175	192717	186921

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

73871	75762	73749	72163	71126	70089	75030	71065	68442	71675	73017	70821

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.