Creating a dashboard to visualize the sales comparison between two selected region.
Sample Superstore
- Select Sample Superstore as Dataset i. Use Sample Superstore Dataset ii. Select Data iii. Use Group by from Data Source Table on a Folder to create a folder to segregate the required data for Customer Name and Order ID inorder to organize the data thoroughly.
- Create a hierarchy called Location for the variable Country.
- Create two parameters: Primary Region and Secondary Region with all regions listed in them. Here, primary and secondary region are the two regions where the sales are being compared. i. Create Parameters for Primary Region and Secondary Region ii. Create a Calculated Field for both Primary Region and Secondary Region
- Create a First Order Date i.Create a Calculated Field and name it as the First Order Date
- Create a dashboard i. Align all sheets in the dashboard
- Partition the dashboard to display the below details of Primary Region and Secondary Region
- First Order Date
- Total Sales
- Average Sales per Order
- No. of Customers
- No. of Orders
- No. of Products in Sale