Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
Try, if(is null(expression),0,expression).
Show ceros.
Salutes.
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
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
Hi.
There is a checkbox on Presentation tab that Suppresses Zero Values. Sometimes is convenient not to have that checked.
Chris.