Top Nth value in text object

[Anonymous]

Hi All,

We have a chart, where we have kept the dimension limit as 7.

We want to showcase the 1st to 7th value in three different text objects, from the chart.

I have used the FirstSortedValue() function, and it works fine for 1st to 4th.

For 5th, 6th and 7th value, it giving me 'Null' values in text object, as all of them have same metric value.

As per one of the post, I have tried to use 'DISTINCT' keyword, still values not matching with chart.

Could you please assist me on same.

Thanks & Regards,

MK

[Anonymous]

yes

[sunny_talwar]

Would you be able to provide a sample?

Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

Nope I tried to do same, but, in that case, I will need to change the expression values as well

[sunny_talwar]

You mean when you try to create a sample using the method mentioned in the link you will have to change the expression? I don't think so

[Anonymous]

I think we cant do that,

Re: FirstSortedValue on Calculated Position

[sunny_talwar]

Unless we see what you are seeing right now, it would be very difficult to comment. But if you think your scenario matches with that guys scenario, then it might be right. Again, very difficult to say without seeing it.

[sunny_talwar]

Would you be able to provide 10-15 lines of raw dummy data and your expected output from the data that you provide?

[Anonymous · Accepted solution]

Thanks to all, for your reply.

finally I found a solution using below link:

Displaying the Top Salesperson in a Textbox

Just a change in the expression of Rank, we will have to add the Offset value as 4, to get the value in text object.