If you are sure your calendar will have all possible days then, right join to the calendar
Load * from TransactionTable;
Load * yourCalendar;
Make sure you have a "Day" field and use that one in your chart. You can also uncheck "Suppress missing values" and Suppress Zero values so you see the day even if you don't have data.
I have found out, simply by taking out the redundant LOADing of the date_field as %Datum (the field from my master_calendar which I usually use to link new tables to it), that the dates between tomorrow and Friday are not available in my fact table.
<=> Still, if I use that field to link the table to the master_calendar, shouldn't I be able to use the date_field %Datum (from the master_calendar) as a dimension and have all days displayed, even the days after (today) for which quite naturally there is no data in my fact table?
I have compared this to another diagram - which happens to even be based on the very same fact table:
- There is no data in that fact table for tomorrow and the days after, of course
<=> via the link to the master_calendar (which runs up to Dec 31 of next year), I can display those dates
- The dimension is typed in exactly the same way
- I have compared the settings on both the "Dimension" tab and the "Presentation" tab of the dialog
<=> I have no clue what is the problem this time...
Does anyone have an idea that might help me here?
Thanks a lot!
P.P.S.: Oh - could it have to do with the fact that all my formulas include a set_expression >>> Date < (today) <<<?
- I have included that because part of the data is available for (today), but other parts are not - I end up with wrong results if I have it all displayed for (today)
P.P.P.S.: Yep - that was it. I just have to find out how to include a formula (to display without date_limitation) that won't do any harm...