Cedar Quay Equipment needs a weekly sales review for its retail director. Orders can contain several item categories, and returns must remain distinguishable from completed sales. Build the channel review, define total profit and margin, then save a regional dashboard with the requested completed-order filter. Keep your working model between steps. The final deliverable is a dashboard definition whose metric and population can be reproduced.
Cedar Quay Equipment needs a weekly sales review for its retail director. Orders can contain several item categories, and returns must remain distinguishable from completed sales. Build the channel review, define total profit and margin, then save a regional dashboard with the requested completed-order filter. Keep your working model between steps. The final deliverable is a dashboard definition whose metric and population can be reproduced.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Group order revenue by sales channel.