Hi experts I have a Confiforms with the next structure (simplified, but those are the important field in this case): RECORDSTATEA/0001/2021CURRENTA/0001/2021MOVEDA/0001/2021SUCCESSA/0001/2021SUCCESSA/0001/2021MOVEDA/0002/2021CURRENTA/0002/2021CURRENTA/0002/2021CURRENTA/0002/2021MOVEDA/0002/2021SUCCESS I know easily how to get, with a TableView Merger, the next result, to show information to the different users about the states of their tasks: RECORDSTATECOUNTA/0001/2021CURRENT1A/0001/2021MOVED2A/0001/2021SUCCESS2A/0002/2021CURRENT3A/0002/2021MOVED1A/0002/2021SUCCESS1 But, what I really want to get is an output similiar to the next, simulating a pivot table around the fields Record and State: RECORDCURRENTMOVEDSUCCESSA/0001/2021122A/0002/2021311A/0003/2021041A/0004/2021136A/0005/2021621A/0006/2021200A/0007/2021314A/0008/2021004A/0009/2021012A/0010/2021152 Is that possible with Confiforms? Only Confiforms app, I can't use other kind of add-ons. Thanks in advance.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confiforms - How to get a pivot table around a state field

Sopaboba

Hi experts

I have a Confiforms with the next structure (simplified, but those are the important field in this case):

RECORD	STATE
A/0001/2021	CURRENT
A/0001/2021	MOVED
A/0001/2021	SUCCESS
A/0001/2021	SUCCESS
A/0001/2021	MOVED
A/0002/2021	CURRENT
A/0002/2021	CURRENT
A/0002/2021	CURRENT
A/0002/2021	MOVED
A/0002/2021	SUCCESS

I know easily how to get, with a TableView Merger, the next result, to show information to the different users about the states of their tasks:

RECORD	STATE	COUNT
A/0001/2021	CURRENT	1
A/0001/2021	MOVED	2
A/0001/2021	SUCCESS	2
A/0002/2021	CURRENT	3
A/0002/2021	MOVED	1
A/0002/2021	SUCCESS	1

But, what I really want to get is an output similiar to the next, simulating a pivot table around the fields Record and State:

RECORD	CURRENT	MOVED	SUCCESS
A/0001/2021	1	2	2
A/0002/2021	3	1	1
A/0003/2021	0	4	1
A/0004/2021	1	3	6
A/0005/2021	6	2	1
A/0006/2021	2	0	0
A/0007/2021	3	1	4
A/0008/2021	0	0	4
A/0009/2021	0	1	2
A/0010/2021	1	5	2

Is that possible with Confiforms? Only Confiforms app, I can't use other kind of add-ons.

Thanks in advance.

Accepted answers

Sopaboba

I am going to answer myself.

I solved it this way:

In a TableView Merger, you introduce the following fields:

Field: Record

Field: CURRENT:([count_status.label=CURRENT]), where CURRENT is the label set to the value current in a state field

Field: MOVED:([count_status.label=MOVED]), where MOVED is the label set to the value moved in a state field

Field: SUCESS:([count_status.label=SUCCESS]), where SUCCESS is the label set to the value success in a state field

and so on. And I get the wished result.

Then you can apply CSS to highlight the cells as you want and that's it.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Sopaboba ,

I've got that you want to use only ConfiForms app for the issue and we'll wait for the representatives of their team to post an answer, but in case other Community members will come across this question - it's a common situation that they have two apps: ConfiForms and our Table Filter and Charts for Confluence app.

The latter supports the ConfiForms tables and works with them as with regular Confluence tables.

So, to achieve your goal, you may use our Pivot Table macro:

Mon 7-2.png

Mon 7-1.png

Here you may also choose to show/hide the totals.

Sopaboba

Hi Katerina

Thank you for your answer, but that is not what I am looking for. As I wrote in my question, I can only do it with Confiforms. No other adds are allowed ... unless they're free.

Sopaboba

I am going to answer myself.

I solved it this way:

In a TableView Merger, you introduce the following fields:

Field: Record

Field: CURRENT:([count_status.label=CURRENT]), where CURRENT is the label set to the value current in a state field

Field: MOVED:([count_status.label=MOVED]), where MOVED is the label set to the value moved in a state field

Field: SUCESS:([count_status.label=SUCCESS]), where SUCCESS is the label set to the value success in a state field

and so on. And I get the wished result.

Then you can apply CSS to highlight the cells as you want and that's it.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confiforms