Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

bug when 2 running total of columns

Answered
Kevin 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/pivot-table-js/
 

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

Attachments:
test_rt_2.json

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Kevin 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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 2 days ago

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

Please login or Register to Submit Answer