asked on December 31, 2020
If we have a set of data
headers: location, data
"A--1", 1
"A--1", 1
"A--2", 1
"B--1", 1
"B--2", 1
Where "A--1" is a simple text field that represents building A and room 1 (-- is a delimeter)
is there a way in flexmonster to process the data so it groups it based on building? (i.e. transform the text in location column with some function (e.g. substring before the --) before doing the aggregations?
e.g. the above would aggregate to
A, 3
B, 2
⋅ January 4, 2021
Hello, Michael,
Thank you for your question.
We want to explain that the data can not be transformed after it is loaded to the component. Flexmonster will treat "A--1" and "A--2" as different members.
We suggest preprocessing the dataset in the way the building and room are different fields, for example:
Building, Room, Value A, 1, 1 A, 1, 1 A, 2, 1 B, 1, 1 B, 2, 1
This transformation would allow achieving the desired aggregation results.
Please let us know if it works for you.
Feel free to contact us in case other questions arise.
Kind regards,
Illia
