Can I use `SELECT MIN(someAttr)` where `someAttr` ...
# gooddata-platformt
Thomas Karbe
04/27/2023, 3:33 PMCan I use
SELECT MIN(someAttr)someAttrThomas Karbe
04/27/2023, 3:45 PMOr more concrete: Lets assume I have given a fact table with a running
transaction numberaccount numberbalance Copy code
account number | transaction number | balance
1 | 101 | 100
1 | 102 | 300
1 | 103 | 50
2 | 101 | 0
2 | 102 | 300
2 | 103 | 500Thomas Karbe
04/27/2023, 3:45 PMthe transaction number is indicating the order of transactions within one account
Thomas Karbe
04/27/2023, 3:46 PMHow could I build a metric that gives me the balance for the smallest transaction number (aka at the beginning of the selected period)
Thomas Karbe
04/27/2023, 3:47 PM Copy code
account number | transaction number | balance | start balance
1 | 101 | 100 | 100
1 | 102 | 300 | 100
1 | 103 | 50 | 100
2 | 101 | 0 | 0
2 | 102 | 300 | 0
2 | 103 | 500 | 0Thomas Karbe
04/27/2023, 3:47 PMso, a result like this one
Thomas Karbe
04/27/2023, 5:29 PMplease disregard. I solved it by turning transaction number into a fact
🙌 1
m
Moises Morales
04/27/2023, 6:28 PMHi Tomas, it’s also possible to get the dates of the latest/earliest values in a dataset. I recommend reading: How can I custom a attribute or metric in Date format? | The GoodData Community and Finding Min and Max Dates Using Date Arithmetic | GoodData Classic
t
Thomas Karbe
04/27/2023, 6:34 PMI knew those, but we had date granularity with multiple transactions per day, so the transaction number was on a finer grain
✅ 1