want to calculate the cost of each request closed in 2024 and display on the dashboard in a barchart

[yadavanushree27]

Hi , Good Evening

I have the total cost and have the avg cost of closed request in 2024  and want to  show the cost of requests closed in each month eg 15 records closed in jan so 15*avg cost amount  should be seen for jan for 2024 in a bar chart using performance anylatics using time series.

[Bhuvan]

@yadavanushree27 

Have you created automated indicators to calculate total cost and average cost ?

You can create formula indicators if you are using automated indicators to get this information. Refer below section for formula indicators,

https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/performance-analytics/concep...

If your requirement is different, please share more information how data is stored and calculated.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan