I'd like to make a chart that shows the number of orders in Hold status at the beginning of each month.
Jan | Feb | Mar
11 | 5 | 8
I can tell how many units are currently on Hold, but I can't find a way to see how many were on Hold last month or the month before. Is there a way to do this in OBIEE?
If you don't keep the history in your data model there is no way that OBIEE (a pure reporting tool) allows you to show an information that is not existing in the database.