5 Replies Latest reply on Jan 26, 2017 7:29 AM by Wim Kegels

    Fee overview

    Lior Gil

      Hi All,

       

      Anyone knowS how to create an overview graph like this one:

      Thanks,

      Lior

        • 1. Re: Fee overview
          Wim Kegels

          Hi Lior,

           

          This is kind of a general question; I advise you to be more specific next time.

           

          If your data is structured as followed:

           

          Expense typeExpense
          Net fee100
          Third party Fee50
          Travel Expenses20
          Other Expenses20

           

          You could put Expense on the Columns shelf and Expense Type on the colour mark.  This will split your expense bar by expense type.

           

          Kind regards,

          Wim

          • 2. Re: Fee overview
            Lior Gil

            Hi Wim,

             

            I have the following:

             

            Total FeeThird PartyTravel ExpensesOther Expenses
            200050010020

             

            4 different columns


            the net fee variable got from calculated field  : [total Fee]- ([Travel Expenses]+[Other Expenses]+[Third Party] )

             

            I would like to present the data like in the picture attached, so it can not be axis line
            (as the eye supposed to capture the proportion of the differences between the columns )

            do you have an idea how can I create it?

             

            Thanks,

            Lior

            • 3. Re: Fee overview
              Wim Kegels

              Hi Lior,

               

              You'll have to pivot your data before using it.  This will result in the structure I described in my previous post. 

               

               

              Kind regards,

              Wim

              • 4. Re: Fee overview
                Lior Gil

                Im using SQL data source...

                • 5. Re: Fee overview
                  Wim Kegels

                  That's still kinda broad, but you'll want to make an extract before trying to pivot.  Not all data sources support live pivoting.  Select the "extract" option on the top right of your data connection page, then click on a sheet to make the extract, and go back to your data connection page to pivot your data.

                   

                   

                  Good luck!

                   

                  Wim