2 Replies Latest reply on Apr 3, 2018 7:00 PM by Sean osean

    Working with multiple dates in one chart

    Sean osean

      Hello all,

      I am working on the requirement to create a Tabular chart. The join is very complicated with about 13-14 tables. Following is the dashboard / sheet should look like in a chart format. Unfortunately, i cant post the twbx or extract.

       

      The issue here is the data coming from different date filters and they all need to be in one chart. Example

       

       

      app date
        1 :--  filter data for manual appr%,
        disc 1, auto 1, auto 2
      App date 2 :- Filter datA for
        App #, Offer %, avg. time, auto 1
      App date 3  :-- book1, book2, book3, R1, R2
      App date 4 :-- Loss, Earn,
        rating

       

      I can't do union. Can I create calc. field to bring in the data in this format ? Or what's the best solution ?

       

      Thanks in advance.

       

      Month format201801201712201801201712201801201712.00201801.00201712.00201801.002018 02
      App #3,54554,5623,54535,4543,543,512212271,9362,45553,24524,532
      Appr %20.0%10.0%5.0%8.0%45.0%12.0%14.0%75.0%45.0%78.0%
      Offer %1.2%4.2%3.2%54.0%21.0%1.0%56.0%85.0%2.0%1.0%
      Manual Appr %5.0%2.0%2.0%4.0%56.0%12.0%21.0%54.0%54.0%54.0%
      disc 121.0%21.0%21.0%21.0%54.0%12.0%54.0%56.0%91.0%20.0%
      avg. time70122156411054545421
      Auto 112.0%56.0%1.0%1.0%2.0%2.0%4.0%5.0%5.0%2.0%
      Auto 26.0%59.7%70.9%71.2%69.9%70.1%17.2%19.1%48.3%49.9%
      Booking11112125274451265658721
      book 26.5%8.3%2.4%2.5%1.8%1.8%27.7%39.4%8.6%11.2%
      book 319.3%25.1%21.9%21.8%28.0%28.1%33.3%47.0%18.6%24.4%
      Book 46%7%8%8%9%9%6%6%5%5%
      R11.6%1.6%2.0%2.3%1.6%1.7%0.6%0.6%1.3%1.2%
      R218.1%17.8%19.4%22.4%16.8%18.4%13.5%13.1%16.2%15.7%
      rateing7.72%7.72%9.50%10.24%7.24%7.79%3.52%3.58%6.17%6.26%
      Loss1.6%1.6%2.0%1.9%1.1%1.1%0.1%0.1%0.8%0.9%
      earn$5,454$4,545$8,788$784$656$54$657$87,845$5,454