Get value of a certain record as a measurement for KPI chart

[CajaRobotics]

Hi,

I looked all over the forums and tried a billion combinations and yet nothing helped.

So im going to ask here & i hope someone will be kind enough to help me.

I have 2 different tables.

Table A: has only  1 record (its an aggregation SQL query that i loaded via a script).

Table B: has multiple records.

I want to display a KPI chart (or widget) that displays the value from Table A and also the value from the record before last of Table B.

I tried everything, lookup() does not exist, last() does not work,  if() didnt help, above() did not help. the only thing that sorta worked was using only() like so:

Only({<Date={'08/18/2020'}>} [Total Downtime (hr)])

but im trying to find a way which is automatic, otherwise i will always have to log in and change the fx by hand, i wanted to do something like this:

Only({<Date={'0'&Date(Today(1)-1)}>} [Total Downtime (hr)])

which essentially get the data means, get the corresponding data in table B from yesterday.

I also tried setting a variable to '0'&Date(Today(1)-1, i can see that the variable indeed gets the desired text, however only() function doesnt work with it either.

Any help would be appreciated.

Thanks,

Caja