☑ cool new feature
☑ could help many users!
☐ removes a „bug“
☐ nice to have
☐ nobody needs it
#myTop10_2023
What inspired this wish list request?
Some days ago, I posted here a wish .
The idea: aggregate the data of the update table before it's merged into the main table.
This could make Tables/Update much faster (!) AND more powerful.
Hm. Actually a user could implement the feature right away if he applies 2 steps:
1) aggregate via Tables/Summary
2) merge via Tables/Update.
But that's not true - because some aggregation options were proposed which are not available yet in Tables/Summary - those for non-numeric values like first/last entry, mode ...
So, if there is something missing in Jmp ...
let's write a wish
(especially as @jthi already proposed to do so: https://community.jmp.com/t5/Discussions/Summarize-Function/m-p/658685/highlight/true#M84794 )
Actuall, in 2019, @ewittry1 posted a first version of this wish - to add an aggregation option for character columns in Tables/Summary (via concat):
Amazingly useful!
Unfortunately, the wish was archived at that time. So, here is a new wish:
What is the improvement you would like to see?
Please add aggregation functions for Character columns
.... to Tables/Summary AND Analyze/Tabulate.
Possible aggregation options are:
- mode (most common entry)
- entry of first matching row
- entry of last matching row
- concatenate the entries of all matching rows (with space, comma, underscore)
option: drop multiples - are all values the same?
- number of distinct values
- concatenate distinct
- *)
Why is this idea important?
With the current version of Jmp, users can use Summary and Tabulate just for numeric values.
With a future version of Jmp users will be able to use Summary and Tabulate for ANY table, including character columns.
They just have to choose the character aggregation which fits their needs.
*) I guess there are many more aggregation options for text.
What are the other ones?
