an Aggr question

[#1]

Hello,

I am stucked in a aggr task, so i really appreciate any help.

I have a table like this:  Dimension1, Dimension2, ..., DimensionN, Day     (Day is a Date field and can be empty), and I am trying to measure the eficiency of the activity, in terms of how many registrations per day you can do the same day. The aim is a table/chart like this, which would mean, for instance, that there are 198 days in which you were able to do 3 registrations in the same day.

Actions per day     Number of days

1                         87

2                         115

3                         198

4                         53

etc                        ...

Thanks.

Marc.

[tresesco]

Could you post a sample qvw?

[Anonymous]

Marc,

See my answers here: http://community.qlik.com/message/478904#478904

Regards,

Michael

[#4]

Posted.

[tresesco]

Qvw is empty(front-end). Reload; save; reupload.

[#6]

Thanks Michael, I did it!

[Anonymous]

Hello, Marc

Using your data, I would use this calculated dimension:

=Aggr(Sum(ContadorVisita), FechaVisita)

And this expression:

Count({$<ContadorVisita = {">0"}>} Distinct FechaVisita)

I've attached an example QVW.

Bruno.

[#8]

Great. Thanks