Can i have an analysis with two dataset joined with dataset A have fixed running dates and dataset B have calculate fields process aggregation based on each dates in dataset A?

[irvine.loo]

I’m wondering if quick sight able to produce analysis report in this format.

With this as dataset with structure of data in the sample

The visual output will be in this format with the user select the month & year where series of dates by row set into table column Date and the calculated fields will compare against the Date to calculate how many rooms stay between check-in and check-out date:

Not sure whether parameters, join, dataset, filters or visual is the limitation but this doesn’t seems possible.

Hope someone can give guidance.

Thanks

Irvine

[irvine.loo]

Thank to anyone that maybe looking into this and try to help.

I have solve it my own but if anyone would like to find out how this can be done, do let me know.