RAG for Quarter over Quarter Comparison

priyankapassi — Thu, 18 May 2017 10:51:59 GMT

Hi All,

I want if total count of primary key is less than total count of Primary key of Previous quarter then mark that row with Green else red.

suppose, if

should return

Thanks in Advance.

Re: RAG for Quarter over Quarter Comparison

Kushal_Chawda — Thu, 18 May 2017 11:31:39 GMT

Data:

LOAD Date,

Quarter,

[Primary Key]

FROM

[Data1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Count:

LOAD Quarter,

Count([Primary Key]) as Countkey

Resident Data

Group by Quarter

Order by Quarter;

Left Join(Data)

LOAD *,

if(RowNo()=1 or Countkey<Previous(Countkey),'Green','Red') as Staus

Resident Count;

DROP Table Count;