I wrote a POC on flexmonster v2.4 which worked fine. Then I recently upgraded to v2.6.1 and the csv data seems to be parsed differently, causing values to appear the same. Attached screencaps of both. Would like to know if something changed between these versions requiring a code change? Or is this a known bug? Thanks.
Here is our configuration, also attached our csv file.
var pivot4 = new Flexmonster({
container: "pivotContainer4",
toolbar: window.editMode,
height: 340,
report: {
dataSource: {
filename: "data/Agent Summary_2018.01.22.10.41.10_AgentTime.csv"
},
options: {
editing: false,
drillThrough: false,
showDrillThroughConfigurator: false,
showEmptyData: false,
grid: {
showTotals: "off",
showGrandTotals: "off",
showFilter: false,
showHeaders: false,
showReportFiltersArea: false,
fitGridlines: true
}
},
slice: {
reportFilters: [
{
uniqueName: "AgentCode",
filter: {
members: [
"AgentCode.[T10]"
]
}
}
],
rows: [
{
uniqueName: "[Measures]"
}
],
columns: [
{
uniqueName: "AgentCode",
caption: "Total Time in State"
}
],
measures: [
{
uniqueName: "Connected",
aggregation: "none",
},
{
uniqueName: "PlacedOnHold",
aggregation: "none",
caption: "  Placed on Hold"
},
{
uniqueName: "LiveConnect",
aggregation: "none",
caption: "  Live Connect"
},
{
uniqueName: "Waiting",
aggregation: "none"
},
{
uniqueName: "PreviewDialWait",
aggregation: "none",
caption: "  Live Preview Dial Wait"
},
{
uniqueName: "ACW",
aggregation: "none"
},
{
uniqueName: "Deassigned",
aggregation: "none"
},
{
uniqueName: "Paused",
aggregation: "none"
},
{
uniqueName: "Avg",
formula: "'Connected' + 'PlacedOnHold' + 'LiveConnect' + 'Waiting' + 'PreviewDialWait' + 'ACW' + 'Deassigned' + 'Paused'",
caption: "Total",
type: 5,
active: true
}
]
}
},
licenseKey: "Z7KQ-XCJ7B5-01595R-5B4D1W"
});
Hello Chad,
Thank you for providing us with the code example. That was really helpful. The behavior in the version 2.6.1 is not correct. We will add the necessary fix to the minor release on ETA Oct22.
Regards,
Dmytro
Hello Chad,
We are glad to inform you that the version with the fix has already been released.
You are welcome to update the component and try it.
Also please note, that measures cannot have aggregation "none"
. The component will automatically replace it with the default "sum"
aggregation. As for the formula configuration, the fields which are the part of the formula should also be specified with aggregations. Here is the example:
formula: “sum(‘Connected’) + average(‘PlacedOnHold’) + ...”
Please note, that you can also set the formula using our UI tools: https://www.youtube.com/watch?v=knBO74drV2s.
Let us know in case you need any other assistance.
Regards,
Dmytro