I’m trying to create a stacked column chart in MongoDB Atlas Charts, and I have an array which looks like that: surveySource: [ "Instagram" "Influencer" ] So I’m just storing the user’s response to our survey in an array, as the user can select multiple options. When trying to make a stacked chart in mongoDB […]
- Tags 'influencer', AD, and I have an array which looks like that: surveySource: [ "Instagram" "Influencer" ] So I'm just storing the user's response to our su, as the user can select multiple options. When trying to make a stacked chart in mongoDB and selecting the unwind option, e.g. so I want them to be counted not as one but as 1/array.length. For example, for example, however is there any way to make them count, I'm trying to create a stacked column chart in MongoDB Atlas Charts, Influencer - 1, instagram, Instagram - 0.83. So my chart, Instagram - 2. But I want them counted as Ad - 0.83(0.5 + 0.33) Influencer - 0.33, it count each array element as 1 "entry", let's say there are two arrays: ["Instagram", like 0.33 if the user selected 3 options total, should have float numbers., that now looks like this, with the unwind option it's counting them as follows: Ad - 2