Hello,
Using a DMR model, my report shows a combination chart of monitor sensor values (series) and month (categories). Drilling on the month (to the date) works but doesn't display the dates where there are no sensor values. I'd like to have all dates shown on the x-axis with no bar shown (see picture and notice December 1, 4, 8... are missing).
In the model I have a left outer join between my time dimension table and my daily fact table. I have tested this on a non DMR model and it works fine but I can't find a way to have the dates displayed using DMR.
Any suggestion?
Thanks for your help.