want to calculate the cost of each request closed in 2024 and display on the dashboard in a barchart
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
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 cost of request closed for 2024 .. .. Sample graph which we want to achive is attcahed below ..
