3 Replies Latest reply on Sep 15, 2016 6:46 AM by aditya.wresniyandaka

    stacked bar chart with line combination or side by side bar with line

    Nagaraju ponugoti

      Hello Experts,

      Greetings of the day,

       

       

      I am strucked with one problem how can i get the side by side bar or Stacked bar chart with two categories and line as a grandtotal on top of stacked bar chart

       

      here i am attaching the sample data could you please help me on this issue tomorrow is the deliverday any one please cpme forward and give a solution Quickly

      i will be great full to you

       

      Here i am attaching Sample Excel file please refer it

      Requirement

      1) Number is the Common column between all the 3 tables in provided excel sheet

      2) In KN_PHYSICAL_ST table NUMBER =Smodel+Chno this would be the Common column among all the 3 tables

       

      KN_Physical_State

      1. 1. DOM/EXP

      When DOM/EXP = ‘4’ then it is N-D

      When DOM/EXP = ‘1’ then it is N-E

      When DOM/EXP = ‘3’ then it is R-E

      When DOM/EXP = ‘2’ then it is R-D

      in KN_PHYSICAL_ST table   NUMBER =Smodel+Chno

       

      Join KN_Credit_Status table with KN_Physical_State table with NUMBER and get DOM/EXP details of a particular NUMBER in KN_Credit_Status table from KN_Physical_state table. Then count the number of Products in R and N in KN_Credit_State table.

       

      Date is Credit check date in KN credit  status table

      1) Requirement

      image 1.png

       

      the count may vary no issues but i need to get exact image in tableau ,

      if it is not possible with stack bar along with line also no problem 

       

      But line graph is Grand total of both

       

      please any one quickly help me i think  it would be easier to experts