Conditional data summarization-Set deep Data system

Conditional rollup

In a report, you need to summarize data that meets a certain condition. By further modifying the previous example, let's take a look at the conditional rollup.

650) this.width=650; "style=" margin:10px 0px; "border=" 0 "src=" http://www.geezn.com/documents/gez/help/graphics/ 2b49be64-2db0-4806-980a-7bd7f8f03b41.jpg "/>

Production wizard

Append the ' total order price above 10000 ' totals row, and then in the D3 cell input expression: =count (c2{c2>10000}), you can achieve the summary data to obtain the corresponding condition.

650) this.width=650; "style=" margin:10px 0px; "border=" 0 "src=" http://www.geezn.com/documents/gez/help/graphics/ 660ab3a8-9e53-45ad-a230-397cb475d1ba.jpg "/>

Function point description Count ()

We can count an expandable cell or set expression through the count () function, such as an unconditional rollup when the expression is: =count (c2{})

Many times, the goal of the operation is not a collection of all the cells determined by the hierarchical coordinates, but a collection of cells within that range that meet certain criteria, such as the number of regions in this example that require orders to be more than 10000 in total. We introduced the {} operator and entered the conditional expression ' c2>10000 '

The D3 cell expression is: =count (c2{c2>10000}), the result of which is the count value of the region where the data set order Total price is higher than 10000. Count () is a dataset function-range calculation function in the product, please refer to: count () for this function

Chart Software web complex report Design report performance statistics and presentation of data in the report format http://blog.sina.com.cn/s/blog_14c9cd7020102w0a4.html reports storage location http://huba01.bokee.com/.html

This article is from the "66" blog, please be sure to keep this source http://wubaa.blog.51cto.com/10631595/1685508

Conditional data summarization-Set deep Data system