Nov
22
Histogram via Index()
Histogram can be created in many ways. The de facto histogram is built with bars. With Index() we can create one a bit more colorful. Click image below to see an interactive version or download the workbook. Will describe how to create this next.
This one is created in Gantt chart, overlaid with boxplot and colored by [Profit]. It is regarding the customer distribution sliced by the number of orders, based on the superstore data set.
The important steps to create the chart are:
1.Create a calc field [CountD of Order] and move it to Columns. Turn it to continuous.
2.Drag [Customer ID] to Detail shelf.
3.Create Index=index() and move it to Rows. Set it to compute use [Customer ID].
4.Select Gantt chart in Marks.
5.Drag [Profit] to Color shelf.
This one is created in Gantt chart, overlaid with boxplot and colored by [Profit]. It is regarding the customer distribution sliced by the number of orders, based on the superstore data set.
The important steps to create the chart are:
1.Create a calc field [CountD of Order] and move it to Columns. Turn it to continuous.
2.Drag [Customer ID] to Detail shelf.
3.Create Index=index() and move it to Rows. Set it to compute use [Customer ID].
4.Select Gantt chart in Marks.
5.Drag [Profit] to Color shelf.