Hi all! I’m pretty new to BAQ and Dashboard creation, but I’ve got a dashboard started for our production yield percentages.
I’ve got two queries in the dashboard, and I’m trying to get them to interact with one another. I’m looking to add a field that multiplies our unit cost and required quantity together to get our actual cost. The unit cost is within one query, and the required quantity on another within the same dashboard.
Is it possible to multiply these two fields on different queries together at the dashboard level, or would it have to happen on the BAQ side?