Creating dashboard prompt with custom datamodel and report

Simon L · Aug 29, 2024 2:54PM

Hi,

I created a report with custom datamodel with 2 prompts.

This is how it looks like.

Datamodel

Datamodel prompts are LOV and SQL query.

Report

With this, I created a dashboard, but 2 prompts are not visible.

Is there a way to get the prompts to work?

Nathan CCC · Aug 29, 2024 3:38PM

Hi Simon,

As Nikki said you can add a dashboard prompt. For that to work the column in the dashboard prompt must be set to a presentation variable with the same name in same case as the parameter in your data model. So SPECILIZATION_NAME. I am confused with you other parameter because you are using a list of values rather than a calendar so not sure it its a date or string.