Shiraz dynamic table and summarizing numerical data

[Mohammad]

• table-fd creates a dynamic table from fields, each row is a tiddler and each column is filed
• how to add a row to show a simple mathematical operation like
• sum  e.g. sum of numbers in a column = sum of filed value
• count
• minall
• maxall
• average
• median
• standard devitation

What is the simple solution?

This can also be used by TiddlyTables

[Mohammad]

Hi,

 I have implemented partially the below feature in Shiraz dynamic table!

 For TW ready to use math operators, there is no hassles and one can use

the footer and add for example sum as <<sum>> but for other results like average a small macro shall be written

and then called.

 I wish to now if this feature of any value for TW users.

--Mohammad

[TonyM]

Mohammad,

This sounds helpful, I will review in time.

Thanks

Tony

[Mohammad]

Except the standard deviation, the below feature requests are implemented now!

See

https://groups.google.com/d/msg/tiddlywiki/aZL20FpW4FU/getfqy1yFQAJ

I am waiting for Jeremy to add more math operators to Tiddlywiki core!

Then I will add some more statistical function!

--Mohammad

On Sunday, January 5, 2020 at 12:09:48 AM UTC+3:30, Mohammad wrote:

[TonyM]

Mohammad

Especialy once there are simple maths within a table something I have for my client is a separate form of the same table which is a csv with header row of column names and each row as a comma delimited record.

If we could have a copy to clipboard button that copies any table to csv users can take data generated in their tiddlywiki database and paste into a spreadsheet app for more complex calculations.

I and my business clients do this kind of thing a lot. One trick is to past the csv into its own data worksheet and have a second report or analysis sheet that does a lookup to the data sheet. It is then simple to update the spread sheet with current data without touching the report or analysts sheet.

Perhaps one day I will make it possible to re import the csv to tiddlywiki and apply changes.

While I like the idea tiddlywiki can do everything it makes sense to let it delegate functionality to built for purpose tools like excel.

With a set of calculations available in tables we reduce the need to go external to tiddlywiki but to be able to quickly go external allow people to use the best tool to do the job, and leverage user skills in their existing tools.

I would like us to adopt this approach more often.

Regards
Tony

[Mohammad]

Hi Tony,

 Thank you for your comments.

Tobias beer has made a converter can accept csv or Excel file and create tables based on that! By the way having a two direction tools is a good idea!

Regarding math operators, I agree with you to do such sophisticated calculation in spreadsheet apps. Here I just tried to have some a summary row shows some basic

statistics like mean, sum, max, ...

I believe we should keep it simple and I think Dynamics Tables are getting complex and complex as I add more features.

Best

Mohammad

[TonyM]

Mohammad

Yes I have used Tobias's tools and it is of great value for a lot of applications. It is a good way to populate tiddlywiki with content from other sources. However here I am interested only in the simpler CSV export, which is a direct match to a table, Columns rows and cells.

Regards

Tony