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

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

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

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

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

I think you should try ,

runningCount

(

count({Qm Evaluation Answers Evaluation ID}),

,

[{Qm Evaluation Answers Evaluation ID}]

)

for details

runningCount

(

count({Qm Evaluation Answers Evaluation ID}),

,

[{Qm Evaluation Answers Evaluation ID}]

)

This is the correct formula you want me to apply ?

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

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 .

Hi @Samiksha

Try this

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

Thanks

1 Like