Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

3 calendars in 1 graph

I've a report with 3 calendars:

Order_date

Delivery_date

Invoice_date

and I've to create a bar graph where a sum for each date:

- for how many goods I've received orders,

- how many goods i've delivered,

- for how many good i've billed.

I've tried to build set analysis using in x axis Order_date and with this syntax:

sum(Order_date={'$(Delivery_date)'}>}product_code)

sum(Order_date={'$(Invoice_date)'}>}product_code)

And it doesn't work. How can I solve my problem? Tks

2 Replies
Gysbert_Wassenaar

What you need is a shared calendar. See this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars.


talk is cheap, supply exceeds demand
canmarroig
Partner - Creator
Partner - Creator
Author

Tks!