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.

[Sopaboba · Accepted solution]

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. 

[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:

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.

:)