Creating More Views in Risk Register and Displaying them on BI Publisher

Hello Everyone,

I have a client who needs to represent some of their reports created on OPC but also this includes their risk management input that needs to also be represented as a graph on BI Publisher.

I tried creating another view on the risk register called risk management and typed in their information this way;

Status Month Total

Opened 2 2

Closed 0 0

Overdue 2 2

I did this for another similar data from my client and tried to bring them into BI Publisher but after doing that, the values were displaying zero all through.

Can anyone suggest what i could do to get them displaying the values which i typed into the risk register or even something different i could do?