# Need helpppppp
**URL:** https://discuss.elastic.co/t/need-helpppppp/172161
**Category:** Kibana
**Created:** [March 13, 2019, 1:50pm UTC](https://discuss.elastic.co/t/need-helpppppp/172161 "2019-03-13T13:50:22Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@souheil](https://discuss.elastic.co/u/souheil)
#### Post date: [March 13, 2019, 1:50pm UTC](https://discuss.elastic.co/t/need-helpppppp/172161/1 "2019-03-13T13:50:22Z")
okey so i have a problem
i have a colon called EVENT, in this colon contains(failed,success,...) so i want to make a scripted field,
def k=0;
for (int i = 0; i \< doc['event'].length; i++) {
if(doc['event'][i] == "failed"){
k+=1;
}
} return k;
but it always gives me k=1;
i thought i had a problem with the code so i changed planty of time, this is another example
def failed = ;
def tab = ['event'];
for (int i = 0; i \< tab.length; i++) {
if( doc[tab[i]].value == "failed")
failed.add(doc[tab[i]].value)
}
def temp = 0;
for (def inc: failed) {
temp += inc;
}
[//failed.add](https://failed.add)(temp);
return temp;
and always get 1, so to make sure if my code is correct or not i made a
return doc['event'].length;
i got 1 so i have like 3000 lignes but it gives me 1
any tips or solutions
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [March 15, 2019, 9:23am UTC](https://discuss.elastic.co/t/need-helpppppp/172161/2 "2019-03-15T09:23:13Z")
Hello,
From what I understand you're trying to count the number of events that are failed?
You can do this with a simple metric visualization, with a Split by Terms on the EVENT field.
As for the scripted field, you're getting 1 as the result because scripted fields only run in the context of a single document, so they can't access other documents.
If I was wrong in my assumption on how your data looks, please leave an example of a document here so I can help you.
---
### Author:  [@souheil](https://discuss.elastic.co/u/souheil)
#### Post date: [March 18, 2019, 10:23am UTC](https://discuss.elastic.co/t/need-helpppppp/172161/3 "2019-03-18T10:23:45Z")
yeah you re absolutly right, i got that at the end that it runs on a single document
i didn't want to uses visualization because my goal to have every user(with his id) the number of time that he failed.
is there an option of how to get that with visualization.
thank you for replying.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 15, 2019, 10:23am UTC](https://discuss.elastic.co/t/need-helpppppp/172161/4 "2019-04-15T10:23:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.