'Is there a way to automatically map data items in MongoDB Charts
We collect data from various wearable devices some of which give us the same thing but with different capitalisation (e.g. "Walking", "walking", "WALKING") which Google Data Studio then classes as different items.
At the moment we use MongoDB charts to create tables of data to extract and then upload into Data studio (I know we at some stage need to implement a decent ETL layer and data warehouse but we're not there yet.)
Is there a way to create a custom field in MongoDB Charts that would map this data to a predefined set of items (in the example above all would map to "Walking")?
My presumption wold be that we could use an MQL Query to do this but ive not used MQL at all in the past.
at the moment we have been manualy extracting the data and then performing some very basic find / replace in excel before then uploading to Data Studio. It works but its not scaleable.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|