4 Replies Latest reply on Jul 7, 2016 10:46 AM by Haroldy Tevaras

# Difference between open and closed

Hi!

I am stuck with this puzzle and Im hoping you guys can help me solve it. I have three dimension--numberid, opened date, & closed date. I have added number of records in the viz because I want to see how many were opened in a certain month and how many were closed that month. I have managed to get them side by side, but now I am hoping they're both part of one graph.

Could you help me figure this out please?

Thanks!

• ###### 1. Re: Difference between open and closed

Like this? You can just choose 'dual axis' from the dropdown of the second pill!

1 of 1 people found this helpful
• ###### 2. Re: Difference between open and closed

Yes! Thank you!!

So as a follow up, how do I make one have a different color?

• ###### 3. Re: Difference between open and closed

Remove measure names from the detail shelf of the second axis and change the color:

1 of 1 people found this helpful
• ###### 4. Re: Difference between open and closed

WONDERFUL!!!

Thanks a whole bunch!