Update : rankrev will be deprecated long term.
Best practice is to use rank() scan [T.N desc]
Using keyword desc enables using any sortable type while a minus sign would not.
One should not have /.navlogo.png in the root folder of the account but in "/static/navlogo.png"
You can also use over to do rolling aggregation on another table than Day.
Ex: Month.NetAmountLast2Y= sum(Month.NetAmount) over month = [-23..0]
Ref 10095235 and linked SKUs do not exist, it should be 10095232 (2 at the end instead of 5)
To complete this, ranvar values are bounded to 67108800 (roughly 2^26), enabling ranvar to have a bounded storage need.
Creating a ranvar with values outside of this bound will raise error "Cannot create ranvar with domain [x .. y]".
If you want to rank in decreasing order, you can either:
1 - scan with a minus sign
table T = with
[| as N |]
[| 0 |]
[| 1 |]
[| 2 |]
[| 3 |]
T.rk = rank() scan -T.N
show table "" a1b4 with
T.N
T.rk
2 - Use rankrev function (not documented but similar to rank function)
table T = with
[| as N |]
[| 0 |]
[| 1 |]
[| 2 |]
[| 3 |]
// equivalent to rank() scan -T.N
T.rk = rankrev() scan T.N
show table "" a1b4 with
T.N
T.rk
If you want to rank in decreasing order, you can either:
scan with a minus sign
```envision
table T = with
[| as N |]
[| 0 |]
[| 1 |]
[| 2 |]
[| 3 |]
T.rk = rank() scan -T.N
show table "" a1b4 with
T.N
T.rk
```
or use rankrev function
table T = with
[| as N |]
[| 0 |]
[| 1 |]
[| 2 |]
[| 3 |]
// equivalent to rank() scan -T.N
T.rk = rankrev() scan T.N
show table "" a1b4 with
T.N
T.rk
As of July 2024, the limit of exported files is 200.
Langserv may suggest to use join(T.A, G.S) instead of join(T.A; G.S). One must use a ; and not a coma.
"The markdown datatype is restricted to the Scalar table." is not valid anymore. You are now able to have sliced markdown tiles. You must however use Slices table.
The value of alpha in this example is very high. I would suggest to use a value close to 0.05 (depending on how much you want your sales are correlated).
Some details on what is expected when using "FTP/SFTP shares" :
Password is not needed if you are using ssh key.
Don't forget the prefix in your ssh key, for examples "ssh-rsa ABC123........."
Prefix Path can be specified if you want to grant access to a specific subfolder. Depending from which folder from Files you are sharing, you will have to use it or not. Leaving it blank makes current folder the root folder for the user.
User name generated should look like accountId_userId