Altair® Panopticon

 

DoNotAggregate

Returns the value of a single row, otherwise null.

This method can be used to display a source table.

Below is a source table showing two fields Number and Arbitrary, with Aggregation set to DoNotAggregate and grouped by the Row field. This means Row is also the Breakdown field.

 

Row

Number

Arbitrary

A

1

3

B

2

2

C

3

1

D

4

0

E

5

-1

F

6

-2

G

7

-3

H

8

0

I

9

0

J

10

0

Sample table

If there are multiple items or rows without any grouping, then the value of the method is just n/a.

 

Sample 2:

Assuming that the same list of numbers has multiple groupings or breakdowns as shown below.

Grouping

Arbitrary

1

3

1

2

1

1

1

0

2

-1

2

-2

2

-3

3

0

3

0

3

0

List of values with groupings

Computing for the Count based on the Grouping field yields the following results:

Grouping

Arbitrary

1

4

2

3

3

3

 

Sample 3:

Given the following sample fields:

Number

Arbitrary

Negative Values

Positive Values

One

Binary

Currency

Decimal

1

3

-1

1

1

0

$1.00

1.01

2

2

-2

2

 

1

$10.00

2.02

3

3

-3

3

 

0

$100.00

3.03

4

0

-4

4

 

1

$1,000.00

4.04

5

-1

-5

5

 

0

$10,000.00

5.05

6

-2

-6

6

 

1

-$1.00

6.06

7

-3

-7

7

 

0

-$10.00

7.07

8

0

-8

8

 

 

-$100.00

8.08

9

0

-9

9

 

 

-$1,000.00

9.09

10

0

-10

0

 

 

$0.00

0.00

Sample fields

Number

Arbitrary

Negative Values

Positive Values

One

Binary

Currency

Decimal

10

10

10

10

1

7

10

10

Final results