2 Replies Latest reply on Nov 8, 2018 5:49 AM by Garima Vohra

# How to get the value of a field when only its position/index is known?

Hello,

I am trying to do quartile chart for which i have 3 functions for 3 quartiles so far :

25thQ = Total(Count(ItemCode)*0.25  result 251

50thQ = Total(Count(ItemCode)*0.50 result 502

75thQ= Total(Count(ItemCode)*0.75  result 702

Now, I need to show the "time to complete" (this is a field in days e.g. 10 days, 15 days) for the items whose positions i found above from the quartile calculations. How do I pull the value of a field(time to complete) for an item for which i know only its position number or index number?

Again, I want to display the value of "time to complete" for the 251st, 502th and 702th item in my data. What function or calculation can i use?

Thanks,

Garima

• ###### 1. Re: How to get the value of a field when only its position/index is known?

Will this not Work?

INDEX()=Total(Count(ItemCode)*0.25

OR

INDEX()=Total(Count(ItemCode)*0.50

OR

INDEX()=Total(Count(ItemCode)*0.75

If you drag it to Filter and Select True and Time to Complete on Rows..Just not sure..Just an Idea.

Thanks

Deepak

• ###### 2. Re: How to get the value of a field when only its position/index is known?

It worked Deepak! Thank you so much