Data file parsed incorrectly

Answered
Yuliia asked on January 14, 2019

Hello. I have downloaded flexmonster via npm and start integrate it in my Angular app, but find the weird behavior. When i try to load data file from the local machine everything looks as it was configured. But when i load the same file as inline json and update grid asynchronous it builds differently an looks like slice doesn't apply at all. Please find screens file attached.
 
Here is my config file:

{
"dataSource": {
"dataSourceType": "json",
"browseForFile": true
},
"slice": {
"rows": [
{
"uniqueName": "Shelf"
}
],
"columns": [
{
"uniqueName": "Warehouse"
},
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "Product",
"aggregation": "count",
"availableAggregations": [
"count",
"distinctcount"
]
}
],
"drillThrough": [
"ServiceRequestId",
"Product",
"SN",
"Comment",
"Act"
]
},
"options": {
"grid": {
"showGrandTotals": "columns"
}
},
"conditions": [
{
"formula": "AND(#value > 0, #value < 3)",
"measure": "Product",
"format": {
"backgroundColor": "#8BC34A",
"color": "#000000",
"fontFamily": "Arial",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 3, #value < 10)",
"measure": "Product",
"format": {
"backgroundColor": "#F1F8E9",
"color": "#000000",
"fontFamily": "Arial",
"fontSize": "12px"
}
},
{
"formula": "AND(#value > 10, #value < 20)",
"measure": "Product",
"format": {
"backgroundColor": "#FFEBEE",
"color": "#000000",
"fontFamily": "Arial",
"fontSize": "12px"
}
},
{
"formula": "#value >= 20",
"measure": "Product",
"format": {
"backgroundColor": "#EF9A9A",
"color": "#000000",
"fontFamily": "Arial",
"fontSize": "12px"
}
}
]
}

Am i doing something wrong?

1 answer

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 14, 2019

Hello Yuliia,
Thank you for your question. The provided report looks correct when you need to load the data from the local storage.
Still, it is not enough to indicate the reason for such behavior.
Therefore, could you please provide us with the code example which you use to create and update the grid? That should give us some more guidance on what is wrong.
Waiting for the update from you.
Regards,
Dmytro

Please login or Register to Submit Answer