Epic Status Report

I am in the process of setting up a dashboard in jira to manage multiple squads running sprint
The dashboard should display below data for prev, current and future month (for one quarter)

  1. List of all epic names for each squad
  2. Against each epic, no of stories completed vs planned
  3. Where no of stories completed is more than the planned highlight as green, where the no of stories is less than planned, highlight as. Red

Is the above possible in any out of box gadget or can be built using jql.