dates

[userid128223]

Hi I have 2 set of dates in Chart with all the data.  Date1 & Date2

1) How can i connect or map both dates to one calander or dates input box for selection.

2) How do I filter dates via check box to show one and not the other and vice versa. Example if i select check box to show date 1 and exclude date 2.

[userid128223]

Table

Date 1 | Date 2 | revenue | cost | margin

1) I have created master calander based on date 1. however date 2 data goes missing if the it falls before or after Date 1 criteria. Hence How can i create a calander that will be based on Date 1 & Date 2, so when i select any date both Date 1 & Date 2 is represented in charts. Nothing is missing.

2) How can I turn off Date 1 or Date 2 from selection via conditional object like checkbox.