3 ms·

Feature Suggestions (top level comment to hold various suggestions, so upvoting can be used per-suggestion to bubble the best to the top)

johnlbevan2 9y ago
Aggregate Function: Count I've seen that COUNT is implemented for numeric values; but not for text. There's no reason to limit COUNT to numeric (unlike AVG and SUM).
- antonycourtney 9y ago
  Good points and great suggestions, thanks!
johnlbevan2 9y ago
Aggregate Function: Count Distinct Like count, but only counts each distinct value once. Useful for judging data quality (i.e. if you have 600 items with 599 distinct values, chances are there's an invalid duplicate; if you have 1 distinct item chances are that column's not of interest; if you have a few distinct values, you have a potential pivot candidate, etc).
johnlbevan2 9y ago
DATE support. Help mentions INT REAL, and TEXT. Having support for dates would be useful; especially if this enables us to treat dates as multi-part values; e.g. pivot by year & month instead of by the complete value.
johnlbevan2 9y ago
Quick Filter i.e. Currently to add a filter you to the bottom, clicking filter, selecting a column name, selecting equals, entering a value. Instead, right clicking on a cell and selecting "filter > equals" would apply a filter to that column for values matching the selected cell's value. Likewise "filter > contains", "filter > does not equal", "filter > greater than or equal", etc. These filters would then be appended to the filter at the bottom, so could still be managed there; but just saves some effort when first populating.
banku_brougham 9y ago
Export filtered/pivoted result to CSV/TSV: - a very important use case for my team in support of business users who are comfortable in Excel which cannot manage large (>1M rows) files. Tad is useful even with 10M+ rows, a user can import, review datafile and filter/pivot to desired subset. The next step for them would be exporting and creating formatted tables or charts for analysis/reporting documents.

johnlbevan2 9y ago

Aggregate Function: Count I've seen that COUNT is implemented for numeric values; but not for text. There's no reason to limit COUNT to numeric (unlike AVG and SUM).

antonycourtney 9y ago
Good points and great suggestions, thanks!

johnlbevan2 9y ago

Aggregate Function: Count Distinct Like count, but only counts each distinct value once. Useful for judging data quality (i.e. if you have 600 items with 599 distinct values, chances are there's an invalid duplicate; if you have 1 distinct item chances are that column's not of interest; if you have a few distinct values, you have a potential pivot candidate, etc).

johnlbevan2 9y ago

DATE support. Help mentions INT REAL, and TEXT. Having support for dates would be useful; especially if this enables us to treat dates as multi-part values; e.g. pivot by year & month instead of by the complete value.

johnlbevan2 9y ago

Quick Filter i.e. Currently to add a filter you to the bottom, clicking filter, selecting a column name, selecting equals, entering a value. Instead, right clicking on a cell and selecting "filter > equals" would apply a filter to that column for values matching the selected cell's value. Likewise "filter > contains", "filter > does not equal", "filter > greater than or equal", etc. These filters would then be appended to the filter at the bottom, so could still be managed there; but just saves some effort when first populating.

banku_brougham 9y ago

Export filtered/pivoted result to CSV/TSV: - a very important use case for my team in support of business users who are comfortable in Excel which cannot manage large (>1M rows) files. Tad is useful even with 10M+ rows, a user can import, review datafile and filter/pivot to desired subset. The next step for them would be exporting and creating formatted tables or charts for analysis/reporting documents.