Ghada Alhadlaq
Rank: #20568
1312Views
15Comments
Solved
Need Help in in Line Chart - Booking Project
Question
RichWidgets

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?


1
0
on 2018-03-15
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2
Solution

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?

See solution in context
3
0
on 2018-03-15
Copy link to comment
Ghada Alhadlaq
Rank: #20568

Kilian Hekhuis wrote:

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?



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!

2
0
on 2018-03-15
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

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:

3
0
on 2018-03-15
Copy link to comment
Ghada Alhadlaq
Rank: #20568

Kilian Hekhuis wrote:

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 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 :



2
0
on 2018-03-15
Copy link to comment
Lander De Wulf
Rank: #1698

Thanks all, you helped me al lot with this.

0
0
on 2019-03-20
Copy link to comment
João Pedro Batista
Staff
Rank: #752

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


0
0
on 2018-03-15
Copy link to comment
Ghada Alhadlaq
Rank: #20568

João Batista wrote:

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



Hello João,

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

Thanks.

0
0
on 2018-03-15
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2
Solution

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?

3
0
on 2018-03-15
Copy link to comment
Ghada Alhadlaq
Rank: #20568

Kilian Hekhuis wrote:

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?



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!

2
0
on 2018-03-15
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

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?

0
0
on 2018-03-15
Copy link to comment
Ghada Alhadlaq
Rank: #20568

Kilian Hekhuis wrote:

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?

Thank you for helping me
I appreciate that : )

0
0
on 2018-03-18
Copy link to comment
Lisa Anderson
Rank: #5507

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?

1
0
on 2019-01-30
Copy link to comment
Amal Chouchene
Rank: #8304

Hello Lisa could you please share with us the preparation for building this graph. Thanks

0
0
6 days ago
Copy link to comment
Lisa Anderson
Rank: #5507

Replying to Amal Chouchene's comment on 24 Feb 2021 16:37:48

Hi Amal - I figured out my issues (see below comment).  That said if you need to see my prep of the working prep, I unfortunately cannot help out.  I no longer have access to the environment where I built the booking project.  Sorry!

1
0
6 days ago
Copy link to comment
Lisa Anderson
Rank: #5507

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!

2
0
on 2019-02-04
Copy link to comment
Giang Nguyen
Rank: #14732

It does help! Thank you!

0
0
on 15th Feb
Copy link to comment
Donis Sousa
Rank: #4529

transks

0
0
on 2019-12-18
Copy link to comment