The CreatorCon Call for Content is officially open! Get started here.

Sum of INCIDENTS in a month on the report

Bharath Reddy M
Tera Contributor

Hello Everyone !

 

I have the following requirement, seeking your help to complete that.

We have a Record producer, which logs the records into incident table, on RP we have a variable and it have 5 choice fields, based on this we are supposed to create a report of closed tickets in a month .

You can see the report snapshot below.. We are indicating the product field values with SNOW provided colors and upon each product field we are labeling the number of records closed, but now the requirement is I want to show the sum of all closed tickets based on product value on the top of the each bar for every month

 

What I have achieved,

BharathReddyM_0-1692164365252.png

Requirement 

BharathReddyM_1-1692164664569.png

we can see 37, which is the sum of all incidents. How can i achieve the same.

and this report we are keeping on the dashboard.

 

Expected output 

BharathReddyM_0-1692165169999.png

 

Any help is highly appreciated.

 

Thanks,

 

@Ankur Bawiskar 

 

 

0 REPLIES 0