If a column or row in the report does not have a corresponding value, it will be omitted.

[mugi-san]

If a column or row in the report does not have a corresponding value, it will be omitted.

Users don't like the default collapsing because they want to see all elements that match the filter criteria,

even if the count is 0. Is there a way to toggle this collapsing to non-collapse?

[mugi-san · Accepted solution]

Hello, Everyone.

When using Trend by, I was unable to find a way to prevent the omission of columns and rows.
However, by accounting for attribute conditions, it is possible to ensure that they are displayed in the columns and rows, exactly as introduced by @Bhuvan  .

Filtering in the report on a particular column containing empty values will not provide expected res...

regards.