Hello,
My goal is to sort my data by timestamp, but I canโt figure it outโฆ
I tried doing that:
SELECT(Quote[Title], in([Timestamp],SORT(SELECT(Quote[Timestamp], isnotblank([Title] = [_THISROW].[Title])), false))).
I thought that using sort() like that would change the list and put it in order but it doesnโt. It is the same as if I did Quote[Title]. I was told to use ORDERBY() but even with it I canโt figure it out.
Any suggestion would be appreciated!
Solved! Go to Solution.
Replace the entire ORDERBY() expression I provided earlier with this:
ORDERBY(
FILTER("Quote", TRUE),
[Timestamp],
FALSE
)
Then use this as your Suggested values expression:
([Ordered Quotes][Title] - LIST(""))
To do this, youโll need to add a column with an App formula expression like:
ORDERBY(
FILTER(
"Quote",
AND(
ISNOTBLANK([Title]),
([Title] = [_THISROW].[Title])
)
),
[Tiestamp],
FALSE
)
If the column above is named Ordered Quotes, you could then get the ordered list of quote titles with this expression:
[Ordered Quotes][Title]
Can the new column be a virtual column?
Because if it is the case, it is not working. I put the formula in the virtual column, and then did โ[Ordered Quotes][Title]โ in the suggested values of Title and I end up with nothing in the app.
Yep.
Please post a screenshot of the columnโs configuration.
Open the App formula expression and try the Test button. Does it produce the results youโd expect? It should be a list of key column values of the rows of the Quote table that have the same Title value, in Timestamp order.
I think I didnโt explain correctly my goal. What Iโm trying to do is showing the previous quotes made in title pretty much like that.
The issue I have is that it is not sorted the way I want. I want the most recent ones on top and the oldest ones on the bottom.
So youโre getting results, but theyโre sorted in the wrong way? In the ORDERBY() expression I gave you previously, change FALSE
to TRUE
:
Weirdly, now that I put TRUE, It is not showing anything, and if I put it back to FALSE itโs not showing anything eitherโฆ
I see I made a typo in my expression: [Timestamp]
was misspelled as [Tiestamp]
. I assume you corrected that?
Please post a screenshot of the complete ORDERBY() expression youโre now using (that isnโt working).
I feel like the problem is โ[Ordered Quotes][Title]โ in the suggested values that does not affect it correctly.
Please try the Test button. Is the expression producing a list of key column values of the desired rows in the desired order?
No, whether it is TRUE or FALSE, it is not showing in the desired order.
Okay. Youโre trying to generate a list for Suggested values, right? For which column are these suggestions?
Yes, I want it in Title. So I want Title to have suggested values of Title ordered by Timestamp. I hope it makes sense
Replace the entire ORDERBY() expression I provided earlier with this:
ORDERBY(
FILTER("Quote", TRUE),
[Timestamp],
FALSE
)
Then use this as your Suggested values expression:
([Ordered Quotes][Title] - LIST(""))
Alright! It works, I just had to change FALSE by TRUE.
Thank you very much!!
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |