Story built on linked models fails to display fields. Also can a DataAction be created on linked models?
I have two simple models as follows:
Both models are defined with a time granularity of year, which is limited to 2022.
I have successfully linked these two models based on matches of the following fields:
Next I want to create a story with the following layout
My story correctly displays correctly displays the following columns:
Product from PriceModel
Price from PriceModel
Quantity from QuantityModel
But my story absolutely refuses to display Revenue from PriceModel, even though Show unbooked data is on for all measures.
Is this a bug, or what is the workaround required to display measure Revenue?
Here are the detailed settings in Builder:
Bonus points question: How can a data action be created for a linked model?
A DataAction requires that a default model be specified, and will not allow the use of a linked model.
So how can I create a DataAction for the following: Revenue = Price * Quantity for each product.