Get Free Trial

Multi-column Visualization

Answered
Patrick Berens asked on December 9, 2020

I have a dataset that is like the following:
[
{
    “id”: 1,
    “Three Goals”: “A”, “B” “D”
},
{
    “id”: 2,
    “Three Goals”: “Z”, “X” “Y”
}
]
 
I would like to visualize this using a chart where I have a count of each goal(a distribution of goal responses). Is there a way to do this?
 
I’ve tried flattening the data into “Goal 1”, “Goal 2”, “Goal 3” fields however then I can’t combine the columns’ counts into one graph. Any ideas?
Note: I can’t change the dataset to be one goal per object. So for instance, I can’t do this:
[
{ “id”: 1, “Goal”: “A” },
{ “id”: 1, “Goal”: “B” },
….
]
The reason is, we need one row per “id” due to other data we are supporting. It needs to be one id per row.

Thanks,
Patrick

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 11, 2020

Hello, Patrick,
 
Thank you for giving us some time.
 
We want to explain that Flexmonster only supports data structures where a single value is associated with a field in each separate record.
Therefore, we would recommend flattening the data as you mentioned earlier:

[
    {
        "id": 1,
        "Goal": "A"
    },
    {
        "id": 1,
        "Goal": "B"
    },
    ...
]

 
Yet, you noticed that this is not an option for you because of the other supported data.
 
As a workaround, we suggest storing a separate data set that would meet these requirements and passing it to Flexmonster. It allows to preserve and use the dataset with the initial structure.
Another option is to preprocess the data before it is passed to Flexmonster. This approach does not require storing two different versions of the same dataset.
 
Currently, it seems no alternative solution is available for this case.
 
Please contact us in case other questions arise.
 
Regards,
Illia

Please login or Register to Submit Answer