asked on May 20, 2020
Hi,
I'm having an issue when I have 2 "running totals of columns" on flexmonster.
I created a simple report to demonstrate the problem.
first col : 1, 2, 0, 3, 4
second col : 5, 6, 7, 0, 8
As you can see on the demo, with my file, the data is mixed up. Data of one column are used on the other and value "0" also create other kind of issues.
I noticed that when I change the order of values in "fields", the values also changes.
https://www.flexmonster.com/demos/js/pivot-table/
EDIT : Why there is "running totals of columns" on your demo but there is no such option on the latest version on npm ? (react-flexmonster 2.8.7)
How can we fix this issue ?
Thanks,
Kevin
⋅ May 22, 2020
Hi Kevin,
Thank you for writing to us.
We've checked this on our side and we can see there's indeed an issue with running totals column values not being calculated correctly in certain circumstances. We are going to investigate this further and provide a fix with the upcoming release ETA Jun 15th.
Speaking of your second question, we didn't manage to reproduce the described behavior – the “running totals of columns” aggregation is available in Flexmonster instances integrated with React. Please try using the npm i flexmonster command and use the Ctrl + Alt + I keys combination on the pivot table page to make sure your copy has been updated correctly.
Feel free to reach out if you have any further questions we can help you with.
Best regards,
Mykhailo
⋅ May 22, 2020
Hi Mykhailo,
Thanks for your response. We were able to upgrade to the latest version by cleaning the yarn's cache.
We're currently evaluating Flexmonster. In case you fix the bug before June 15th, are you able to provide a temporary build that we could test before the official release ? That way, we would be able to confirm that Flexmonster really fit our needs.
Thanks !
Kevin
⋅ May 25, 2020
Hi Kevin,
Thank you for the heads up!
Sure, we will make sure to let you know in case the fix is available sooner.
We'll keep you posted.
Regards,
Mykhailo
⋅ June 2, 2020
Hi!
We are happy to let you know that the issue with multiple columns with running totals aggregation was fixed.
This is now officially available in the 2.8.8 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Feel free to write to us in case of questions.
Best regards,
Mykhailo
