How to show the Year Report where Month wise Job Run count should display

1

How to show the Year Report where Month wise Job Run count with status of Jobs should display.
I tried to use Group by …But some months have 31 days some months have 30 days, So I cant put 30d in Group By, How to handle this?
I used Postgresql as Data Source

Kindly Please help.

Thanks,
Rajesh

2

image
image762×238 19 KB

Here Group by Interval I have put 31d, However different months will have different number of days like 30d, 29 days…So please let me know whether we have option to show month basis count …
like Group by time(1Month,none)

Thanks,
Rajesh