Does anyone knows if it is possible to add a Query Prompt Selector binding to 2 separete Universe Querys that have one prompt in common.
Query 1 (Sales context):
Year, Sales ($)
Current Year, Prompt Enter Month=?
Query 2 (Forecast context):
Year, Forecast ($), Line
Current Year, Prompt Enter Month=? and Prompt Enter Line=?
Component added to Dashboard canvas:
Query Prompt Selector:
The QUERY 1 AND QUERY2 are selected in the Destination queries but I'm facing an error when I publish this dashboard to the Platform.
Do I need to do something else in the Universe? The error said that it can not create an instance.
Or do you know another way to solve this without using the Query Prompt Selector?
Please someone help me!