上QQ阅读APP看书,第一时间看更新
Creating lenses
Anutosh Infotech has millions of opportunity records in their database. They want to build a dashboard that will give them business insights into opportunity data. This dashboard should include the following charts and tables:
- A horizontal bar chart for opportunities closed in the current month and grouped by Stage. The chart should show the count of opportunities for each stage.
- A Donut chart for opportunities closed in the last month for each stage. The chart should display the sum of amount.
- A Compare Table for displaying Owner Role versus Account Owner displaying Sum of Amount.
- A Stacked Bar chart for the sum of opportunity amount, which is grouped by Owner Role, Account Owner, and Stage. The table should only show opportunities with Stage Equals to Closed Won, Closed Lost, or Needs Analysis.