Page History
...
| Table of Contents | ||
|---|---|---|
|
...
概要
| Styleclass | ||
|---|---|---|
| ||
When you run a report Yellowfin performs calculations on the data returned from the database. With analytic functions you can further transform your data for analysis purposes by applying predefined calculations.
Functions are similar to aggregate functions. You simply select the field you wish the function to apply to, and choose the function you wish to use.
レポートの実行時、Yellowfinはデータベースから読み出されたデータに対してさまざまな計算を行います。分析関数を使用することでそれらのデータをさらに分析しやすいものに変換することが可能です。
関数は、集計関数と似ています。ユーザーは計算を行いたいフィールドを選び、次に関数を選択するだけです。
利用可能な関数
...
| Styleclass | ||
|---|---|---|
| ||
Yellowfinは既にいくつかの関数を含んでいます。使用する組織やレポートに対する要求に応えるために管理者が関数を追加している場合もありますが、次の項目を展開すると、使用可能な関数の一覧が表示されます：Yellowfin comes with a set of pre-defined functions. However, your administrator may add in additional functions specifically for your organisation or reporting needs. Expand the following to see the lists of functions available:
| Expand | |
|---|---|
|
...
|
...
Decile | Decile divides the rows returned into 10 equal parts, and assigns a value of 1 to 10, based upon its rank to the highest value. Deciles are used as a measure of dispersion. |
Deviation | The number of deviations from the mean. |
Linear Regression | A linear trendline is a best-fit straight line that is used with simple linear data sets. Your data is linear if the pattern in its data points resembles a line. A linear trendline usually shows that something is increasing or decreasing at a steady rate. |
Mean | The arithmetic mean (or simply the mean) of a list of numbers is the sum of all the members of the list divided by the number of items in the list. |
Median | The median is described as the number separating the higher half of a sample, a population, or a probability distribution, from the lower half. |
Mode | The mode is the value that occurs the most frequently in a data set |
Moving Average | A moving average trendline smoothes out fluctuations in data to show a pattern or trend more clearly. |
Moving Total | The total over the last N periods. |
Naïve Forecasting | A naive forecasting model is a special case of the moving average forecasting model where the number of periods used for smoothing is 1. Therefore, the forecast for a period, t, is simply the observed value for the previous period, t-1. |
Polynomial Regression | A polynomial trendline is a curved line that is used when data fluctuates. It is useful, for example, for analysing gains and losses over a large data set. The order of the polynomial can be determined by the number of fluctuations in the data or by how many bends (hills and valleys) appear in the curve. An Order 2 polynomial trendline generally has only one hill or valley. Order 3 generally has one or two hills or valleys. Order 4 generally has up to three. |
Quartile | Quartile divides the rows returned into 4 equal parts, and assigns a value of 1 to 4, based upon its rank to the highest value. Quartiles are used as a measure of dispersion. |
Standard Deviation | The standard deviation is a measure of the dispersion of a set of values. It can apply to a probability distribution, a random variable, a population or a multiset. |
Standard Score | The standard score indicates how many standard deviations an observation is above or below the mean. It allows comparison of observations from different normal distributions, which is done frequently in research. |
Variance | Returns the difference between the data sets. |
Weighted Moving Average | Returns a moving average that is weighted so that the more recent the value, the more weight is applied to it. |
|
| Expand | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
| Expand | ||
|---|---|---|
| ||
|
| Expand | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
|
関数の適用
| Styleclass | ||
|---|---|---|
| ||
- 関数を適用したいアイテムをレポートデータ欄にドラッグします。
- アイテムを選択状態にして関数アイコンをクリックします。
- 「関数」ウインドウが表示されます。関数ウインドウが表示され、そのアイテムに対して適用可能な関数の一覧が種類ごとに表示されます。たとえば日付データを選択した場合、機能を選択・ドロップダウンメニューから「テキスト」「日付＆時間」と「統計」が選択できます。
- ドロップダウンメニューから関数タイプを選択し、適用したい関数を選びます。関数をクリックすると、その説明が一覧の下に表示されます。
- 適切な場合は、集約を選択します。たとえば、収益ではなく、収益の集約に対する現在高を作成することができます。この集計は関数の適用前に行われます。
- 「OK」をクリックして「関数」ウインドウを閉じます。
- レポートを実行すると、関数が適用された結果が表示されます。
関数の削除
| Styleclass | ||
|---|---|---|
| ||
アイテムに適用した関数を削除したい場合は以下のどちらかのようにします。
- アイテムを選択状態にし、クリアアイコンをクリックします。
- レポートデータからアイテムを削除します。
統計関数
| Styleclass | ||
|---|---|---|
| ||
Yellowfinには一連の統計関数が用意されておりレポートのデータに適用することができます。たとえば回帰分析や移動平均などです。これらは分析関数として適用され、以下の例のようにトレンドラインを描き出します。
| Expand | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
| Expand | ||
|---|---|---|
| ||
|
| Expand | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
|
Applying a Function to an Item
| Styleclass | ||
|---|---|---|
| ||
- To apply a function to an item, drag the field onto your report.
- Highlight the item and click the function icon.
- The function popup will open. This will display a range of functions available for the particular function type. For example if you have chosen a date variable then only date functions will be displayed.
- Select the function type and then the specific function. By highlighting the functions available the description will appear at the bottom of the function list.
- If appropriate select the aggregation. For example you can create a running total for SUM of revenue rather than revenue. This will pre-aggregate your data prior to the running total being applied.
- Click OK to close and save your function.
- When you run your report your column will now have the function formula applied.
Removing a Function
| Styleclass | ||
|---|---|---|
| ||
To remove a function from an item, do one of the following:
- Reset the field by selecting the metric and clicking the clear button.
- Remove the item from the report entirely
Statistical Functions
| Styleclass | ||
|---|---|---|
| ||
Yellowfin has a set of statistical functions which you can apply to your data. These include regressions and moving averages. These are applied as analytical functions and can result in trend lines such as the example below.
| horizontalrule |
|---|
| Styleclass | ||
|---|---|---|
| ||