![]() ![]() I can see that the total value of the amount field is 6.4 million but more than half of that is contained in one transaction, shown in the maximum value. These values are now shown at the top of the file. I’m going to select Net Value, absolute value, average, minimum and maximum and click OK. If you only want to see a subset of the field statistics while viewing the data you can right click anywhere in the data, and select “Show Field Stats” then pick and choose which values you want to see. Return to the data view by clicking data in the properties window. In the properties pane, click field statistics to create them and have a look at the values which show in the AMOUNT column. ![]() We can get this information from the field statistics. ![]() In this exercise, we’re going to look at the data to get a sense of the number and value of customer accounts.īegin by ensuring the Summarized Transactions database is active and that data is selected in the properties window.īefore we start the stratification process, we need to have a sense of the range of values in our data in order to determine what an appropriate size for each bands is. Stratification is a tool for profiling your data by breaking it up into bands.
0 Comments
Leave a Reply. |