How to use two tables in automated indicators on single report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-05-2023 05:45 AM
How to use two different tables in automated indicators and the data should be visible on '%' format on monthly basis. Can anyone help me on this..Thanks in Advance..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2023 11:28 PM
Hi @Sai Rakesh2
Why would you make the calculation: "change field is not empty on case table records / Total number of change on change table". This doesn't make any sense.
But basic, you can just create an indicator source based on the sn_customerservice_case and another indicator source based on the change_request table.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/