# data[].attributes.attachment_caption
A dash was displayed for Jurong East and Sengkang as there are more than one block with the highest transaction value

# data[].attributes.body
There’s null (“-“) value because there’s more than 1 block with the same number of highest transaction.

# data[].attributes.body
Resubmitted as did not log in padlet account in previous submission.

# data[].attributes.attachment_caption
how to fix this if more than one block has the same highest number of transactions?

# data[].attributes.body
As there are more than one block with the highest number of transactions.

# data[].attributes.attachment_caption
The null values indicate more than one block has the highest number of transactions in the town.

# data[].attributes.body
There is more than one block with the same transaction value.

# data[].attributes.attachment_caption
There are more than 1 block with the highest number of Transaction

# data[].attributes.body
Those values are blank as they are not distinct, hence there are more than one value.

# data[].attributes.body
Null denotes the town has more than one block with the same number of highest transaction.

# data[].attributes.body
Null value due to more than 1 block with the most number of transactions

# data[].attributes.body
wk17 QS(lamhm)

# data[].attributes.body
Week 17 Task Mohd Ibrahim

# data[].attributes.body
Answer to question in the weekly task

The reason why there are blanks in the "Block No." for Jurong East and Sengkang is because there are more than one block with the highest number of transactions. It was implemented using the function FirstSortedValue, which returns NULL when there is more than one resulting value that shares the same sort_weight. See documentation of FirstSortedValue for more details.