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.
