13 Replies Latest reply on Oct 12, 2016 10:20 PM by kumar kvp

    Covert sales value from month to days

    kumar kvp

      Hi friends,

      I am new to Tableau. I was strucked in converting sales value from month to days.

      I.e In our data we are having only sales for months alone and but not the days.So i tried to make the sales values from month to days .

      When i tried to do that , it was showing only first day of the month because the value is available for first day of the month. and also i tried with having running total to get the values for all the rows , it was showing values for all rows but grand total is not showing correctly.

      Can anyone please help.

      example : The above one is having data as montly source and down i need to divide into days as expected.

      MOnthyearSales
      jan-2015200

       

      Monthyear

      day
      salesDay_sales
      jan-20151200

      13.3

      213.3
      313.3
      413.3
      513.3
      613.3
      713.3
      813.3
      913.3
      1013.3
      1113.3
      1213.3
      1313.3
      1413.3
      1513.3
      GrandTot200200

      Can any one help me or give me any suggestions.

      Thanks in advance

      Kumar KVP