Showing Tables values

[#1]

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.

[#2 · Accepted solution]

Found a solution.