Hi, is it possible to create dynamic columns using filters to aggregate data?
For example, I have 5 types of rooms, I want to generate the column containing the availability of:
All type of room;
double and quadruple rooms;
suites ans Single room;
suites and Appartments.
All room | double+quadruple| Suite+Single | App. |
10 | 4 | 2 | 4 |
Thank you for your question.
In case the desired data set contains only available rooms, the desired functionality can be achieved by creating the calculated value based on the
count aggregation of the field, representing the type of the room. Please check out an example demonstrating such an approach.
If the data set you want to display contains both available and booked rooms, we can recommend adding the calculated value based on the formula with condition. Such an approach requires the presence of a property that would represent the availability of the room within each member.
More information about calculated values can be found following the link: Calculated Values.