2 Replies Latest reply on Feb 12, 2019 3:08 PM by djay temp

    Org Chart like View on Dashboard

    djay temp

      My data is already flatted out and it looks like below. I want to create org chart like view, where I can see John Doe and Jane Doe as two separate entities. Each one of them has multiple codes. Each one of the code can map to multiple ID For example ABC points to 11 ,18 and 19 and so on. I have units assigned by id.

       

      I need to create org chart that gives org chart like view but at the end, I need to be able to summarize average unit (let say Unit#1, Unit#2) by id and give hierarchical view like org. chart.

       

      any help?

                

      NameCodeidCode NameUnit#1Unit#2Unit#3Unit#4Unit#5Unit#6
      John DoeABC11ABC NAME62002280.07
      John DoeASD12ASD NAME86974102240.18
      John DoeABC13ABC NAME200020
      John DoeASD14ASD NAME7007901490.53
      John DoeASD15ASD NAME19130230.13
      John DoeASD16ASD NAME372051202540.05
      John DoeASD17ASD NAME5857015328100.19
      John DoeABC18ABC NAME9312001050
      John DoeABC19ABC NAME42084035070.01
      John DoeASD20ASD NAME2318111304250.27
      John DoeABC21ABC NAME0110711090.99
      John DoeXYZ22XYZ NAME97400560.71
      John DoeXYZ23XYZ NAME1818264123120.88
      John DoeXYZ24XYZ NAME04180220.82
      John DoeXYZ25XYZ NAME04180220.82
      John DoeXYZ26XYZ NAME84743620.11
      John DoeXYZ27XYZ NAME131001010051
      John DoeXYZ28XYZ NAME102940974550.91
      John DoeXYZ29XYZ NAME97400560.71
      John DoeXYZ30XYZ NAME1818264123120.88
      John DoeXYZ31XYZ NAME14211001530
      John DoeXYZ32XYZ NAME61022371810110.37
      John DoeXYZ33XYZ NAME29700360
      John DoeXYZ34XYZ NAME800080
      Jane DoeIOP111IOP NAME312141381940.92
      Jane DoeIOP112IOP NAME2415107560.3
      Jane DoeIOP113IOP NAME231761932210.1
      Jane DoeIOP114IOP NAME434300860
      Jane DoeIOP115IOP NAME215023934713650500.1
      Jane DoeIOP116IOP NAME27139201680.01
      Jane DoeIOP117IOP NAME938231710.34
      Jane DoeYOU118YOU NAME02200220
      Jane DoeYOU119YOU NAME0903120.25
      Jane DoeYOU120YOU NAME11221122.11122.21122.31122.41122.5
      Jane DoeYOU121YOU NAME4557001020
      Jane DoeYOU122YOU NAME11432233.12233.22233.32233.42233.5
      Jane DoeRTY123RTY NAME070015850.18
      Jane DoeRTY124RTY NAME5013062541107849750.73
      Jane DoeRTY125RTY NAME060390.33
      Jane DoeRTY126RTY NAME0790231020.23
      Jane DoeRTY127RTY NAME2790271080.25
      Jane DoeRTY128RTY NAME1940251200.21
      Jane DoeRTY129RTY NAME212623790.82
      Jane DoeRTY130RTY NAME4952109832623800.6
      Jane DoeRTY131RTY NAME067165192510.73
      Jane DoeRTY132RTY NAME0211375726580.68
      Jane DoeRTY133RTY NAME21306255336142220.69
      Jane DoeRTY134RTY NAME070015850.18
      Jane DoeRTY135RTY NAME116103277230122210.48
      Jane DoeRTY136RTY NAME01207190.37
      Jane DoeRTY137RTY NAME11890622520.25
      Jane DoeRTY138RTY NAME1703110.27
      Jane DoeRTY139RTY NAME116103277230122210.48
      Jane DoeRTY140RTY NAME060390.33
      Jane DoeRTY141RTY NAME1335602045730.36
      Jane DoeRTY142RTY NAME1125384825920.79
      Jane DoeRTY143RTY NAME01207190.37
      Jane DoeRTY144RTY NAME060390.33
      Jane DoeRTY145RTY NAME090158242720.67
      Jane DoeRTY146RTY NAME8897868932225900.35
      Jane DoeRTY147RTY NAME8897868932225900.35
      Jane DoeRTY148RTY NAME8897868932225900.35
      Jane DoeRTY149RTY NAME02100210
      Jane DoeRTY150RTY NAME66289596321328139210.79
      Jane DoeRTY151RTY NAME16500431090.39
      Jane DoeRTY152RTY NAME342441821025620.51
      Jane DoeRTY153RTY NAME1512111390.31
      Jane DoeRTY154RTY NAME1335602045730.36
      Jane DoeRTY155RTY NAME12182399746670.71
      Jane DoeRTY156RTY NAME8200008200
      Jane DoeRTY157RTY NAME5990005990
      Jane DoeRTY158RTY NAME318002873060530.47
      Jane DoeRTY159RTY NAME710904437617161610.74
      Jane DoeRTY160RTY NAME1460001460
      Jane DoeRTY161RTY NAME3725140325869378070.34
      Jane DoeRTY162RTY NAME3725140325869378070.34
      Jane DoeRTY163RTY NAME3725140325869378070.34
      Jane DoeRTY164RTY NAME3725140325869378070.34
      Jane DoeRTY165RTY NAME419811011047050.29
      Jane DoeRTY166RTY NAME130040
      Jane DoeRTY167RTY NAME400040
      Jane DoeRTY168RTY NAME3032003050
      Jane DoeRTY169RTY NAME710904437617161610.74
      Jane DoeRTY170RTY NAME3725140325869378070.34
      Jane DoeRTY171RTY NAME8661716402917060.39
      Jane DoeRTY172RTY NAME1460001460
      Jane DoeRTY173RTY NAME2251002260
      Jane DoeRTY174RTY NAME32000320
      Jane DoeRTY175RTY NAME7720007720
      Jane DoeRTY176RTY NAME03093641157880.61
      Jane DoeRTY177RTY NAME66289596321328139210.79
      Jane DoeRTY178RTY NAME1512111390.31
      Jane DoeRTY179RTY NAME5756371361071540.19
      Jane DoeRTY180RTY NAME11340001530
      Jane DoeRTY181RTY NAME9382377854771494201310.35
      Jane DoeRTY182RTY NAME9382377854771494201310.35
      Jane DoeRTY183RTY NAME9382377854771494201310.35
      Jane DoeRTY184RTY NAME9382377854771494201310.35
      Jane DoeRTY185RTY NAME9382377854771494201310.35
      Jane DoeRTY186RTY NAME2648113112919100.66
      Jane DoeRTY187RTY NAME332147004790
      Jane DoeRTY188RTY NAME1155001200
      Jane DoeRTY189RTY NAME33317353197220.52
      Jane DoeRTY190RTY NAME332147004790
      Jane DoeRTY191RTY NAME261900450
      Jane DoeRTY192RTY NAME74444179012640.06
      Jane DoeRTY193RTY NAME332147004790
      Jane DoeRTY194RTY NAME184996374128870.03
      Jane DoeRTY195RTY NAME03093641157880.61
      Jane DoeRTY196RTY NAME01100110
      Jane DoeRTY197RTY NAME312141381940.92
      Jane DoeRTY198RTY NAME26152112783680.52
      Jane DoeRTY199RTY NAME9319019671828170.35
      Jane DoeRTY200RTY NAME26152112783680.52
      Jane DoeRTY201RTY NAME9319019671828170.35
      Jane DoeRTY202RTY NAME18461337271122461180.48
      Jane DoeRTY203RTY NAME0626001220.49
      Jane DoeRTY204RTY NAME130614135156032940.17
      Jane DoeRTY205RTY NAME010010
      Jane DoeRTY206RTY NAME83314501590.28
      Jane DoeRTY207RTY NAME15659849631035220.28
      Jane DoeRTY208RTY NAME368764146717980.62
      Jane DoeRTY209RTY NAME66602740.03
      Jane DoeRTY210RTY NAME600060
      Jane DoeRTY211RTY NAME15659849631035220.28
      Jane DoeRTY212RTY NAME368764146717980.62
      Jane DoeRTY213RTY NAME938231710.34
      Jane DoeRTY214RTY NAME163400500
      Jane DoeRTY215RTY NAME130614135156032940.17
      Jane DoeRTY216RTY NAME26152112783680.52
      Jane DoeRTY217RTY NAME342441821025620.51
      Jane DoeRTY218RTY NAME40359233036616910.41
      Jane DoeRTY219RTY NAME729426352270.27
      Jane DoeRTY220RTY NAME220150.2
      Jane DoeRTY221RTY NAME605442452010.43
      Jane DoeRTY222RTY NAME125206721165190.36
      Jane DoeRTY223RTY NAME187224104655800.29
      Jane DoeRTY224RTY NAME1598101050226600.02
      Jane DoeRTY225RTY NAME891186616419490.53
      Jane DoeRTY226RTY NAME28441003250
      Jane DoeRTY227RTY NAME75029960710817640.41
      Jane DoeRTY228RTY NAME1536459105200.9
      Jane DoeRTY229RTY NAME75029960710817640.41
      Jane DoeRTY230RTY NAME1536459105200.9
      Jane DoeRTY231RTY NAME40381336279656590.05
      Jane DoeRTY232RTY NAME75029960710817640.41
      Jane DoeRTY233RTY NAME483121274429200.34
      Jane DoeRTY234RTY NAME483121274429200.34
      Jane DoeRTY235RTY NAME101200220
      Jane DoeRTY236RTY NAME419811011047050.29
      Jane DoeRTY237RTY NAME12323001460
      Jane DoeRTY238RTY NAME2361714404510.1
      Jane DoeRTY239RTY NAME710904437617161610.74
      Jane DoeRTY240RTY NAME130614135156032940.17
      Jane DoeRTY241RTY NAME111245701920.3
      Jane DoeRTY242RTY NAME1155001200
      Jane DoeRTY243RTY NAME301716191444460840.24
      Jane DoeRTY244RTY NAME273000570
      Jane DoeRTY245RTY NAME03598431760.8
      Jane DoeRTY246RTY NAME2361714404510.1
      Jane DoeRTY247RTY NAME40381336279656590.05
      Jane DoeRTY248RTY NAME36177202150.01
      Jane DoeRTY249RTY NAME21200140
      Jane DoeRTY250RTY NAME23759112980.01
      Jane DoeRTY251RTY NAME40381336279656590.05
      Jane DoeRTY252RTY NAME03105746415241
      Jane DoeRTY253RTY NAME291810480.02
      Jane DoeRTY254RTY NAME03105746415241
      Jane DoeRTY255RTY NAME5322544617250.62
      Jane DoeRTY256RTY NAME6096029463221890.45
      Jane DoeRTY257RTY NAME018828694830.61
      Jane DoeRTY258RTY NAME01481230.39
      Jane DoeRTY259RTY NAME729426352270.27
      Jane DoeRTY260RTY NAME2318111304250.27
      Jane DoeRTY261RTY NAME442647231400.5
      Jane DoeRTY262RTY NAME442647231400.5
      Jane DoeRTY263RTY NAME442647231400.5
      Jane DoeRTY264RTY NAME311617355012830.28
      Jane DoeRTY265RTY NAME787718255017600.14
      Jane DoeRTY266RTY NAME67981801830.1
      Jane DoeRTY267RTY NAME311617355012830.28
      Jane DoeRTY268RTY NAME311617355012830.28
      Jane DoeRTY269RTY NAME311617355012830.28
      Jane DoeRTY270RTY NAME311617355012830.28
      Jane DoeRTY271RTY NAME0175117850.8
      Jane DoeRTY272RTY NAME44711363417813720.59
      Jane DoeRTY273RTY NAME53231744922915270.44
      Jane DoeRTY274RTY NAME3924462828111920.76
      Jane DoeRTY275RTY NAME79333201440.22
      Jane DoeRTY276RTY NAME51520510008200.12
      Jane DoeRTY277RTY NAME001121
      Jane DoeRTY278RTY NAME111245701920.3
      Jane DoeRTY279RTY NAME111245701920.3
      Jane DoeRTY280RTY NAME111245701920.3
      Jane DoeRTY281RTY NAME016140300.47
      Jane DoeRTY282RTY NAME693413208639480.81
      Jane DoeRTY283RTY NAME341935307040633146220.52
      Jane DoeRTY284RTY NAME121800300
      Jane DoeRTY285RTY NAME120030
      Jane DoeRTY286RTY NAME00100231231
      Jane DoeRTY287RTY NAME1218130442040.85
      Jane DoeRTY288RTY NAME891186616419490.53
      Jane DoeRTY289RTY NAME16450261410.54
      Jane DoeRTY290RTY NAME92781251465580.49
      Jane DoeRTY291RTY NAME1562846828713980.54
      Jane DoeRTY292RTY NAME2273821094660.41
      Jane DoeRTY293RTY NAME891186616419490.53
      Jane DoeRTY294RTY NAME010010
      Jane DoeRTY295RTY NAME331410480.29
      Jane DoeRTY296RTY NAME01102130.15
      Jane DoeRTY297RTY NAME92781251465580.49
      Jane DoeRTY298RTY NAME891186616419490.53
      Jane DoeRTY299RTY NAME21909300.3
      Jane DoeRTY300RTY NAME1562846828713980.54
      Jane DoeRTY301RTY NAME2273821094660.41
      Jane DoeRTY302RTY NAME4442581227160.02
      Jane DoeRTY303RTY NAME312141381940.92
      Jane DoeRTY304RTY NAME26152112783680.52
      Jane DoeRTY305RTY NAME163400500
      Jane DoeRTY306RTY NAME938231710.34
      Jane DoeRTY307RTY NAME14129127123090.45