Chart Calculations

[#1]

Hi All

I need some help...

I have a in my model fields ("Folder","File", "Reviewer" and "Reviewer Number" [ie. Reviewer 1, Reviewer 2, Reviewer 3, Reviewer 4]).

Each file gets reviewed and can be reviewed more than once by one or more people.

I now need to create some intelligence to see each file that was reviewed more than once by the same person and how many times.

How can I achieve this?

[simondachstr]

You'll need an aggregated expression..

aggr(count(File),[Reviewer Number],File)

This expression will calculate the number of times each reviewer has reviewed each file. If you need a conditional show you can consider adding an if statement

e.g. Show all files that has been review by the same person more than once:

if(aggr(count(File),[Reviewer Number],File)>1, File)

I haven't tested the above, but theoretically it should work.

[#3]

Hi Martin

Thanks for your assistance.

I applied this instead and it seems to be working

(Aggr(Count([File),[REVIEW NUMBER],[File])>1,SUM([REVIEW NUMBER]))

only problem is I can still see records of files only reviewed once.

Do you know this is the case?

[simondachstr]

Use the "suppress when value is zero" setting in the chart properties

[#5]

It''s already selected. The thing is, I only want to see records where file is reviewed more that once

[simondachstr]

try suppressing nulls maybe.. the above conditional expression you've stated is already sorting out the ones which have not been reviewed more than once.