-
1. Re: Am getting error as 'argument to count is already an aggregation '
Shinichiro MurakamiNov 14, 2018 9:24 PM (in response to shwetha parashurama)
Type is conflicting.
Not exactly sure without seeing data ,but try below
Countd (if {fixed [filed you want to count] : countd ([Incident])} > [Repeat Incident Count]
THEN
[filed you want to count]
END)
Thanks,
Shin
-
2. Re: Am getting error as 'argument to count is already an aggregation '
shwetha parashurama Nov 14, 2018 10:53 PM (in response to Shinichiro Murakami)Hi Shin,
I tried changing the calculation as below
Countd (if {fixed [Number] : countd ([Number])} > [Repeat Incident Count]
THEN
[Number]
END)
Now, no error but am getting zero value for everything which is not correct.
Regards,
shwetha
-
3. Re: Am getting error as 'argument to count is already an aggregation '
Shinichiro MurakamiNov 14, 2018 11:01 PM (in response to shwetha parashurama)
{fixed [Number] : countd ([Number])} = always 1.
please attach sample data as twbx.
Shin
-
4. Re: Am getting error as 'argument to count is already an aggregation '
shwetha parashurama Nov 15, 2018 12:03 AM (in response to Shinichiro Murakami)Hi Shin,
Thank you so much for your reply.
Am not able to attach twbx file. So i have attached screenshot below.
Here requirement is to calculate ->sum of incident which increased threshold level(Parameter Repeat Incident Count) / Total Incident.
for ex: here for september month
sum of all those numbers which increased threshold level(4+4+4+6) / Total incident(109) [screen shot 2].
Please let me know if you need more details