Excel to quicksight formula conversion

Question & Answer
, , , ,
1

I have an excel formula for a column ITEMS =COUNTIF($J$2:J2,J2) and this J column is
J column
J column

Now I want a formula to convert it into quicksight . Can anyone help me in it ?

2

image
I want output like this for ITEMS column which formula I can use here please help me !!

rank([field name ASC],,PRE_AGG)
countOver({Qm Evaluation Answers Evaluation ID},[{Qm Evaluation Answers Evaluation ID}],PRE_AGG)

I am not getting desired output , tried above formulas. PLease some one help me quickly

3

I think you should try ,

runningCount
(
count({Qm Evaluation Answers Evaluation ID}),
,
[{Qm Evaluation Answers Evaluation ID}]
)

for details

4

runningCount
(
count({Qm Evaluation Answers Evaluation ID}),
,

[{Qm Evaluation Answers Evaluation ID}]
)

This is the correct formula you want me to apply ?

5

giving me syntax error check its correct syntax but still not working

6

I want numbering like if we have evaluations Id as 0025a001-8826-4fe6-924b-5aecfa11def6 and it is occuring 18 times then ITEMS column should give numbering from 1- 18 and in the evaluations Id next values comes then ITEMS should be counting it again from 1- 18 like this for this pattern I want proper solution .

7

Hi @Samiksha

Try this

runningCount (count({Qm Evaluation Answers Evaluation ID}),
[{Qm Evaluation Answers Evaluation ID} ASC], [{Qm Evaluation Answers Evaluation ID}])

Thanks

3 Likes
8

Hi @Samiksha,
It’s been awhile since we last heard from you, did you have any additional questions or did the last response help with your solution?

If we do not hear back within the next 3 business days, I’ll go ahead and mark as solved.

Thank you!

9

Yes yes it is a solution , I am sorry was busy in delivering priority things so could reply here . Thanks for the response.

1 Like