Add row numbers to pivot rows

[irismaessen]

We have on a dashboard a pivot with a single row grouping value but many rows and many columns.  For the readability of the pivot, I'd like to provide my user with row numbers that don't move when the sorting of the pivot is changed. (So the first row of page 1 always has row number 1)

I need both the sorting functionality of a Pivot widget, and to be able to drill/jump using JTD, so I don't think BloX is suitable for this.

Is there any way to achieve this? 

[Helena_qbeeq · Accepted solution]

Hi @irismaessen 

I think you can achieve your end result with the following workaround.

First, duplicate the first row dimension, and rename it to Row for example.

Then, add the following script to your widget.

It will then overwrite the cell values with their row number.

widget.transformPivot({
   type: ['member']
}, handler);

function handler(metadata, cell) {
	
	if (metadata.type=='member'&&metadata.index == 0&& metadata.rowIndex >0) { //only changes for first column, value rows.
     cell.content = metadata.rowIndex; 
	 
    }
}

Here is an example of the end result:

Please let me know if this works for you : )

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

[irismaessen]

That works like a charm! Thank you!

Iris

[SirFabTheGreat]

I get this. I was hoping to get a row number for every single row if that makes sense.

[Helena_qbeeq]

Hi @SirFabTheGreat ,

The provided script will only work if you ensure that that first column is "unique".

If you could concatenate the candidate_id and the branch for example, and add that column as the first column, it would then be overwritten with the row number.

Please let me know if this works for you : )

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

[SirFabTheGreat]

 Thank you very much.