We have a dashboard panel(table) where we are trying to retrive data to display on table where we group by:
merchant.name
sale.currency
payment.currency
See image
However we are seeing that the result is returning more than 1 value, in our case 45 and 145.
{
"labels": {
"merchant.name": "mymerchant",
"payment.currency": "AUD",
"sale.currency": "EUR"
},
"labelsArray": [
{
"merchant.name": "mymerchant"
},
{
"payment.currency": "AUD"
},
{
"sale.currency": "EUR"
}
],
"values": [
{
"timestamp": 1711378057000,
"value": "45"
},
{
"timestamp": 1711378057000,
"value": "145"
}
]
},
We believe this is down to sale.currency and payment.currency could be same and its looking at the label value
e.g. Sale and payment can result in EUR to AUD and AUD to EUR
So in our table it is displaying EUR to AUD with 45, when in fact it is 145. and not displaying AUD to EUR in table.
Is there any solution to this?
