Hi All,
I have this Line Graph:
I want to have a 0 instead of a gap in a Line Chart.
For example, on 6/10 the GIFT_D line should continue with the value 0 instead of having a gap, same with 6/23, 6/8, etc...
The ghaph corresponds to this Pivot table (Char Pivoted Results):
The Table view result (I think that if I modify the repository adding a LEFT OUTER JOIN to get for each day all the gift types, it will work. But I don't want to do this because the normal behaviour should be INNER JOIN, this is only a special requirement for a specific report):
So is it possible to get zeros instead of gaps without modifying the repository?
ps. I managed to show zeros instead of nulls in Pivot table but the chart is still showing gaps (http://total-bi.com/2010/10/replace-nulls-in-obiee-pivot-table/)
Thanks in advance,
Regards