Set Analysis

[guya]

Please, how can I do that?

I would like to create a chart showing the sum of the quantity of articles received, disregarding date selected for week days.

So it will be the sum of Mon, Tue, Wed, Thu, Fri not Sat & Sun.

Same for the total of last 6 months (Sep=x, Aug=y, Jul=z, etc...)

Thank You in advance

Guy

Message was edited by: GuyA Something like this...

[swuehl]

Not sure if I got your request, but maybe like

=sum({<WeekDay = {Mon, Tue, Wed, Thu, Fri}>} Quantity)

Assuming you created a WeekDay field in the script.

[guya]

It's showing the total for 5 days but I want the total by day.

[swuehl]

Ok, so you need to create a bar chart object with 1 dimension

WeekDay

and above expression.

[guya]

Think we are on the right way 🙂 but how to get data from this or only last week because it's retrieving data since the begining (don't need week data for all years in db).

[#6]

You can restrict the data in your script by the following

Where Datefield >=

WeekStart(Today()-2)

Regards

Mhatim

[guya]

Can't restrict data (used of global datamodel) and don't know how to integrate "WeekStart(Today()-2)" to the previous set analysis.. sorry 🙂