While outliers can reveal all kinds of useful intelligence, such as issues in data capture or associated process patterns, they can cause problems when you are building data visualizations. The most common issue is to do with scale, and we will show you how to solve this in this recipe.
For this recipe, we will make use of inline data loading, which gives us the information on the number of calls made for each month. Add the following code into the data load editor and reload the Qlik Sense application:
Data: LOAD * INLINE [ Month, Date, Calls Jan, 27/01/15, 25 Jan, 28/01/15, 27 Jan, 29/01/15, 25 Jan, 30/01/15, 600 Jan, 31/01/15, 22 Feb, 01/02/15, 20 Feb, 02/02/15, 19 Feb, 03/02/15, 21 Feb, 04/02/15, 1 Feb, 05/02/15, 600 ];