I am trying to create a pivot report using a dataset which contains two text fields and one numeric field called ‘Count’. – some items in the data array have the same value for both text fields (‘NoMatch’). If I create a report slice with a single measure called “Count”, and set the aggregation to ‘sum’, the resulting pivot seems to ignore this and sets the aggregation to count. I have tried renaming my field and measure to something other than count but this did not help. This only seems to occur when the data contains ‘NoMatch’ values in both text fields.
I have made a jsfiddle to illustrate the problem, and have attached a JSON example report:
Thank you for writing to us. Such things happen when the data types are not explicitly defined.
Please refer to the following article: https://www.flexmonster.com/doc/data-types-in-json/.
Also, here is the jsfiddle example: https://jsfiddle.net/flexmonster/smya6b57/.
That’s brilliant, works perfectly. Thanks again for your help!