I have a requirement to get the count of Requested and Completed items in a particular date in SharePoint. I was using json to retrieve the data from SharePoint list. Status is a SharePoint List Column which contains Requested, Approved and Completed. I want to get the number of Requested and Completed items on each date and display it in the graph as shown in the image below.
Any help is highly appreciated. Kindly help.