Report based on month wise.

SK36
Tera Contributor

Hi

I'm creating report based on Sla breached.

my row is "Has breached"(true & false ) and column will be month wise(Jan, Feb, mar and so on).

How to achieve the columns as month wise ? . Right now I have added "opened" column. but what is the best option for my requirement?

SK36_0-1669011542551.png

 

1 ACCEPTED SOLUTION

Musab Rasheed
Tera Sage
Tera Sage

Hello,

You can create report on 'task_sla' table and type should be 'Trend' and configuration should be something like this

MusabRasheed_0-1669015275052.png

 

MusabRasheed_1-1669015409633.png

Please hit like and mark my response as correct if that helps
Regards,
Musab

View solution in original post

3 REPLIES 3

Musab Rasheed
Tera Sage
Tera Sage

Hello,

You can create report on 'task_sla' table and type should be 'Trend' and configuration should be something like this

MusabRasheed_0-1669015275052.png

 

MusabRasheed_1-1669015409633.png

Please hit like and mark my response as correct if that helps
Regards,
Musab

Can we achieve this thru multi-level pivot table?

Please give a try, I don't think that's possible but give a try.

Please hit like and mark my response as correct if that helps
Regards,
Musab