For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
Yes, that's what I mean, the standard calculation of the amount counts data from the database that relate to this column, and I would like to count the data that comes in the $data array, because they are different from those in the database, there is an element of calc with a sample of data from the database, how would I count the data from the array, I read the description, but how to make a query I did not understand, please tell me?Do you mean the calculations in element's [List view settings]?
http://fabrikar.com/forums/index.php?wiki/elements/#custom-calculation
Did you set the "Custom Access" you need?
In general you'll find hints in the tooltips (hover labels).
That's just what I would like for the "user calculation" to work as a calc element, but I did not understand how to achieve this, thank you very much for telling me, I will continue to understand.In "Custom calc" you can only calculate (MySQL functions) on the element (=column, addressed via %s) values in the database.
In each of the element calcs you can "Split on" some element (which will do a GROUP BY)
I can't see what "Split php" in "Custom calc" is doing (or if it's doing anything at all), "Split on" is working as in the other calc types.
- Custom query - Query fragment to generate result using %s to represent the field name for this element (do NOT use the actual field name, you must use %s). So to generate the population standard deviation for this element, this would be
STDDEV_POP(%s)
Something like this should do (doing it "manually", without %s)
((select sum(tt.your-column) from `your-table` tt where tt.your-column = "A")-(select sum(tt.your-column) from `your-table` tt where tt.your-column = "B"))
I don't know if this helps in your case, but you can filter a list in the content plugin.
http://fabrikar.com/forums/index.php?wiki/content-plugin/#filtering-lists
So {fabrik view=list .... your-table___custom_id=[rowid]}