Question

3. Discuss the cumulative summing relationship

I keep getting the same answers for the question 1 and 3 they can't both be right

Answer 1

Cumulative formulae permit you to compute the average, max, min, or sum or your data over time.It is also known as Running total.Each of the cumulative formulas accepts a measure and one or more optional grouping by an attribute (like region or department):

formula (measure, [attribute, attribute, ...])

The measure value is the only one required. Measure and attribute both should not be supplied as the formula returns the sum total of the measures gathered by the attributes in the order specified.

The cumulative formulas are:

Function	Description
cumulative_average	Takes a measure and one or more attributes. Returns the average of the measure, accumulated by the attribute(s) in the order specified. For example: cumulative_average (revenue, order date, state)
cumulative_max	Takes a measure and one or more attributes. Returns the maximum of the measure, accumulated by the attribute(s) in the order specified. For example: cumulative_max (revenue, state)
cumulative_min	Takes a measure and one or more attributes. Returns the minimum of the measure, accumulated by the attribute(s) in the order specified. or example: cumulative_min (revenue, campaign)
cumulative_sum	Takes a measure and one or more attributes. Returns the sum of the measure, accumulated by the attribute(s) in the order specified. For example: cumulative_sum (revenue, order date)

. To use the cumulative function in a search:

1. Start a new search.

2. 

3. In the upper-right side of the table, click the ellipses icon and select Add formula.

   

4. Enter the cumulative_sum formula, providing a measure and one or more attributes.

   The example will return the sum of revenue, accumulated by the commit date.

   

5. Name the formula by clicking its title and typing a new name.

6. Click Save.

   The formula will appear in the search bar and in the table as its own column.

7. If you are trying to create a measure which performs a cumulative total for two tables ie data table and a table containing measure then active or inactive relationship has to be set. In order to better understand the problem you can attach the screenshot so that we get a clear picture what you are trying to do.