Tableau :Build Bullet graph | Fundamentals
Please download the dataset Click for dataset You have data about coffee shop sales. You want to compare each product’s actual sales to 0%, 50%, 75% and 100% of its sales quota goal. Display this information in a bullet graph, and then use a calculated field and color encoding to quickly determine whether each product has met its goal. Good luck! Create a view of Sales by Product Type and Product , sorted by Sales in descending order. From the Data pane: Drag Sales to Columns . Drag Product Type to Rows . Drag Product to Rows , placing it to the right of Product Type . On the toolbar, select the descending Sort icon, and click it to sort the products in descending order by Sales . Add Budget Sales (this field represents the sales quota goal) to Detail , and then add a reference line for average Budget Sales for each product. From the Data pane, drag Budget Sales to Detail on the Marks card. At the top of the Data pane, click the Analytics tab to open the Ana...