Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
It's showing the total for 5 days but I want the total by day.
Ok, so you need to create a bar chart object with 1 dimension
WeekDay
and above expression.
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).
You can restrict the data in your script by the following
Where Datefield >=
WeekStart(Today()-2)Regards
Mhatim
Can't restrict data (used of global datamodel) and don't know how to integrate "WeekStart(Today()-2)" to the previous set analysis.. sorry 🙂