topic Re: total issue-distinct id in App Development

total issue-distinct id

esraltnl — Tue, 11 May 2021 11:49:57 GMT

Hi everyone,

I have a dataset like the one below.

Month	id	Value
Jan	1	15
Jan	2	25
Feb	2	25
Feb	3	5
Feb	4	10

I want to sum the "Value " according to the distinct id field. First I want to find the total values by months, but then compare the total value over all months. And I want the result as follows. How can I do it, can you help?

month	sum(value)
total	55
jan	40
feb	40

Hope you can help me

Re: total issue-distinct id

Taoufiq_Zarra — Tue, 11 May 2021 12:41:11 GMT

in script ?

Re: total issue-distinct id

esraltnl — Tue, 11 May 2021 14:02:30 GMT

script

data:
LOAD * Inline [
Month,id,Value
Jan,1,15
Jan,2,25
Feb,2,25
Feb,3,5
Feb,4,10
];

set analysis

sum(aggr(sum(Value),id,Month))

Re: total issue-distinct id

MayilVahanan — Tue, 11 May 2021 14:17:32 GMT

Hi @esraltnl

For Total alone, you want to change the value, in that case, try like below

If(RowNo() =0 or IsNull(RowNo()), sum(aggr(sum(distinct Value),id)), Sum(Value))

Re: total issue-distinct id

esraltnl — Wed, 12 May 2021 14:43:13 GMT

Hi @MayilVahanan

thank you for answering