6 Replies Latest reply on May 27, 2019 3:25 AM by chandan gowda

    How to depict same value from two different dimensions

    chandan gowda

      Hi,

       

      I would like to show count from two different dimensions Please help

        

      Affected UserRequested By
      Accounting - FLAMMAAbbie Johnston
      Abbie JohnstonAbhijit Gupta
      Adam GuyattAbhinav Pandey [Xchanging]
      Adam LeeseAbbie Johnston
      Adam RaphaelyAbin Daniel
      Adam RoutledgeAda Rui Xu
      Adebola OkusanyaAdam Guyatt

       

      From a huge list of ticket numbers It should bring out count of tickets where Affected User is same as Requested By

       

      Something like

       

      and hide values when Affected User != Requested By

        • 1. Re: How to depict same value from two different dimensions
          Zhouyi Zhang

          Hi, Chandan

           

          Can you provide a small amount of data and show what's your expected result with it?

          And what do you mean by affected user is the same as requested by? do you mean the name are equal? if yes, you just need create a calculation filed like sum(if [affected user] = [requested by] then 1 else 0 end), drag the affected user and requested by to rows, and drag the calculation field to text. Is that what you mean?

           

          ZZ

          • 2. Re: How to depict same value from two different dimensions
            chandan gowda

            Hello Zhouyi

             

            Thanks for the quick response

            Here is a sample data attached

                  

            IncidentNumberAffected UserRecIdReportedByReportingOrgUnitIDTotalTimeSpent
            18,403Matthew McVeigh5F8E0E485D70473DA5502122F9349837Matthew McVeighTechnology0
            18,433Yi CuiEEC905902619484481AA6C231CCC2D30Dharani Kokkanti [Team]Middle Office0
            18,443Jennifer Rising6A54DE1677CC4CAB9F5639166CA29BD2Jennifer RisingOperations0
            19,411Christophe Gregori8411919562D54341A858F9794005ABC2Christophe GregoriTechnology0
            19,414Mohan Rajanna [Team]619E6244815B4F39B9DD15DEB11E5960Mohan Rajanna [Team]Mercuria0
            19,455Laurent FlachetC2E851C9B35B45789DDD60CE1189C7B6Laurent FlachetFinance0
            19,566Uday RamagoniAC39D473BC704F179DED46A290F75A10Abhinav Pandey [Team]Technology0
            19,610Michael Ouedraogo3ED251600BDB4E3E80E9E23772CF18DFMichael OuedraogoOperations0
            19,632Mark GutierrezAF12CF0E1D49482881D655934290B573Mark GutierrezTrading0
            19,634Xavier Rousseau59803D5F0239474BBDBC035653682699Xavier RousseauFinance0
            19,637Rimma Murzakhanova7DD4B887E52741559ED1E5090D10746BKalyan BhangiRisk0
            20,414Dagmara ZakFB5046EA723E4E209FE82E2A847FDC1FDagmara ZakOperations0
            20,433Kexin Xi5145263D6E264E7C9CFD0635BC0D5B9BKexin XiMiddle Office0
            20,436Uday RamagoniB6A260DFF82E4C2D806508178425C42FUday RamagoniTechnology0
            20,442Mikael Andersson806EB55B713A48B89A1E68E02AF8D370Mikael AnderssonTechnology0
            20,457Durga Prasad [Team]D15577B0D5F54FAE8356F5E4CE24DAADThirumala Reddy Munagala [Team]Mercuria0
            20,485Juliette de La Marnierre5D16F43ADD9F48ED809D159B965BA286Juliette de La MarnierreFinance0
            18,076Günay Sengül0E7A6B58E0684E019C1C85BD99BE60BFGünay SengülOperations0

             

            It should bring out count of tickets where Affected User is same as Requested By

            and hide values when Affected User != Requested By

            • 3. Re: How to depict same value from two different dimensions
              Zhouyi Zhang

              Hi, Chandan

               

              thanks for your sample data.

               

              Please find my solution below

               

              Hope this helps

               

              ZZ

              • 4. Re: How to depict same value from two different dimensions
                chandan gowda

                Hi

                 

                Will still require another assistance

                 

                • 5. Re: How to depict same value from two different dimensions
                  Zhouyi Zhang

                  Hi, Chandan

                   

                  Just drag the calculation to the filter and exclude Null

                  If this answers your question, please mark my answer either helpful or correct to cloese the thread.

                   

                  ZZ

                  • 6. Re: How to depict same value from two different dimensions
                    chandan gowda

                    Thanks Zhouyi Zhang,

                     

                    That worked like a charm

                    Appreciate the assistance