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

[Bhuvan]

@yadavanushree27 

Did you get a chance to review this as I believe the information provided should answer your question.

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[yadavanushree27]

Hello Bhuvan, 

Thanks for the link .. 

The details are as follows -

I have created a Job that runs daily to collect the records for 2024 

1 source Indicator with  Frequencey as daily (also tried with Monthly) with conditions as state closed complete and created between 01/01/2024  and 31/12/2024

1st Automated Indicators - which brings the total count of request closed in 2024 ..(Frequency daily )

2nd Automated Indicator with which we want to being the count of request closed in each month in 2024 (which does not give the correct data .. mostly a total value or avg value only we get for all month )

we have a static value 428604.65 which represents the total cost of request raised 2024 

with the formula indicator we do 428604.65/ (1st Automated Indicators - which brings the total count of request closed in 2024 ) .. this gives the avg cost of 1 request 

Now we want that this should be multipled by 2nd automated indicator which should bring the month wise cout of request closed for 2024 .. ..and represent this month wise  values on bar graph     Sample graph which we want is attcahed below .. 

[yadavanushree27]

Hello Bhuvan, 

Thanks for the link .. 

The details are as follows -

I have created a Job that runs daily to collect the records for 2024 .

Also created one source Indicator with  Frequencey as daily (also tried with Monthly) with conditions as state closed complete and created between 01/01/2024  and 31/12/2024.

1st Automated Indicators - which brings the total count of request closed in 2024 ..(Frequency daily )

2nd Automated Indicator with which we want to bring the count of request closed in each month in 2024 (which does not give the correct data .. mostly a total value or avg value only we get for all month )

we have a static value 428604.65 which represents the total cost of request raised 2024 

with the formula indicator we do 428604.65/ (1st Automated Indicators - which brings the total count of request closed in 2024 ) .. this gives the avg cost of 1 request 

Now we want that this should be multipled by 2nd automated indicator (which is expected to bring each month count)  to give the cost of request raised in each month in a bar graph format .   For now we get incorrect values  (mostly avg cost for all 12 month bar graph which is incorrect

 

Sample graph which we want is attcahed  ..