Huge errors in List Pivot Plugin

[nusilmar]

Hi there,

I'm starting to use the Pivot List plugin and came across several errors that should not happen.

1st If something is written on pivot plugin description, after saved it disappears
2nd Doesn't seems to order the table correctly ( i need to choose descending for the dates to be order correctly ( from 1/1/2015 to 6/7/2015, and if i choose Ascending it goes on opposite way ( most recent to oldest)
3rd Sometimes the days of the month ordering are wrong (check example

Job DateUser 1User 2User 3User 4User 5User 6User 7Total

24-04-2015 6.4 6.4 6.4 19.20
21-04-2015 6.4 6.4 12.80
02-07-2015 6.4 6.40
01-07-2015 6.4 6.40
15-06-2015 6.4 6.40
16-06-2015 6.4 6.40
Total 12.80 6.40 12.80 6.40 6.40 6.40 6.40 57.60
4th If i put something within the same axis ( same user getting two entries for the same day) the table doesn't sum both entries ( Check example

On simple list view :
Auditor Jobs Date Value
User3 1 15-06-2015 6.4
User3 1 15-06-2015 6.4

On pivot list view
Date User3 Total
15-06-2015 6.4 6.40
Total 6.40 6.40

As you can see it doesn't sum both entries for day 15/06/2015. It should show 12.80 and not 6.40 ( Because there are 2 entries.

5th I don't understand the way grouping work on this plugin, since it doesn't change the way the data is shown.

 

[nusilmar]

Another error found on pivot plugin :

if you set a filter ( for instance a date filter , with range setting ) and filter your data , when you reapply another setting to your filter or if you reset your filter the data wont change, meaning that if you have all dates , you get all data, if you filter to a specific date you'll get the data for that date and if you reset the filter or change the date filter all the data remains as of the ones for the first filter ( if you set for April in the range it filter all form April, but if you reset the filter or choose another date range it still shows April data).

 

[nusilmar]

Another error found on pivot plugin :

if you set a filter ( for instance a date filter , with range setting ) and filter your data , when you reapply another setting to your filter or if you reset your filter the data wont change, meaning that if you have all dates , you get all data, if you filter to a specific date you'll get the data for that date and if you reset the filter or change the date filter all the data remains as of the ones for the first filter ( if you set for April in the range it filter all form April, but if you reset the filter or choose another date range it still shows April data).

Found out the reason : It's the plugin cache. If you set it ON that data remains active ( even if you close your list and reopen later ) . I needed to disable the cache so that all data could be filtered, instead of the cached one.

Yet the problems i stated on starting post still remain ...

Help ??

 

[nusilmar]

i'ved posted this errors on git hub, hopefully someone would figure out a way to solve them.

 

[cheesegrits]

The pivot plugin isn't part of the "core", so we only work on it on a funded basis.

-- hugh

 

[PaulV888]

I actually have 1 pull request open that I think will fix the last issue, regarding not adding up.

 

[cheesegrits]

Just looked at that. Can you explain what that fixes / how? I don't currently have a pivot test case to use to test.

-- hugh

 

[PaulV888]

Did you see this: http://fabrikar.com/forums/index.php?threads/pivot-table-plugin-grouping-on-database-joined-fields.41530/

 

[cheesegrits]

I merged it.

-- hugh