1 Reply Latest reply on Jan 30, 2018 3:39 PM by Sujay Paranjpe

    Sales hourly,daily,weekly

    muhammad usman

      I have a field called sales

      I have another called Date which is date and Type

      How to calculate sales hourly,daily,weekly and minute ?

       

      How to achieve this

        • 1. Re: Sales hourly,daily,weekly
          Sujay Paranjpe

          Hi muhammad usman,

           

          I am assuming that your filed Date is of data type Date & Time. Follow below steps

           

          1. Drag Date Field on Column Shelf.

          2. Drag Sales on the Row Shelf

          3. Set the Chart Type to Line chart.

          4. Now Right Click on the Date filed on the column shelf and select

          - Week Number to get Weekly Sales View

          - Day to get the Daily Sales View

          - More > 'Appropriate Option' to get Hourly and Minute view

           

           

          Best,

          Sujay

          If this post 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.