Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a table with various fields, i want to only show the latest date by product and account name.
so an example would be..
so for the above, i would want to jide all of the rows that are highlighted and only show the other rows as they are the latest date.
can anyone help?
example attached..
you can try below for chart
=if(Date = max(TOTAL <Account> Date),Date)
in Load Script
data:
LOAD Account,
City,
Postcode,
Name,
T1,
Product,
[Group Outlet],
[Image Type],
Listed,
Date
FROM
data.xls
(biff, embedded labels, table is Sheet1$);
Right Keep
MaxDate:
LOAD Account,
Max(Date) as Date
FROM
data.xls
(biff, embedded labels, table is Sheet1$)
Group by Account;
Drop table MaxDate;
Hi, i want to do this in a chart if possible, not script.
Thanks
do you want to do that in the load script? or chart?
you can try below for chart
=if(Date = max(TOTAL <Account> Date),Date)
in Load Script
data:
LOAD Account,
City,
Postcode,
Name,
T1,
Product,
[Group Outlet],
[Image Type],
Listed,
Date
FROM
data.xls
(biff, embedded labels, table is Sheet1$);
Right Keep
MaxDate:
LOAD Account,
Max(Date) as Date
FROM
data.xls
(biff, embedded labels, table is Sheet1$)
Group by Account;
Drop table MaxDate;
Hi,
Expression
Если (Date = Max (TOTAL Дата), дата) (смотрите прикрепленный файл).
Only in your image date, highlighted in yellow, is not the last one. In the attached file I gave two tables - for MIN and MAX.
Regards,
Andrey
Thanks i used the chart expression!