04-05-2023 08:05 AM - last edited on 05-24-2023 08:20 AM by JackLacava
Hi,
Is there a way to show a prompt for a dashboard ONLY during the first time the user opens the particular dashboard? User will provide some POV and this should be saved to be used by the dashboard everytime the user opens it.
I am thinking of creating a custom table on the database that gets populated with the username, and the POVs that the user chose.
It would be best if I can make use of the dashboard parameters prompt, and just create a rule to (1) check if the user has an entry on the custom table, (2) do not show the parameters prompt if the user has entry.
Thanks!
Thanks!
04-05-2023 01:35 PM
A custom DB table [username][povstring] and a dedicated Parameter is the way I would go. Do the lookup
select COALESCE(povstring, "") as povstring where username={si.UserName}
when launching the dashboard where the POV gets used.