Tags:
create new tag
, view all tags

FluidPivotsPlugin (v.1.7) Test Cases.

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

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2008-04-08 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.