topic show only the first row in a simple table in App Development

show only the first row in a simple table

zied_ahmed1 — Mon, 18 Nov 2019 14:01:56 GMT

Hello,

I have the list of tasks completed and i need to show only the last one (so the last row )

for example in this table I need only to show Construction and the date (first record)

Thanks

Stoyan_Terziev — Mon, 18 Nov 2019 14:59:34 GMT

Hello Zied,

I presume that's a table with dimension 'Task Name' and measure Max(Finish Date).

Go to the dimension and select Limitation -> Fixed Number -> Top -> 1

Make sure to uncheck 'Others'.

I hope that helps!

Kind regards,

S.T.

zied_ahmed1 — Fri, 13 Dec 2019 13:01:04 GMT

this is the solution :

left join
load Distinct
//Risque_id,
Date(min("date_birthday"),'DD/MM/YYYY') as "TXT Date",
1 as flag

resident Table1;