JQL make test plan report

[Shin-Yu Wu]

Hi,

I am new to JIRA

I want to make a report form in confluence that will calculate how many test cases were conducted per day, the report looks like this:

I tried:

project = ProjectsA AND issuetype in (Test Case)

But I don't know how to add those case numbers from the test plan

[Jack Brickey]

are you using any test case management SW? You cannot achieve that goal with just JQL.