Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Creating dynamic columns using aggregation filters

Answered
Francesco Arena asked on January 3, 2020

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.
Es.

All room  |  double+quadruple| Suite+Single |  App.      |
10          |   4                       |   2                |   4          |

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 6, 2020

Hello, Francesco,
 
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.
 
Regards,
Illia

Please login or Register to Submit Answer