1 Reply Latest reply: Apr 10, 2013 10:29 AM by Micael Leal RSS

    Showing Tables values

      Hello,

       

      I need some help concerning some calculated values.

       

      Basically, I read from a File

       

      IMPORT_ALL_VALUES;

      LOAD

           *

      FROM MYEXCEL.xlsm (ooxml, no labels, table is [Sheet])

      ---

      TAB_REDUCED:

      LOAD

          [Date raised],

          Application,

      RESIDENT IMPORT_ALL_VALUES;

       

      TAB_DEFECT_STATUS:

      LOAD * INLINE [

          Status

          Daily Closed

          Daily Opened

          Cumul Closed

          Cumul Opened

      ];

       

      TAB_REDUCED_VAL:

      LOAD

          [Date raised],

          Application,

          [Current State]

      RESIDENT IMPORT_ALL_SIRE;

       

      [Current State] tells me if an application is opened or closed.

       

      Now I can read from TAB_REDUCED all values, but I want to do a COUNT() to check how often an Application has occured for a certain [Date raised] and to add a fields Current State that contains "Daily Closed", "Daily Opened", "Total Closed", "Total Open"

       

      Result should something like:

       

      DATE ¦ Application ¦ Current State    ¦ Values

      27/02     Test           Daily Closed         2

      27/02     Test           Daily Opened        0

      27/02     Test           Total Closed        14 

      27/02     Test           Total Opened       12

      27/02     Test           Daily Closed         0

      27/02     Test           Daily Opened        0

      27/02     Test           Total Closed        16 

      27/02     Test           Total Opened       12

       

      I thought about Set Analysis in Expression, but I don't know how the expression could look like.

       

      So far, I managed to gather Application and Current State together, but I don't know how to show the Date and the calculated values in a Chart.