# RANK results in kibana

**URL:** <https://discuss.elastic.co/t/rank-results-in-kibana/219426>\
**Category:** Kibana\
**Created:** [February 14, 2020, 5:54pm UTC](https://discuss.elastic.co/t/rank-results-in-kibana/219426 "2020-02-14T17:54:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yoavb](https://avatars.discourse-cdn.com/v4/letter/y/839c29/32.png) [@yoavb](https://discuss.elastic.co/u/yoavb)\
**Post date:** [February 14, 2020, 5:54pm UTC](https://discuss.elastic.co/t/rank-results-in-kibana/219426/1 "2020-02-14T17:54:17Z")

</div>

Hello,

On kibana 7.4

Please condsider the following case:

I have a json file with 3 column :

> STUDENT DATE GRADE  
> A 01/02/2020 80  
> A 11/01/2020 85  
> A 25/01/2020 83

> B 01/02/2020 88  
> B 11/01/2020 81  
> B 25/01/2020 81

> C 01/02/2020 98  
> C 11/01/2020 91  
> C 25/01/2020 97

I have created a Kibana TABLE visualization which show the results.

Now i need to complete two tasks :

1. To mark if the most current grade per student is the highest  
(i.e: 80=NO , 88=YES , 98=YES)

2. To count how many students improve there results  
(i.e : The count should return : 2 )

Any advise how to do it ?

Thanks  
Yoav

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 13, 2020, 5:54pm UTC](https://discuss.elastic.co/t/rank-results-in-kibana/219426/2 "2020-03-13T17:54:20Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.