Count Registers By Date

[Anonymous]

Hello,

I have the next fields:

Date, Field1 and Field2 (not Count)

And I need a table like that:

The issue is that I dont have the field count in my data model.

Is it possible somehow build a table like this without calculate this count field in the script?

Thank you,

Sara

[sunny_talwar]

May be create the Count field like this:

LOAD Date,

          Field1,

          Field2,

          AutoNumber(Field1, Date) as Count

FROM Source;

or

LOAD Date,

          Field1,

          Field2,

          AutoNumber(Field1&Field2, Date) as Count

FROM Source;

[Anonymous]

Thank you, It works. But there is another way to build this table without scripting?

[sunny_talwar]

You can probably add a calculated dimension, but will have to test it out. Can you share a sample?

[sunny_talwar · Accepted solution]

Try this as dimension:

=Aggr(RowNo(), Date, Field1)

[Anonymous]

I attached the qvw example. Thank you.

[sunny_talwar]

I assume this was in moderation and just went through? The issue is resolved right?

[Anonymous]

That was it. Thank you

[Anonymous]

Hello,

One doubt, my real data model contains dates with hours, I try with that :

=Aggr(RowNo(), floor([Date]), Field )

But it doesnt work.

Thanks

[sunny_talwar]

There could be another issue unrelated to the date field. Not sure what it can be without take a look. Can you share a more comprehensive sample where it isn't working?