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