Create Report & Dashboard for trigger logic processed in Decision table based on Intake form inputs?

[VullankiL]

Hi,

I’m working on a use case where "Programs" (stored in a custom table) are triggered based on Record Producer intake variables.

Current design:

• Users submit a Record Producer (Intake Form)
• Intake variables are evaluated using a Decision Table
• Based on the decision table output, one or more Programs get triggered and will be added in a List collector field
• The trigger logic works correctly, and data is present in the Decision Table

Challenge: I need to build Report and Dashboard showing:

• Which Programs were triggered
• Based on which intake variables
• Conditions between variables (AND/OR)
• Frequency / trend of Program triggers

However, Decision Tables are not directly reportable, and the evaluated results are not stored by default.

Question: What is the recommended approach to store Decision Table evaluation results so that:

• Each intake submission and its evaluated result is captured
• Reports and dashboards can be created 

Any best practices or sample design suggestions would be really helpful.

Thank you!

[Mark Manders]

Those are meant to run your logic, not to be reported on. Your report should be on the input (intake form) and the output so you can see what the logic did. It doesn't really make sense to report on how the decision was made. What is the business case? Who is asking this?
You already have the programs (they are in the list) and you have the input. 

When you report on SLA you also report on the results, not on the logic that is handled within the SLA engine.

[Ankur Bawiskar]

@VullankiL 

I agree with @Mark Manders