What is wrong with aggregation ?

system · March 19, 2014, 2:43pm

Hi,

I would like to know what happend because i’m going crazy about BO.

I would like to mix the both graphs. I would like to order results in :

Ascending by date.
Group “Nombre d’événement” by day.

Thank you in advance for your help,

Rémi

remi_i (BOB member since 2013-03-18)

system · March 19, 2014, 4:17pm

Hi,

When you use formatdate your transforming a date variable into a text one. If you check how text variables are ordered you will notice that
“18/02/2014” is greated than “01/03/2014”, try using the the date variable coming from the query.
Cheers,
Rogerio

rgoulart (BOB member since 2011-08-21)

system · March 19, 2014, 4:24pm

Hi Rogerio,

I did it see “Raw” screenshots, I does not aggregate.

remi_i (BOB member since 2013-03-18)

system · March 19, 2014, 4:27pm

Okay, can you share you raw data as an excel file ? And tell us what goes in the chart ?
Thanks,
Rogerio

rgoulart (BOB member since 2011-08-21)

system · March 19, 2014, 4:57pm

Hi,

I would like to be able to have the same graph as “With FormatDate” but be able to order ascending.

remi_i (BOB member since 2013-03-18)