6 Replies Latest reply on Aug 4, 2016 2:42 PM by Shinichiro Murakami

# Good Visualisation chart

Hi

• ###### 1. Re: Good Visualisation chart

Shinichiro Murakami

Ashish Chaudhari

Can you please check above one

• ###### 2. Re: Good Visualisation chart

Hi Govind,

The top graph appears to be a waterfall chart which some have called a bridge or a cascading chart as well. The last two are simply bar graphs.  The totals of all three have been put on the left side instead of the 'default/standard' right side (end of the graph). The second graph has an axis distortion that only applies to the total which would be something more difficult to implement within tableau.

Is this what you were looking  for?

Best Regards,

Carl Slifer

InterWorks

2 of 2 people found this helpful
• ###### 3. Re: Good Visualisation chart

Tried to replicate.

It's already set as "Correct" and I don't know you need further support or not.

If you need detail explanations please let me know.

Thanks,

Shin

3 of 3 people found this helpful
• ###### 4. Re: Good Visualisation chart

Really no words to say..Thank you so much.Can you please explain steps and formula.

• ###### 5. Re: Good Visualisation chart

This is superb stuff Shin.

-Ashish

• ###### 6. Re: Good Visualisation chart

OK,

Let's get started.

Here are three parts I spent time.

1. The reversed Water fall chart (Technically most difficult in this request)

2. TOP 10 + Other [3]

3. Wave

Start from easy one, it's 3 ==> 2 ==> 1

3.

and bring to Front

2.

Create set

[Top N Name]

if [Set Top 10 Province] then [Province]

else "Other ["+str({fixed:countd(if not [Set Top 10 Province]then [Province]end)})+"]" end

// between "[" and "]"  counting nu,ber of non-TOP 10 Province with countd and show as string.

1.

To show G.total to left check below items.

Then the most difficult one.

Gantt is consist of "Start point" and "Size"

- Start point : I tried to calculate G.total - running sum from left to right 'desc' 'sum(sales) sorted Provice.

- Size : sum(sales) of respective province

[Sales + Total Runsum]

attr({fixed :sum([Sales])})-RUNNING_SUM(sum([Sales]))

Hope these help.

Thanks,

Shin

1 of 1 people found this helpful