Replies: 3 comments 3 replies
-
Interesting. That's not a bad idea, and is probably do-able too. 😄 Btw, it looks like you've accidentally created a duplicate of this discussion as well, so I'll close that duplicate shortly. |
Beta Was this translation helpful? Give feedback.
-
Just a nod that you can perform maths functions via the 'execute SQL' tab in DB4S. So to calculate the sum of field a:
|
Beta Was this translation helpful? Give feedback.
-
Also, if you select cells in the 'Browse data' tab, the status bar has maximum, sum, minimum and average values. |
Beta Was this translation helpful? Give feedback.
-
sqlitebrowser
is absolutely GREAT!
As the Subject says:
Hope for new Math and Statistics functions
for Columns and or Rows,
integrated in sqlitebrowser...
For ex:
yesterday, I was in [Data Browser] mode
and had a specific column selected.
I simply needed the
SUM and the AVERAGE (mean)
of all the values in that selected column.
A Dropdown Menu in the [Data Browser] mode
with some common Math and Stats Fxs
would be VERY useful!
Suggested Stats functions
for that Menu
in [Data Browser] mode:
- SUM, MAX, Min, AVERAGE, MEDIAN, MODE, Q1, Q3, etc.
I use the R language,
so that would be a marriage made in heaven...
Right now,
we need to exit the DB Browser
go to a spreadsheet program,
or go to Rstudio (R program)
to calculate and then return to DB Browser...
Hope you can add this...
Best Greetings!.
SFd
San Francisco
Ubuntu LINUX 20.04
R, Rstudio
Beta Was this translation helpful? Give feedback.
All reactions