6 Replies Latest reply on Jun 28, 2018 5:50 AM by Jim Dehner

# How to formulate line graph to worse and best with own data

Hi all

Now I have an workbook, which consists of month data, Actual revenue until May 2018, and worse and best scenario for the remaining year.

What I want to do is to formulate the graph similar to this:

That is, after the actual data May 2018, split the line graph into 2 based on the values in column worse case and best case.

I tried to google it but cannot find a similar case. Would it be possible to do so?

The workbook is attached as your reference. Many thanks!

• ###### 1. Re: How to formulate line graph to worse and best with own data

Hi Leung

You need to Pivot Your data to Get This.

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

• ###### 2. Re: How to formulate line graph to worse and best with own data

Hi

is this what you had in mind

this is hard coded - I would use thiere today() or a Parameter to make the calculation dynamic

this the worst case

this colors the actual /best

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 3. Re: How to formulate line graph to worse and best with own data

Hi Deepak

This is actually just he stimulated data. The real data is, the predicted data is calculated in tableau in a table form which is similar to this one, so is it still possible to do the pivoting? Or is there any alternatives to do so?

Pak Hang

1 of 1 people found this helpful
• ###### 4. Re: How to formulate line graph to worse and best with own data

Hi Jim

Just another question: How can you make the two lines in the same graph?

I follow your step but in the last step, when I try to drag the column into same rows, It was simply divided into two sub-categories.

But besides that, everything works well and almost done.

Regards

Pak Hang

1 of 1 people found this helpful
• ###### 5. Re: How to formulate line graph to worse and best with own data

You can bring the Table as New Connection and Do Pivoting

1 of 1 people found this helpful
• ###### 6. Re: How to formulate line graph to worse and best with own data

see below

it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful