2 Replies Latest reply on Apr 8, 2018 4:15 AM by Amit Dasgupta

    Problem on Dual chart and visualization

    Amit Dasgupta

      Hello,

       

      I'm new to Tableau and downloaded 10.5 desktop.

       

      I have the below problem and attached an excel sheet with the dataset.

       

      I want to visualize this data.. First a Bar chart showing number of records from 01-March-18 to 10-March-18

      Another chart will calculate average of "Overall" column for each date and display as line chart.

      For example,

      In this case, Average for 03-Mar is 4.44 and total no. of record is 18... Tableau should show a Bar graph showing 18 against Bar Graph and line graph above should take the average of total number of records for 03-March and show this average.

       

      Could some one please help me.

       

      Thanks

      Amit