FluidPivotsPlugin (v.1.7) Test Cases.

Operations.
- Count
- Sum
- Average
- Min
- Max
- Var
- Dev
Table Origin
- Local
- Extern
Integrations
- With ChartPlugin
Properties
- Visible
- Maxrow
- Maxcol
- Order
- Cachetime
- Ignorecache
On Error
- Wrong table.
Big Example

Assuming the following TWiki tables.

ID	Client	Worker	Effort	Life Time	Date	State
1	Client 3	Worker 3	3	6	2007/6/16	State1
2	Client 3	Worker 3	9	9	2007/4/3	State3
3	Client 2	Worker 2	8	7	2007/8/19	State3
4	Client 4	Worker 1	9	7	2007/11/10	State2
5	Client 1	Worker 2	6	11	2007/2/17	State2
6	Client 1	Worker 1	5	6	2007/12/5	State2
7	Client 4	Worker 1	7	7	2007/1/19	State3
8	Client 3	Worker 2	4	11	2007/11/16	State1
9	Client 4	Worker 3	2	7	2007/2/13	State3
10	Client 2	Worker 2	2	6	2007/12/16	State1
11	Client 3	Worker 2	7	10	2007/3/28	State1
12	Client 4	Worker 3	1	10	2007/12/30	State2
13	Client 4	Worker 2	2	9	2007/11/17	State1
14	Client 3	Worker 2	4	7	2007/10/2	State2
15	Client 1	Worker 2	4	2	2007/10/25	State2

Operations.

Count

You type:

%FLUIDPIVOTS{name="examplePivot1" table="exampleTable1" rows="Worker" columns="Client" data="Client" operation="count"}%

