I used lastvalue command to extract string for my ABS high Name
lastValue(site, [{cost %} ASC], [Company])
And for Abs Low Name
lastValue(site, [{cost %} DESC], [Company])
What i got in the red box is correct and I am also expecting it to show in the FEDEX row, instead it is showing FOL165 and LOF214 while I also want it show OLF555 and BCA201
Hi @Adebayo_Desile,
In your visual field well, how do you have the aggregation setup for those 2 columns, could you provide a screenshot like the one below?
Hi @Adebayo_Desile,
I wonder if it has something to do with the cost % aggregation when rolling up to the company; is ‘cost %’ a calculated field, and if so, could you share it?
No, it is not a calculated field.
Hi @Adebayo_Desile,
Sorry I missed your last reply, if you tag the person you’re replying to by using the ‘@’, they’ll get notified of a response!
The Abs High Name and Abs Low Name look to be calculated fields if they have a custom aggregation, I wonder if it has something to do with the grouping in those fields? If you’re still encountering this issue, could you share those calculated fields. Or if you could recreate a sample analysis in the Arena view, that could be the easiest way for us to further assist.
One alternate option you could also explore if the totals aren’t showing up accurately, you could change the ‘Totals:’ from default to none, which will remove them from your table as to not show incorrect information.
Hi @Adebayo_Desile,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Adebayo_Desile,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!
