Hi all,
If I transmit a multi-value field to Hawkeye, the table gets some pretty messy looking data. e.g. I've got a field where the user has selected two items: Apples and Oranges. The data transmitted to Hawkeye looks like this:
{"__metadata":{"type":"Collection(Edm.String)"},"results":["Apples","Oranges"]}
My question is what is the best way to manage this data? Do we manipulate it so it's nicer before we send it to Hawkeye or do we do something with it using PowerBI (or your BI tool of choice)? Let's make the assumption that we want to report on how many apples were selected given a particular set of filters.
Cheers,
Chris
