asked on December 13, 2023
I am trying to create a classic pivot where a user has a dynamic column based on a variable of batches and the results of those batches are tied to criteria. These values are a mix of text and numbers, and currently formatted as a string. I do not want to aggregate these values as they should be 1:1 for the test results and criteria, but need to use a pivot to satisfy the variable number of batches. Is there a best way to format these values to see the text and numerical responses? I have tried transforming the value as a property and using customizeCell, but am not able to produce the correct result
⋅ December 14, 2023
Hello, Matthew!
Thank you for contacting us and providing the details about your use case.
Kindly note that you can use the id data type to bind "value_2" field to the "value_1" field.
Then, it is possible to get the id value in the customizeCell function as recordId field of the current data object:
function customizeCellFunction(cell, data) {
if (data.type == "value") {
cell.text = cell.text + " " + data.recordId
}
}
We have prepared a JSFiddle illustrating our approach: https://jsfiddle.net/flexmonster/1h0rxwe2/.
Please note that we have also modified the measure to be the max("value_1").
Hope it helps. Let us know if the suggested approach works for your case.
Kind regards,
Solomiia
⋅ January 9, 2024
Hello, Matthew!
Hope you are having a great week.
Our team is wondering if you had some time to check our previous response. Could you please let us know if the suggested approach was helpful in binding the two fields for use in customizeCell function?
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ January 16, 2024
Hello, Matthew!
Hope you are doing well.
Just checking in to ask if the suggested approach was helpful in binding the two fields for use in the customizeCell function.
Looking forward to hearing your feedback.
Kind regards,
Solomiia