photo thumbnails in reports – useful if you have a better memory for faces than names for example!
The ‘word cloud’ has become very popular, used increasingly by national newspapers and described as ‘the gateway drug to textual analysis‘ by the Chronicle of Higher Education. Word clouds are now available in agileBase.
Analysing numerical data is fairly well understood. There are all sorts of charts and statistics you can use, many of which have been available in agileBase for some time. However, what do you do when you have databases of unstructured text? For example
How do you discern patterns and pick out trends in this mass of text?
Let’s jump straight in with an example.
This is a summary of the learning database that we use in our organisation – books, online articles, videos, PDFs etc. The text includes our reviews and where relevant summaries from amazon.com. You can quickly get an idea of the sorts of things we’re interested in.
What’s more, the word cloud is interactive – you can click on a word to filter by it. This will show a list of results – books etc. – that you can drill down into and also a new word cloud summarising that set of results. In this way, you can iteratively explore an area and find interesting resources – this is a method we’re pioneering.
Here’s the cloud that you get when you click on ‘systems’:
As you can see, it’s cleverly picked up a number of different forms of the word ‘systems’. This is made possible by the use of research from Lancaster University in natural language processing.
In fact, if you hover over a word, you can see the different forms. For example, science includes also sciencific (a spelling mistake), scientific, scientifically, scientism, scientist and scientists. In this way, you don’t have to know the exact word you’re searching for.
To see a word cloud of your own data, just go to the charts tab in agileBase and select a field to use as a source of text – it’s as simple as that!
We predict this will become a useful resource in many different areas. Let us know what you think, especially if you have an idea that you’d like to try it out on.
New calendar integration means data can now be entered directly into agileBase from the calendar interface using our real-time bi-directional links.
In previous posts we talked about the integration of agileBase with Google calendars, an option which is still available. However this month we’re launching a new vastly improved integrated calendar which not only allows you to display data (as google does) but allows you to update the database from the calendar interface.
The integrated calendar is now real time (Google only updates events once a day).
Calendars form the basis for many of the most important interactions in today’s organisations. agileBase has now a fully functional calendar interface which allows you to
The calendar’s currently in beta testing phase and will be released in the near future. As with all of our addons, there will be no per-user charge, rather the cost will include as many users as you like.
Here are some more screenshots:
agileBase is now six years old and development is really ramping up. This month’s new elements have all come from experienced clients and include
You can now sychronise any report that contains date-based data into your favourite calendar application, for example Google Calendar, a phone or the iPad calendar. Here’s an example screenshot.
Next on the horizon is
You’ll soon be able to narrow down to show only recent data, expand out to the long term or do a year on year comparison.
We’ll keep you posted! In the meantime, have a great festive season.
We thought we’d highlight the most recent company to adopt agileBase because they’re a great demonstration of the decision-making that goes into choosing a lean and agile platform to run IT systems on.
Here’s a video of the owner Tom Collins describing the background to his business and requirements.
When he heard about agileBase, Tom immediately saw the potential of a system that’s so fast to develop with that staff can be brought in on the process. The most important things for Think Drinks were
Since this video was taken a couple of weeks ago, a complete system has been built in collaboration with Tom and the team, the basics being put together during meetings. It’s now being used on a day to day basis and we’ll follow up soon by revisiting and asking them to describe their experience. Stay tuned!
Recently added at client request:
The latest agileBase version out this week includes some great little ideas from inside and outside the company so I thought I’d compile them into a tips newsletter along with a few other useful general tips – the kinds of things that are really useful if you know about them. So, new stuff first…
For numeric fields, when you hover over a field name in pane 2, a tooltip appears calculating the sum and average for the column. This works when filtering as well – you’ll get just the figures for the filtered data.
For lookup and some other text fields, agileBase lists all values in the report and shows how many times each appears with a little graphic – useful for a quick overview.
These are a couple of examples from our timesheet.
Thanks to Bread Art Collective for some initial inspiration.
Emailing, printing or sharing charts outside outside agileBase is now easy – just click the little ‘download’ button at the top right of a chart which will download an image of the chart that can be easily emailed or shared.
When you upload a document to agileBase, it’s kept for the life of the record. Even if you upload another version to replace it, any old versions are kept and can be retrieved from the ‘view’ tab.
But how do you delete a document (without deleting the rest of the record)? Simply clone the record and all other information will remain but the document and document history won’t be copied.
The relation picker’s used for choosing an item in a related table. For example, if editing a contact, you may choose the organisation they belong to. Simply start typing and a dropdown will appear allowing selection of the item. So what’s the tip? Well, you can use * when typing to mean a wildcard, exactly as you would do when filtering. Here’s an example of adding an address to a record: I know it’s somewhere in Bristol…
Sometimes it’s good to be able to look at one report in one window and a different one in another, so you don’t have to keep flipping back and forth between the two reports in agileBase. To do this, open each report in a different web browser, e.g. the first in Firefox and the second in Google Chrome. If you do this, the browsers won’t get confused!