topic Re: RangeSum() and Peek() -> Not working in Data Load Editor in App Development

RangeSum() and Peek() -> Not working in Data Load Editor

calvintang — Fri, 03 Jun 2022 13:35:53 GMT

This is my script:

Daily_Population:
LOAD

monthname([date_signed]) AS [Month Year],
Count(DISTINCT [PlayerI_D]) as CountofPlayers,
RangeSum(Count(DISTINCT [Player_ID]),peek(CumulativeCountofPlayers)) as CumulativeCountofPlayers

RESIDENT [alpha_fact_client_info]
GROUP BY monthname([date_signed]);

My end goal is something like this:

Month | Population | Total Population (Running)

Jan 2022 | 10 | 10

Feb 2022 | 5 | 15

Mar 2022 | 30 | 45

Apr 2022 | 50 | 95

It keeps throwing me an invalid expression error!

Re: RangeSum() and Peek() -> Not working in Data Load Editor

marcus_sommer — Fri, 03 Jun 2022 14:44:46 GMT

Just do it in two steps - at the first load aggregating the values and within a second sorted resident-load you cumulate the results with rangesum() + peek().

- Marcus

Re: RangeSum() and Peek() -> Not working in Data Load Editor

MarcoWedel — Sat, 04 Jun 2022 14:24:54 GMT

maybe this works for you?

Daily_Population: LOAD *, RangeSum(CountofPlayers,Peek(CumulativeCountofPlayers)) as CumulativeCountofPlayers; LOAD MonthName(date_signed) as [Month Year], Count(DISTINCT PlayerI_D) as CountofPlayers RESIDENT [alpha_fact_client_info] GROUP BY monthname([date_signed]) Order By date_signed;

Re: RangeSum() and Peek() -> Not working in Data Load Editor

calvintang — Sat, 04 Jun 2022 14:26:28 GMT

This worked! Thank you!