10 Replies Latest reply on May 11, 2018 3:37 AM by Matheus Cezar

    Just a help

    Matheus Cezar

      I need help in some stuff.

      First i need to show a percentile value right beside the value(Valor) that is already showing

      Second i need to make these graphics below show info in only one graphic(Its like  Income x Expenses)(they are in diferent data sources that came from the same excel archive)

      Obs:Orgao=Unidade

        • 1. Re: Just a help
          Jim Dehner

          Good morning

          see the attached

           

          the percent of total is a table function

           

           

          the formula is

           

          converting this chart at the subcat level

           

          to this

           

           

           

          is done by just removing subcategory from the color tile

           

          Jim

           

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

          1 of 1 people found this helpful
          • 2. Re: Just a help
            Matheus Cezar

            The first part of the percentile is done,thank you. Im just trying to do the second part and im getting this error message while trying to pull filters from different sources "Fields of the Liquidacao BI data source can not be used because there is no relation to the primary data source." I didnt get it how to solve it,what should i do?Liquidacao Bi has my expenses and Receita Bi has my income but they are different sources

            • 3. Re: Just a help
              Jim Dehner

              I would have to see the actual workbook - you have a number of data sources that are tied together in a single measure -

              please post your workbook in a twbx format

               

              thanks

              Jim

              1 of 1 people found this helpful
              • 4. Re: Just a help
                Matheus Cezar

                Just attached the workbook. It is in portuguese but i hope you

                understand it, any doubts just ask please

                 

                Em 10/05/2018 10:30, Jim Dehner escreveu:

                 

                TABLEAU COMMUNITY

                 

                JUST A HELP

                 

                reply from Jim Dehner  in Forums - View the full discussion

                 

                • 5. Re: Just a help
                  Jim Dehner

                  see the blue tabs

                  On the first I just removed Unidade from the color tile

                  On the second I removed Unidade from the detail tile (first) then Orgao from the color tile

                   

                  this is what they returned

                   

                   

                   

                   

                  Jim

                   

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

                  1 of 1 people found this helpful
                  • 6. Re: Just a help
                    Matheus Cezar

                    Its not what i want.I have to make a graphic with two lines( Valor that

                    comes from Liquidacao BI x Valor Receita that comes from Receita BI) and

                    it should be in the Receita x Despesa panel,that is separated from

                    Auditoria and Receitas.You understand it?Im not going to change the

                    graphics in Auditoria and Receitas panel.It is going to be a new one

                    that crosses both and its going to be in this third panel Receita x

                    despesa.

                     

                    Em 10/05/2018 10:57, Jim Dehner escreveu:

                     

                    TABLEAU COMMUNITY

                     

                    JUST A HELP

                     

                    reply from Jim Dehner  in Forums - View the full discussion

                     

                    • 7. Re: Just a help
                      Jim Dehner

                      sorry for not understanding - I tried to create the 2 line chart but ran into a message that there is no relationship between the 2 files

                       

                      so on the second source I tied all three links together and got this

                       

                       

                       

                      don't know that this is what you want - sorry I don't speak the language so it is a little tough navigating the workbook

                       

                      see the red tab - it is the new woksheet

                       

                      Jim

                      1 of 1 people found this helpful
                      • 8. Re: Just a help
                        Matheus Cezar

                        Ok we made a progress thats exactly what i want,you will continue

                        helping me to improve it?It needs to have a total sum at the end of the

                        graphics,and i need to make unidades and orgaos to appears as filter,so

                        i can see this graphic for each one of them.

                         

                        I tried duplicating orgaos table because it has to show valor and valor

                        percentile right beside the Valor Receita.But valor is pulling wrong

                        values because it filters as Unidades in the original data.But they are

                        the same.You wanna see the excel file that im using to pull this data

                        too?If it makes you easier to help me.

                         

                        Em 10/05/2018 11:26, Jim Dehner escreveu:

                         

                        TABLEAU COMMUNITY

                         

                        JUST A HELP

                         

                        reply from Jim Dehner  in Forums - View the full discussion

                         

                        • 9. Re: Just a help
                          Jim Dehner

                          Ok I was able to get the 2 filters on the chart - adding the totals - don't know how to add

                           

                          see the attached

                           

                          don't know that I can be of any more help - the language barrier in the workbook is confusing to me

                           

                          Jim

                          1 of 1 people found this helpful
                          • 10. Re: Just a help
                            Matheus Cezar

                            Ok, thank you, you helped me a lot even with this language barrier.

                             

                            Em 10/05/2018 13:03, Jim Dehner escreveu:

                             

                            TABLEAU COMMUNITY

                             

                            JUST A HELP

                             

                            reply from Jim Dehner  in Forums - View the full discussion