Set Analysis Logic Modification

erric3210 — Tue, 15 Feb 2022 16:07:21 GMT

Hi Community,

I've writing a Set Analysis Expression using Exclusion and Inclusion Operators.

The Logic is working fine but I need to use more refined Expression.

This is my Data:

Load *, Num(Task_Date) AS Task_Date_Num INLINE [
Task_Date, Item_Name
21/1/2022, Bus
21/1/2022, Car
21/1/2022, Truck
21/1/2022, Train
22/1/2022, Car
22/1/2022, Truck
23/1/2022, Bus
23/1/2022, Car
23/1/2022, Truck
23/1/2022, Van
23/1/2022, Airplane
];

This is the Expression I'm using:

=CONCAT({<Item_Name=P({<Task_Date_Num={'$(=Min(Task_Date_Num))'}>})>* <Item_Name=P({<Task_Date_Num={'$(=Max(Task_Date_Num))'}>})>
-
<Item_Name=P({<Task_Date_Num={"*"}-{'$(=Min(Task_Date_Num))','$(=Max(Task_Date_Num))'}>})>} DISTINCT Item_Name,', ')

I need to replace {'$(=Min(Task_Date_Num))','$(=Max(Task_Date_Num))'}

with above expression part which has Inclusion Operator:

Item_Name=P({<Task_Date_Num={'$(=Min(Task_Date_Num))'}>})>* <Item_Name=P({<Task_Date_Num={'$(=Max(Task_Date_Num))'}>})>

and get the result.

Here is the Snapshot:

Any help would be appreciated.

Regards,

Eric

topic Set Analysis Logic Modification in Visualization and Usability

Set Analysis Logic Modification