Prompts and parameterization can be used to create more flexible and dynamic PRD reports. Report prompts allow a user to filter report data based on values selected or entered in the prompt display. Query parameters accept the prompt values selected by the user and use those values to filter the report data. PRD offers different prompt display types including: value lists, radio buttons, checkboxes, selection buttons, textbox, textarea, and date picker. Prompt values can be driven by static tables or dynamic queries.
Our clickstream data contains the referring_url
field with values for three referring websites: www.123.com
, www.abc.com
, and www.xyz.com
. We want to give users the ability to filter the clickstream report by the referring website. In this section, we enhance our existing report by adding a list prompt sourced by a MongoDB query on referring_url
.