Dashboard/Report - Extract the Value of a RITM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hello Team,
I've a RITM with a question about the quantity of Routers.
I want to create a dashboard or a report where I can sum/have the value of the question for each RITM.
I found something in the tables sc_item_option_mtom_list.do and sc_item_option_list.do, but how can I connect it to RITM? What is the key attribute?
Do you know how I can set up a Dashboard to display the List of RITMs and their corresponding values for each question?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sunday
To sum values in dashboard use an aggregation, this might help you
- Go to Reports > Create New.
- Table = SC Item Option M2M [sc_item_option_mtom].
- Add filter:
- sc_item_option.item_option_new.name = "quantity_of_routers"
- In the Report Designer:
- Type = Chart (Bar / Pie / Pivot) → supports aggregation
- Under Group by → choose request_item (to see RITM-level totals)
- Under Aggregation → choose SUM on the field sc_item_option.value
Important detail
The field sc_item_option.value is stored as string. If your variable is a numeric question type (integer, decimal), you can aggregate directly.
If it’s a text variable, you won’t be able to sum it unless you cast it into a number (via a business rule or transform map).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sunday
Create report on 'sc_item_option_mtom' and select bar visualization type.
Group by 'Parent Item.Number' and Stack by 'Depdenent Item.Question' and use Grouped bars. Use Aggregation as Sum as you want the count for each question related to RITM,
If you want to filter the data for only question 'number of routers' use filter conditions in the condition builder,
You can fine tune the grouping and visualization as per your requirement.
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan