asked on November 8, 2023
Hi Team,
Is there any way to get all the measure data of a particular column/row inside the customizeCell function?
for example, I have "employee names" in rows, "projects worked" in columns and 2 measures ( count(bugs), count(tasks) ). Can we access both count(bugs) and count(tasks) of "employee A" and "project A" in customizeCell function?
Thanks,
Vignesh K
⋅ November 9, 2023
Hello, Vignesh!
Thank you for reaching out to us.
Could you please provide us with more details about your use case? This will greatly help us to provide the most fitting solution.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ November 24, 2023
In the attached image, I want to apply conditional styling for "Id(count)" column based on "Bugs Closed" values.
for eg., If "Bugs closed" is greater than 35, then highlight the "Id(count)" value by making it bold.
⋅ November 24, 2023
Hello, Vignesh!
Thank you for your reply.
This functionality can be achieved with conditional formatting. Inside the ConditionalFormatObject, set the measure you want to format and use the other measure with the necessary aggregations to set the condition. In the format, set the styles that should be applied:
{
id: 1,
measure: "Price",
formula: 'sum("Quantity") > 100000',
format: {
fontWeight: "bold"
}
}
You are welcome to check the example: https://jsfiddle.net/flexmonster/Ljxgm49a/
Please let us know if this approach would work for you.
Best Regards,
Maksym
⋅ December 13, 2023
Hello, Vignesh!
Hope you are doing well.
Our team is wondering if you had time to test the suggested approach for applying conditional formatting based on the other cell's value.
Please let us know if this solution works for you.
Best Regards,
Maksym