Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i'm quite new on QV. Is there any possibility to show a dimension row in a text object?
eg. last row.
have tried something like: =text(only({1<f_timestamp = {'$(=Max(f_timestamp))'}>} facebook_message))
...but this doesn't work.
I would like to have my outcome like following
Date: 07/03/2015
Text: Some text from the last row
(I don't want them to be side by side as in a straight table)
hope someone understand what i am trying to accomplish
Thankful for any help!
/Pierre
=text(only({1<f_timestamp = {'$(=Max(f_timestamp))'}>} facebook_message))
This could work, you probably just need to format the max(f_timestamp) according to your field format, something like this using your format code
=text(only({1<f_timestamp = {'$(=Timestamp(Max(f_timestamp),'YYYY-MM-DD hh:mm:ss'))'}>} facebook_message))
or maybe even easier, try
=FirstSortedValue( facebook_message, -f_timestamp)