Need Help in in Line Chart - Booking Project

Hello, 

I'm working on a Booking Project, at this part

Assignment 12: RichWidgets

4. Display the Occupancy for the Next 7 Days Issue

at c), which is 

In the Preparation, create the logic to build the data to be plotted on the chart:
• Get all Rooms in the hotel, to calculate the percentage of occupancy.
• Use a Local Variable to hold the Date to which the occupancy is calculated. The Variable should start on today’s date.
• If the Date in the Local Variable is within the next 7 days:
i. Get all Rooms Booked or Checked In on the date.
ii. Build a DataPoint with the percentage of occupancy for the date.
iii. Append the DataPoint to a List of Data Points.
iv. Add one day to the date on the Local Variable.
v. Define the flow to return to the If.

in the preparation of home screen, I create aggregate to get all rooms with (booked-check-in) status and I create a local variable TodayDate with currDate() as a default value.

But I did not understand what should I do then, could someone help me? 

and what should I assign to the SourceDataPointList in Line Chart?

Hi Ghada,

I allow that the description is a bit unclear :). What you need to do is build a loop that creates a list of DataPoints, for today and the next 7 days, something like this:

Hello Ghada,

• You have to use your Local Variable as a Filter in your Aggregate. 
• After completing the 5 steps (i to v) add one day to the Local Variable
• Check if the Local Variable is still lower than `CurrDate()+7` (within the next 7 days): 

  True- complete the 5 steps, then add one day to the Local Variable; 

  False- move on to step d)

Regarding the chart itself maybe these examples in documentation will help you. 

Kind regards

Kilian Hekhuis wrote:

Hello Kilian, 

I will show you what I do 

I did not create any logic like this before so I need a help on how to doing that

 I assign to the SourceDataPointList in Line Chart to be equal DataPointList

This is the flow of Home preparation:

and the local variable I have are :

and here is my work

but I think my problem in the aggregation which I create it like this:

and the result of my work is :

João Batista wrote:

Hello João,

could you please see my replay above, and respond to me if you can :)

Thanks.

Hi Ghada,

These are my filters:

(the last one says Entites.Status.CheckedIn). Is that the problem with your filter, that you need a valid (non-empty) CheckOutDate?

Kilian Hekhuis wrote:

I make this change then my result was changed which is:

in the assign, before ListAppend I make these assignments:

and my filter is the same as previous so my result is:

do you think my result is correct!

The result is correct if it displays the correct data. I don't know what's in your database :). Just debug it a little, and you'll find the numbers, right?

Kilian Hekhuis wrote:

Thank you for helping me
I appreciate that : )

This was an extremely helpful exchange as I struggled with this part of the Bookings Assignment.  My graph looks accurate, except for my Y Access.  I can't figure out why?  What am I missing?  Also is the expectation that if a room is checked out it will update the chart immediately?

I figured it out.  I forgot to tie back the YAxis Format action to the chart.  Once completed then all was good to go.  Thank You!

Thanks all, you helped me al lot with this.

transks