asked on May 12, 2023
Hello,
When doing a difference of row value the initial difference is always going to be empty is there any way of hiding the initial difference e.g. see attached image.
Kind regards,
Craig Button
⋅ May 15, 2023
Hello Craig,
Thank you for reaching out to us.
The second column from your screenshot is intended to be empty when using the row difference aggregation since 2022 is the first member. Currently, there's no feature for hiding such columns.
Feel free to contact us if other questions arise.
Kind regards,
Nadia
⋅ May 16, 2023
For other peoples reference, I have fixed this by changing the width of the column to 0 (as I know the column and tuple to alter programmatically)
tableSizes: {
"columns": [
{
"tuple": [
<tuple>
],
"measure": {
"uniqueName": <measure>,
"aggregation": "differenceofrow"
},
"width": 0
}
]
}
This won't affect charts (A third party charting library can be used instead) but will hide it from the grid view.
Kind regards,
Craig Button
⋅ May 17, 2023
Hello Craig,
Thank you for sharing your solution.
We are glad to hear that it works for you!
As always, feel free to contact us if other questions arise.
Kind regards,
Nadia
