Hi,
this my data source:
{
"bookings": [
{
"bookingId": 553267,
"bookingRef": "VO20200108460",
"statusId": 1,
"status": "Confirmed",
"rating": 4,
"hotelId": 17060,
"hotelName": "Nerolia Hotel & SPA 4*",
"hotelCity": "Monastir",
"hotelCountry": "Tunisie",
"hotelAddress": "Zone Touristique Dkhila Skanes,Monastir",
"price": 160,
"arrDate": "2020-01-31",
"depDate": "2020-02-02"
},
{
"bookingId": 553258,
"bookingRef": "VO20200108460",
"statusId": 1,
"status": "Confirmed",
"rating": 4,
"hotelId": 17060,
"hotelName": "Magic Hotels Royal Kenz 4*",
"hotelCity": "Monastir",
"hotelCountry": "Tunisie",
"hotelAddress": "Zone Touristique,Monastir",
"price": 200,
"arrDate": "2020-01-05",
"depDate": "2020-01-07"
},
{
"bookingId": 553456,
"bookingRef": "VO20200108460",
"statusId": 1,
"status": "Confirmed",
"rating": 3,
"hotelId": 17060,
"hotelName": "Les Colombes 3*",
"hotelCity": "Hammamet",
"hotelCountry": "Tunisie",
"hotelAddress": "Route Touristique El Mrazga, Hammamet 8050",
"price": 92,
"arrDate": "2020-01-05",
"depDate": "2020-01-06"
}
]
}
I want to build a visualization that presents: a price comparison for a hotel unit. ie: for the same rating and the same city the area will give a price comparison for the two hotels.
in this case i want to compare the price of "Magic Hotels Royal Kenz 4*" and "Nerolia Hotel & SPA 4*" because they are in the same city and they have the same rating.
y-axe: price
x-axe: date = depDate _ arrDate (i try to calculate the date with scriptedfield but it's don't work for me)
how can i create this visualization please !