13 Replies Latest reply on Aug 27, 2017 1:16 PM by Shinichiro Murakami

# continuous line chart based on monthly

Hi Folks,

I have below request need to produce in tableau. Please anyone guide me how to create a continuous chart in tableau.

Actual Output:

Expected Line Chart:

Message was edited by: Tableau Learner Attached workbbok

• ###### 1. Re: continuous line chart based on monthly

Hey there -- all you need is to change your date field to continuous and you should get the desired result.

~April

• ###### 2. Re: continuous line chart based on monthly

Hi April,

I don't think it might help to my requirement. In my report, I do have other measures and which is Dual Axis need to produce for Business same like below. Profit Ration line need to flow from Start Month to End Month based on User Filter Selection.

Sample Report:

• ###### 3. Re: continuous line chart based on monthly

Hi,

I started to say the same thing April did, but then noticed where 'segments' was on your view.  Why do you want to use a continuous line to connect them?  Seems to me like you might want 3 different lines, one for each segment that then shows a continuous profit ratio.  If so, move the segment pill to the row shelf.

-Hope

• ###### 4. Re: continuous line chart based on monthly

Hi Hope,

For Instance,

Data Is like Below:

 open closed % 4/1/2016 1000 250 25.0% 5/1/2016 900 124 13.8% 6/1/2016 850 122 14.4% 7/1/2016 700 234 33.4% 8/1/2016 900 345 38.3% 9/1/2016 250 15 6.0% 10/1/2016 350 130 37.1% 11/1/2016 102 50 49.0% 12/1/2016 500 450 90.0% 1/1/2017 600 236 39.3% 2/1/2017 234 90 38.5% 3/1/2017 640 278 43.4% 4/1/2017 300 87 29.0%

Expected Output:

Please drive me how to get this kind of reports in tableau.

• ###### 5. Re: continuous line chart based on monthly

Can you attach a packaged workbook?  That would make it easier to assist you.  If the values for open and close are coming from the same measure field, you should be able to use a dual axis (one for that field and the other for the % field).  If the values for Open and Close are coming from separate measures I think you will run into issues.  You may need to pivot those fields in your data source so they come through as a single measure.

A packaged workbook would help me to see more clearly what you're working with.

Thanks,

Hope

• ###### 6. Re: continuous line chart based on monthly

Hi Hope,

Attached workbook for your reference.

• ###### 7. Re: continuous line chart based on monthly

I don't see the attachment.

• ###### 8. Re: continuous line chart based on monthly

Hi Hope,

Due to some reason, I don't see attachment tab in my reply email. Because of that I edit and uploaded in my original post.

Please Dual Axis Issue Workbook in my original post.

Dual Axis Issue.twbx

• ###### 9. Re: continuous line chart based on monthly

Because you can't put a continuous date field in front of measure names on the columns shelf, I can't get the exact view we were hoping for.

But maybe you can show it a slightly different way.  I'm assuming whatever you're opening and closing here, you would never close more than you opened.  If that's true, you might consider this:

1. Remove Measure Names from the columns shelf

2. Make the date pill continuous

You'll get something like this:

3.  go to Analysis>Stack Marks> No

You'll get a view like this where the closed are in front of the open

To make it a little more obvious to the viewer that the closed are in front and there is no stacking, you might:

4. Pull measure names from the data pane (not the one currently on color) onto the size card (of the Measure Values Marks Card, not all):

You could then play with the slider to the bars the desired width.

I know this isn't exactly what you wanted, but I'm hoping it might work for you.  I would have attached the workbook but it looks like you're using an older version than me.

-Hope

1 of 1 people found this helpful
• ###### 10. Re: continuous line chart based on monthly

Thanks Hope. Your right even I did some research on this and it wont possible the way it works in excel. Hope customers will accept this approach.

Thanks

Learner

• ###### 11. Re: continuous line chart based on monthly

Hi,

If you have version 10.2 or newer, you can use size.

But this requires data re-shaping with pivot.

Thanks,

Shin

<< Ambassador Spotlight Here ! >>

1 of 1 people found this helpful
• ###### 12. Re: continuous line chart based on monthly

Thank you, Shinichiro.

It's working perfectly.

In your steps you might forget to mention, we need to switch off Stack Marks in the Analysis tab.

• ###### 13. Re: continuous line chart based on monthly

Thank you for following up.

Shin