How do I create a waterfall graph with a start and finish value?

Question

Hi,

I'm using Oracle Business Intelligence 12.2.1.0.0.

I'm trying to create a waterfall graph that has last year's revenue at the start, this year's revenue at the end, and the difference in revenue by product in between to show what has increased and what's decreased. Is this possible?

So far I've only been able to get the revenue by product working but can't see a way to include a start (previous year) and finish (current year) value.

Any help would be appreciated.

Adam

Robert Angel · Answer

As I said just use some extra logic to create a new field, turning your Jan:Dec into (say) 2:13 and your start period / end period to 0 and 14, job done!!

Adam_K · Answer

Thanks Robert! Using union has allows me to get all of the measures I need into the graph. I'll now try to find a way to order them correctly.

Robert Angel · Answer

Not knowing your data structure - but suspect you can use union functionality to sit your start and end figures in the same 'column' as your period movement figures, you probably also need some additional logic to add to give you 'sensible' sorting, maybe using bins or a case statement to put your now non-calendar in the correct order for your purpose.