For me, Celambarasan Adhimulam's answer was the best answer: usage of FirstSortedValue( ).
The final expression I now use is:
The proposed solution with
did'nt work as expected, since the date column could have multiple records with the same value (like 4 records having value 31-12-2010). In that case, the "correct" record to pick is the one with the highest sequencenumber.
That sequencenumber is a column that I now load additionally in the loadscript...
Thanks for all the help!
Hi Celambarasan Adhimulam and jagan mohan,
Thanks for your directions! Unfortunately (as far as I see now...) it is not a solution for me.
- The aggr() function looked most promising to me but results in a chart displaying no values
- the firstSortedValue seems to work in _exactly_ my example, but not in my project.
I have attached a testproject with some more data (don't worry, it is only 16 records x 4 columns). Here I have modeled both options you provided (aggr and firstSortedValue) and there it is visible that it doesn't work.
What am I doing wrong?
testProjectAggregation.qvw 140.8 K