topic Re: range sum of object in App Development

range sum of object

zied_ahmed1 — Tue, 23 Feb 2021 11:27:24 GMT

Hello Everybody,

I need to do range for this object :

For example i have a bar char with these date , I need to do the sum of these object like in the photos (In 2021-03 i will have 46 (3+7+36)

Thanks

Re: range sum of object

zied_ahmed1 — Tue, 23 Feb 2021 13:56:12 GMT

Hello I have 2 dimensions i used this set analysis but in 2021-10 and 2021 the value is not ok :

Aggr(
RangeSum(Above(
Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,NUMERIC, ASCENDING))

Any ideas please

Re: range sum of object

Chanty4u — Tue, 23 Feb 2021 14:04:59 GMT

try now

Aggr(RangeSum(Above(Count({$<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo())), Envirement, Migration_date,NUMERIC, ASCENDING)

Re: range sum of object

zied_ahmed1 — Tue, 23 Feb 2021 14:08:05 GMT

Thank you but it doesn't work 😕

Re: range sum of object

zied_ahmed1 — Tue, 23 Feb 2021 14:16:36 GMT

@sunny_talwar

Re: range sum of object

Chanty4u — Tue, 23 Feb 2021 14:18:17 GMT

may be any one of it

Aggr(RangeSum(Above(Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,(NUMERIC), ASCENDING))

aggr(rangesum(above((Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name]),0,RowNo())),SecondDim,FirstDim)

Re: range sum of object

zied_ahmed1 — Tue, 23 Feb 2021 14:32:45 GMT

Thank you but it doesn't work with these two set analysis

Re: range sum of object

Chanty4u — Tue, 23 Feb 2021 14:34:33 GMT

can you attach sample?

one sample i attached check that aswell