The db.
I'm building is large with rows of 5 million+ but it also has many column
headers, and while the scroll bar below will suffice for many, a few columns do
not fit so well.
Is there a
way for the user to highlight a chosen row, and additional data could be
displayed elsewhere on the page?
You are right the null value will be included in the average calculation.
Unfortunately calculation functions can not "calculate " NULL value. That NULL value will be viewed as a 0 and because of that the function will not give you the proper calculation.
This is something that we are looking for to include for the next versions of the plugin.
Hi,
The db. I'm building is large with rows of 5 million+ but it also has many column headers, and while the scroll bar below will suffice for many, a few columns do not fit so well.
Is there a way for the user to highlight a chosen row, and additional data could be displayed elsewhere on the page?
Thanks
Paul
HI Paul,
Thank you for your purchase.
Unfortunately something like this is not possible to achieve with the plugin built in features at the moment.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the quick, though regrettable reply.
I’m also trying to get a more accurate figure for the average values, that does not include NULL values in the calculation.
For example
10,11,12 would give me an expected average value of 11
10,11,NULL,12 gives me an average 8.25 where I need this to calculate 11 again..so that it disregards NULL values in the COUNT
Thanks Paul
HI Paul,
You are right the null value will be included in the average calculation.
Unfortunately calculation functions can not "calculate " NULL value. That NULL value will be viewed as a 0 and because of that the function will not give you the proper calculation.
This is something that we are looking for to include for the next versions of the plugin.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables