How to represent data in piechart/Linechart which I received by using REST API

[rupesh_patil20]

My data after search has following columns along with the other columns as below

MLS_Number Count
1129078 1
1248955 1
1290591 2
1379041 1
2035500 3
2146693 1
2177466 4
2208748 1
2362548 1
3040705 1
3047234 3
4638653 2

so, on Y-axis it will show Count as 1, 2, 3 and 4
on X- axis I want count of MLS_Number, with respect to Count 1, 2,3,4

eg. here there are 7 records for the count = 1
similarly 2 records for Count = 2 in a such way .. i want to display the data.
Please help me with this..
Thanks Buddy...!!

[somesoni2 · Accepted solution]

Try something like this

your current search generating MLS_Number Count as shown in ques | stats count(MLS_Number) as MLSNumber by Count

[rupesh_patil20]

Hi Somesoni2,

I tried your query and I got the result but the problem arose now is it is giving me repetitive count, for example here there are 7 records for the count = 1, but in the result the count shown as 98550. As I am using REST API for input.. so may be it updates the data continuously.
Can you help me with time stamp, like how I can add it in search to get the exact data.