1 Reply Latest reply: Aug 28, 2018 9:47 AM by Gabor Tarnoczai RSS

    Give me suggestion for create a dashboard with below data

    xxxxx yyyyy

      I have data. i want dashboard with below

       

                   

      Mkt AlFlightStopsOrigThru PointDestDep TimeCp Arr TimeCp Dep TimeArr TimeEquipSeatsKilometersElapsed Mins
      QB22170IKANJF1300124532014973115
      GF1010BAHDMM012502003201368935
      GF1030BAHDMM101510503201368935
      GF1090BAHDMM173518103201368935
      GF1110BAHDMM214522203201368935
      KL17310AMSBRU16551735EMJ10015840
      GF1020DMMBAH071507553201368940
      GF1040DMMBAH114512253201368940
      GF1100DMMBAH185019303201368940
      GF1120DMMBAH230023403201368940
      YK7570FRUALA205021301469920840
      KL17210AMSBRU06500735EMJ10015845
      KL17230AMSBRU09251010EMJ10015845
      KL17250AMSBRU13301415EMJ10015845
      KL17330AMSBRU21302220EMJ10015850
      KL17260BRUAMS14451535EMJ10015850
      KL17320BRUAMS18051855EMJ10015850
      LH11820FRAZRH0635072532A16828650
      LH11840FRAZRH0800085032015028650
      LX10690FRAZRH0845093532016828650
      LH11860FRAZRH0945103532015028650
      LH11900FRAZRH1305135531912628650
      LX10730FRAZRH14151505CS112528650
      LH11960FRAZRH1625171532A16828650
      LX10750FRAZRH17301820CS112528650
      LH11980FRAZRH1820191032015028650
      MH6090KULSIN2305235573816929650
      LX16220ZRHMXP17201810CS112520350
      KC1090ALAFRU1820191532014820855
      KL17200BRUAMS06150710EMJ10015855
      SN36310BRUCDG0650074532015625355
      SN36320CDGBRU0845094032015625355
      SV12700ELQRUH0700075532116533055
      SV12720ELQRUH1210130532116533055
      SV12680ELQRUH2140223532013233055
      LH920FRAMUC0645074032A16830155
      LH940FRAMUC0715081032118230155
      LH960FRAMUC0815091031912630155
      LH980FRAMUC0915101032118230155
      LH1000FRAMUC1015111032118230155
      LH1040FRAMUC1215131032118230155
      LH1060FRAMUC1315141032118230155
      LH1080FRAMUC1415151032118230155
      LH1100FRAMUC1515161032118230155
      LH1120FRAMUC1615171032118230155
      LH1140FRAMUC17151810321

      182

      30155

                   

      PR-AK527/717ICNXMNLKULSIN1130145016501800320 / 320150/1802,784390
      MH-SQ807/117ICNXMNLKULSIN1315170518451945738 / 333169/2852,784390
      3K-ET762/638ICNXMNLSINKUL1040142015501710320 / 788180/2722,668390
      3K-MI762/340ICNXMNLSINKUL1040142016101710320 / 319180/1282,668390
      SQ-TR917/466ICNXMNLSINKUL1405175019302035773 / 320332/1802,668390
      PR-HX896/253ICNXMNLTPEHKG0715092511551345321 / 359182/3341,949390
      BR-CI272/106ICNXMNLTPENRT125015001620202077W / 333316/3113,352390
      EW-KL1834/1707ICNXMUCAMSMAD1655182520452325321 / 737210/1572,126390
      KL-SU1792/2551ICNXMUCAMSSVO0955113513001825737 / 321157/1702,816390
      LH-UX1826/7160ICNXMUCBIOMAD1525174020502155319 / E90126/1201,588390
      AF-PK1623/734ICNXMUCCDGBCN1530171020202200320 / 777165/3101,542390
      LH-SU2010/2153ICNXMUCDUSSVO1130124014502000321 / 32A182/1682,564390
      LH-AF2098/1839ICNXMUCHAJCDG152516302015215532A / E90168/961,114390
      BA-AF947/1581ICNXMUCLHRCDG0755091012101425321 / 319188/1421,291390

       

       

      i want dashboard like

       

      File contains following field,

       

       

      AirlineCodeFlightStopsOrigThru PointDestDep TimeCp Arr TimeCp Dep TimeArr TimeEquipSeatsKilometersElapsed Mins

       

       

      Dashboard should be intuitive and able to drill down to nth level.

       

      It should minimum contain following things.

       

      1.  How can we compare different airlines ?

      2. How can we compare different flights for specific sector (SRC-DEST) ?

      3. How can we compare different airports ?