Trellis chart - how to forcibly display all segments?

[datanibbler]

Hi,

my question is largely in the title:

- I have successfully made a combochart with data from an Excel sheet into a Trellis_chart with four segments

<=> For this week (the standard_selection is the_last_week on a Monday and the current_week from Tuesday on), there is data only
       for one of the four dimension_data_points which my Trellis_option is based upon
     => With the standard_selection, only one of the four segments is displayed which looks a bit weird.

=> Is there a way to forcibly display all segments of a Trellis_chart, even if there is no data for the current selection?

Thanks a lot!

Best regards,

DataNibbler

[christian77]

Hi.

Try, if(is null(expression),0,expression).

Show ceros.

Salutes.

[datanibbler]

Hi Chris,

the first thing you suggest is like a Dummy_formula, yes? I've tried that in both ways, by

     - putting this IF_construct in the actual expression

     - creating an additional Dummy_expression that can always be displayed (no conditions)

<=> Unfortunately, that doesn't work yet.

=> Which "show zero values" do you mean? I've tried several. No success yet.

Thanks a lot!

Best regards,

DataNibbler

[datanibbler]

Hi,

this seems to work now 😉

I noticed there was something wrong in the loading script: In a series of LOADs and RESIDENT LOADs I had there, the data seems to have been concatenated erroneously. I introduced an explicit naming of the table_to_concatenate_to, now it seems fine.

Best regards,

DataNibbler

[christian77]

Hi.

There is a checkbox on Presentation tab that Suppresses Zero Values. Sometimes is convenient not to have that checked.

Chris.