Remove useless aggregation columns

posted on March 21st, 2023

Answered

Lorenzo Paraboschi asked on March 21, 2023

Hi,
how can you prevent FM from showing empty columns when using aggregations?
You can see from the attached screenshot that only 4 out of 9 columns contain/could ever contain values.
This behavior takes up a lot of screen.
The example always uses the same measure, but first as sum, then as the row difference, and then as the % row difference.
Being a difference the first column of each measure will always be empty, how can I hide these colums?
Thank you,

Lorenzo

Attachments:
FM_useless_columns.png

1 answer

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ March 22, 2023

Hello Lorenzo,

Thank you for reaching out to us.

There are two reasons why some columns are empty:

Columns #6 and #9 from your screenshot are 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.
Columns #2, #5, and #8 are empty when the '[Measures]' are in the first place of the columns array. Flexmonster shows the Totals column, which is empty when columns are switched off. As a possible solution, we suggest different visualization when the '[Measures]' are the last element of the columns array as follows:

columns: [{
     "uniqueName": "Anno"
   }, {
     "uniqueName": "[Measures]"
}]

Please let us know if it works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Remove useless aggregation columns

1 answer

Please login or Register to Submit Answer