Based on the region name, the combined field will be created by combining the first three letters from the name of the region with the first three letters of the distribution unit name. Here, the expression used is dimension Region. As can be seen, the combined field has been created using the CASE function. The calculated field that we created looks as shown in the below screenshot. To create a combined field right-click anywhere in the blank space in the Data section and click on the option “Create Calculated Field…” as shown below.ħ. The next steps will create a combined field using the CASE statement which will combine the region and distribution unit names.Ħ. If the default chart type is not a bar chart, then select it from Show Me. We get a horizontal bar chart as can be seen in the following screenshot. To begin with, just drag dimensions Region and Distribution Units into Rows region and measure Distribution Volume into the Columns region.
Moving to the sheet tab, we can find the dimensions and the measure in the dataset present in the respective sections.ĥ. The data gets loaded and can be viewed in the “Data Source” tab as shown below.Ĥ. In this case, the data source type is Microsoft Excel.ģ. In “Connect”, select the requisite data source type. For that click on “New Data Source” in the Data menu or alternatively click on “Connect to Data”.Ģ. To facilitate our analysis, we will create a single field that combines region and distribution unit names. Our goal is to categorize distribution units based on distribution volume. Here, the important dimensions are Region and Distribution unit and Distribution Volume is a measure. The dataset contains distribution volume by distribution units.
We will now demonstrate the use of the CASE function through an illustration. Remember, suitable values should be returned, based on the context, in case of no match. The above syntax is the standard one and here default return means a value that should be returned if no match is found. Hadoop, Data Science, Statistics & others
0 kommentar(er)
