AnsweredAssumed Answered

Suggestions for dealing with multi-value fields

Question asked by chris.ben Champion on Nov 28, 2017
Latest reply on Nov 28, 2017 by chris.ben

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

Outcomes