%CHART{type="bar" name="bar1" table="examplePivot1" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Cases" xlabel="Worker" yaxis="on"}%

You get:

Client - count	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	3	1	2	2	8
Worker 3	2	2	0	0	4
Worker 1	0	2	1	0	3
Totals	5	5	3	2	15

Sum

You type:

%FLUIDPIVOTS{name="examplePivot2" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum"}%

%CHART{type="bar" name="bar2" table="examplePivot2" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - sum" xlabel="Worker" yaxis="on"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

Average

You type:

%FLUIDPIVOTS{name="examplePivot3" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="average"}%

%CHART{type="bar" name="bar3" table="examplePivot3" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - average" xlabel="Worker" yaxis="on"}%

You get:

Effort - average	Client
Worker	Client 3	Client 1	Client 2	Client 4	Totals
Worker 1	0	5	0	8	7
Worker 2	5	5	5	2	4.625
Worker 3	6	0	0	1.5	3.75
Totals	5.4	5	5	4.2	4.867

Min

You type:

%FLUIDPIVOTS{name="examplePivot4" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="min"}%

%CHART{type="bar" name="bar4" table="examplePivot4" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - min" xlabel="Worker" yaxis="on"}%

You get:

Effort - min	Client
Worker	Client 1	Client 3	Client 2	Client 4	Totals
Worker 1	5	0	0	7	5
Worker 2	4	4	2	2	2
Worker 3	0	3	0	1	1
Totals	4	3	2	1	1

Max

You type:

%FLUIDPIVOTS{name="examplePivot5" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="max"}%

%CHART{type="bar" name="bar5" table="examplePivot5" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - max" xlabel="Worker" yaxis="on"}%

You get:

Effort - max	Client
Worker	Client 3	Client 4	Client 2	Client 1	Totals
Worker 3	9	2	0	0	9
Worker 1	0	9	0	5	9
Worker 2	7	2	8	6	8
Totals	9	9	8	6	9

Var

You type:

%FLUIDPIVOTS{name="examplePivot6" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="var"}%

%CHART{type="bar" name="bar6" table="examplePivot6" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - var" xlabel="Worker" yaxis="on"}%

You get:

Effort - var	Client
Worker	Client 4	Client 2	Client 3	Client 1	Totals
Worker 3	0.25	0	9	0	9.688
Worker 2	0	9	2	1	4.234
Worker 1	1	0	0	0	2.667
Totals	10.16	9	5.04	0.667	6.649

Dev

You type:

%FLUIDPIVOTS{name="examplePivot7" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="dev"}%

%CHART{type="bar" name="bar7" table="examplePivot7" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time - dev" xlabel="Worker" yaxis="on"}%

You get:

Effort - dev	Client
Worker	Client 4	Client 2	Client 3	Client 1	Totals
Worker 3	0.5	0	3	0	3.112
Worker 2	0	3	1.414	1	2.058
Worker 1	1	0	0	0	1.633
Totals	3.187	3	2.245	0.816	2.579

Table Origin

Local

You type:

%FLUIDPIVOTS{name="examplePivot8" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

Extern

You type:

%FLUIDPIVOTS{name="examplePivot9" table="exampleTable1" web="TWiki" topic="FluidPivotsPluginExtern" rows="Worker" columns="Client" data="Effort" operation="sum"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 2	Client 4	Client 1	Totals
Worker 3	11	8	6	0	25
Worker 2	16	0	6	0	22
Worker 1	2	15	0	5	22
Totals	29	23	12	5	69

Integrations

With ChartPlugin

Remember that you have to set the correct order on {PluginsOrder} in the configuration page, FluidPivotsPlugin should run before ChartPlugin.

You type:

%FLUIDPIVOTS{name="examplePivot10" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum"}%

%CHART{type="bar" name="bar1" table="examplePivot10" data="R3:C2..R6:C6" xaxis="R3:C1..R6:C1" legend="R2:C2..R2:C6" width="400" height="200" ymin="0" ylabel="Effort Time" xlabel="Worker" yaxis="on"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

Properties

Visible

You type:

%FLUIDPIVOTS{name="examplePivot11" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" visible="col"}%

%FLUIDPIVOTS{name="examplePivot12" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" visible="row"}%

%FLUIDPIVOTS{name="examplePivot13" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" visible="data"}%

You get:

Effort - sum	Client
Worker	Totals
Worker 2	37
Worker 1	21
Worker 3	15

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2
Totals	27	21	15	10

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2
Worker 2	15	2	10	10
Worker 1	0	16	5	0
Worker 3	12	3	0	0

Maxrow

You type:

%FLUIDPIVOTS{name="examplePivot14" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" maxrow="2"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Otros	12	19	5	0	36
Totals	27	21	15	10	73

Maxcol

You type:

%FLUIDPIVOTS{name="examplePivot15" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" maxcol="3"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Otros	Totals
Worker 2	15	2	20	37
Worker 1	0	16	5	21
Worker 3	12	3	0	15
Totals	27	21	25	73

Order

You type:

%FLUIDPIVOTS{name="examplePivot16" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" order="max"}%

%FLUIDPIVOTS{name="examplePivot17" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" order="min"}%

%FLUIDPIVOTS{name="examplePivot18" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" order="off"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

Effort - sum	Client
Worker	Client 2	Client 1	Client 4	Client 3	Totals
Worker 3	0	0	3	12	15
Worker 1	0	5	16	0	21
Worker 2	10	10	2	15	37
Totals	10	15	21	27	73

Effort - sum	Client
Worker	Client 1	Client 2	Client 3	Client 4	Totals
Worker 1	5	0	0	16	21
Worker 2	10	10	15	2	37
Worker 3	0	0	12	3	15
Totals	15	10	27	21	73

Cachetime

You type:

%FLUIDPIVOTS{name="examplePivot19" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" cachetime="100"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

Ignorecache

You type:

%FLUIDPIVOTS{name="examplePivot19" table="exampleTable1" rows="Worker" columns="Client" data="Effort" operation="sum" ignorecache="1"}%

You get:

Effort - sum	Client
Worker	Client 3	Client 4	Client 1	Client 2	Totals
Worker 2	15	2	10	10	37
Worker 1	0	16	5	0	21
Worker 3	12	3	0	0	15
Totals	27	21	15	10	73

On Error

Wrong table.

You type:

%FLUIDPIVOTS{name="examplePivot20" table="exampleTable1SOMEERROR" rows="Worker" columns="Client" data="Effort" operation="sum" cachetime="1"}%

You get:

FluidPivotsPlugin error: parameter table is not valid table; the specified table 'exampleTable1SOMEERROR' does not exist.

Big Example

You type:

%FLUIDPIVOTS{name="examplePivot51" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Effort" operation="sum"}%

%FLUIDPIVOTS{name="examplePivot52" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Effort" operation="sum" maxrow="10"}%

%FLUIDPIVOTS{name="examplePivot53" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" maxcol="10"}%

%FLUIDPIVOTS{name="examplePivot54" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" maxrow="10" maxcol="10"}%

%FLUIDPIVOTS{name="examplePivot55" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="data"}%

%FLUIDPIVOTS{name="examplePivot56" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="row" order="off"}%

%FLUIDPIVOTS{name="examplePivot57" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="row" order="max"}%

%FLUIDPIVOTS{name="examplePivot58" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="row" order="min"}%

%FLUIDPIVOTS{name="examplePivot59" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="col" maxrow="15"}%

%FLUIDPIVOTS{name="examplePivot60" table="exampleTable2" web="TWiki" topic="FluidPivotsPluginExtern" rows="Data1" columns="Data2" data="Time" operation="sum" visible="row" maxcol="15"}%

%CHART{type="bar" name="bar59" table="examplePivot59" data="R3:C2..R100:C2" xaxis="R3:C1..R100:C1" legend="R2:C2..R2:C2" width="800" height="200" ymin="0" ylabel="Data2" xlabel="Data1" yaxis="on"}%

%CHART{type="bar" name="bar60" table="examplePivot60" data="R3:C2..R3:C100" xaxis="R2:C2..R2:C100" legend="R3:C1..R3:C1" width="800" height="200" ymin="0" ylabel="Data1" xlabel="Data2" yaxis="on"}%

You get:

Effort - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	16	1	19	4	5	9	17	2	8	0	3	Totals
19	38	38	19	19	57	19	19	38	0	38	19	0	0	19	0	0	0	0	0	0	323
18	36	0	54	18	0	0	18	36	18	0	0	0	18	0	36	18	0	18	0	0	270
17	34	17	17	17	0	34	0	17	17	0	0	0	0	17	17	17	0	0	17	0	221
16	16	16	32	0	0	16	16	0	16	0	32	0	0	0	0	0	0	0	0	0	144
13	13	13	0	13	0	0	0	0	0	13	13	0	0	26	13	0	13	0	0	0	117
14	14	0	0	0	14	28	0	0	14	0	0	14	14	0	14	0	0	0	0	0	112
10	0	0	0	0	20	10	0	0	0	10	10	10	10	10	0	0	10	10	0	10	110
15	0	30	0	15	15	0	0	0	0	0	0	15	15	0	0	0	0	15	0	0	105
11	11	22	0	0	0	0	11	11	11	11	0	0	11	0	0	11	0	0	0	0	99
12	0	0	0	36	12	0	0	0	0	0	0	24	0	0	0	0	0	0	12	12	96
8	8	0	16	0	0	0	16	0	8	0	0	8	0	16	0	0	8	0	0	8	88
7	0	0	0	0	7	0	14	0	7	7	0	14	0	0	0	7	14	7	0	7	84
6	0	12	0	12	0	0	0	0	6	12	6	0	6	0	0	0	0	0	0	12	66
9	0	9	0	0	9	0	9	0	0	0	0	0	9	0	0	9	9	9	0	0	63
5	0	0	5	10	0	0	0	0	0	5	0	0	0	0	0	5	5	0	10	0	40
4	0	0	12	4	0	0	0	0	0	0	8	0	0	0	0	0	4	0	8	0	36
3	0	0	0	3	3	0	0	0	0	0	6	0	3	0	0	3	0	0	3	0	21
1	1	1	2	0	2	0	0	1	0	0	1	2	0	0	0	1	0	1	1	0	13
2	2	0	0	2	0	0	2	0	0	0	0	2	2	0	0	0	0	2	0	0	12
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Totals	173	158	157	149	139	107	105	103	97	96	95	89	88	88	80	71	63	62	51	49	2020

Effort - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	16	1	19	4	5	9	17	2	8	0	3	Totals
19	38	38	19	19	57	19	19	38	0	38	19	0	0	19	0	0	0	0	0	0	323
18	36	0	54	18	0	0	18	36	18	0	0	0	18	0	36	18	0	18	0	0	270
17	34	17	17	17	0	34	0	17	17	0	0	0	0	17	17	17	0	0	17	0	221
16	16	16	32	0	0	16	16	0	16	0	32	0	0	0	0	0	0	0	0	0	144
13	13	13	0	13	0	0	0	0	0	13	13	0	0	26	13	0	13	0	0	0	117
14	14	0	0	0	14	28	0	0	14	0	0	14	14	0	14	0	0	0	0	0	112
10	0	0	0	0	20	10	0	0	0	10	10	10	10	10	0	0	10	10	0	10	110
15	0	30	0	15	15	0	0	0	0	0	0	15	15	0	0	0	0	15	0	0	105
11	11	22	0	0	0	0	11	11	11	11	0	0	11	0	0	11	0	0	0	0	99
Otros	11	22	35	67	33	0	41	1	21	24	21	50	20	16	0	25	40	19	34	39	519
Totals	173	158	157	149	139	107	105	103	97	96	95	89	88	88	80	71	63	62	51	49	2020

Time - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	Otros	Totals
19	38	38	19	19	57	19	19	38	0	76	323
18	36	0	54	18	0	0	18	36	18	90	270
17	34	17	17	17	0	34	0	17	17	68	221
16	16	16	32	0	0	16	16	0	16	32	144
13	13	13	0	13	0	0	0	0	0	78	117
14	14	0	0	0	14	28	0	0	14	42	112
10	0	0	0	0	20	10	0	0	0	80	110
15	0	30	0	15	15	0	0	0	0	45	105
11	11	22	0	0	0	0	11	11	11	33	99
12	0	0	0	36	12	0	0	0	0	48	96
8	8	0	16	0	0	0	16	0	8	40	88
7	0	0	0	0	7	0	14	0	7	56	84
6	0	12	0	12	0	0	0	0	6	36	66
9	0	9	0	0	9	0	9	0	0	36	63
5	0	0	5	10	0	0	0	0	0	25	40
4	0	0	12	4	0	0	0	0	0	20	36
3	0	0	0	3	3	0	0	0	0	15	21
1	1	1	2	0	2	0	0	1	0	6	13
2	2	0	0	2	0	0	2	0	0	6	12
0	0	0	0	0	0	0	0	0	0	0	0
Totals	173	158	157	149	139	107	105	103	97	832	2020

Time - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	Otros	Totals
19	38	38	19	19	57	19	19	38	0	76	323
18	36	0	54	18	0	0	18	36	18	90	270
17	34	17	17	17	0	34	0	17	17	68	221
16	16	16	32	0	0	16	16	0	16	32	144
13	13	13	0	13	0	0	0	0	0	78	117
14	14	0	0	0	14	28	0	0	14	42	112
10	0	0	0	0	20	10	0	0	0	80	110
15	0	30	0	15	15	0	0	0	0	45	105
11	11	22	0	0	0	0	11	11	11	33	99
Otros	11	22	35	67	33	0	41	1	21	288	519
Totals	173	158	157	149	139	107	105	103	97	832	2020

Time - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	16	1	19	4	5	9	17	2	8	0	3
19	38	38	19	19	57	19	19	38	0	38	19	0	0	19	0	0	0	0	0	0
18	36	0	54	18	0	0	18	36	18	0	0	0	18	0	36	18	0	18	0	0
17	34	17	17	17	0	34	0	17	17	0	0	0	0	17	17	17	0	0	17	0
16	16	16	32	0	0	16	16	0	16	0	32	0	0	0	0	0	0	0	0	0
13	13	13	0	13	0	0	0	0	0	13	13	0	0	26	13	0	13	0	0	0
14	14	0	0	0	14	28	0	0	14	0	0	14	14	0	14	0	0	0	0	0
10	0	0	0	0	20	10	0	0	0	10	10	10	10	10	0	0	10	10	0	10
15	0	30	0	15	15	0	0	0	0	0	0	15	15	0	0	0	0	15	0	0
11	11	22	0	0	0	0	11	11	11	11	0	0	11	0	0	11	0	0	0	0
12	0	0	0	36	12	0	0	0	0	0	0	24	0	0	0	0	0	0	12	12
8	8	0	16	0	0	0	16	0	8	0	0	8	0	16	0	0	8	0	0	8
7	0	0	0	0	7	0	14	0	7	7	0	14	0	0	0	7	14	7	0	7
6	0	12	0	12	0	0	0	0	6	12	6	0	6	0	0	0	0	0	0	12
9	0	9	0	0	9	0	9	0	0	0	0	0	9	0	0	9	9	9	0	0
5	0	0	5	10	0	0	0	0	0	5	0	0	0	0	0	5	5	0	10	0
4	0	0	12	4	0	0	0	0	0	0	8	0	0	0	0	0	4	0	8	0
3	0	0	0	3	3	0	0	0	0	0	6	0	3	0	0	3	0	0	3	0
1	1	1	2	0	2	0	0	1	0	0	1	2	0	0	0	1	0	1	1	0
2	2	0	0	2	0	0	2	0	0	0	0	2	2	0	0	0	0	2	0	0
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Time - sum	Data2
Data1	0	1	10	11	12	13	14	15	16	17	18	19	2	3	4	5	6	7	8	9
Totals	51	95	107	97	157	105	103	173	96	71	139	89	63	49	88	88	158	149	62	80

Time - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	16	1	19	4	5	9	17	2	8	0	3
Totals	173	158	157	149	139	107	105	103	97	96	95	89	88	88	80	71	63	62	51	49

Time - sum	Data2
Data1	3	0	8	2	17	9	5	4	19	1	16	11	14	13	10	18	7	12	6	15
Totals	49	51	62	63	71	80	88	88	89	95	96	97	103	105	107	139	149	157	158	173

Time - sum	Data2
Data1	Totals
19	323
18	270
17	221
16	144
13	117
14	112
10	110
15	105
11	99
12	96
8	88
7	84
6	66
9	63
Otros	122

Time - sum	Data2
Data1	15	6	12	7	18	10	13	14	11	16	1	19	4	5	Otros
Totals	173	158	157	149	139	107	105	103	97	96	95	89	88	88	376

-- MariaDelCarmenHuertas - 04 Apr 2008

WebForm
TopicClassification	PluginDevelopment
TopicSummary	FluidPivotsPlugin Test Cases Offline (without FluidPivots)
InterestedParties
RelatedTopics	FluidPivotsPlugin

Topic revision: r3 - 2008-04-08 - PeterThoeny

Account
- Log In
- Register User

Edit
Attach

Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.