Data platform updates

Akvo Flow

Data points in Akvo Flow can hold more than one submissions allowing you to see change over time. With this release, we make sure that when deleting the registration data for a data point, all other related submissions are deleted as well.

> Find out more about Monitoring 

Akvo Lumen

Lumen’s transformation to derive new columns with javascript provides a flexible tool for your data analysis needs. You can create a new column based on values in your dataset. With this Lumen release, we added the possibility to mark a new derived column as Option type. This data type makes it easy to analyse multiple option questions as Lumen automatically groups the option values.

> More on deriving colums 

Akvo Flow app (2.9.10)

This version fixes saved submissions form version inconsistency and improves how data points are opened.

Akvo Flow app (2.9.9)

This version fixes a rare issue where data submissions were not properly saved. It also simplifies datapoint creation.

Akvo Flow

Are you looking to collect data consistently across different projects? With Akvo Flow’s survey templates, you set up a survey, mark it as a template, lock questions that you want to be collected in the same way, and use the template in any project. Flow’s templates are simple to use, don’t clutter your workspace and ensure data consistency across your organisation.

> Read more here

Akvo Flow app (2.9.8)

The latest version of the Akvo Flow app fixes issues with certain devices connecting to the online workspace.

Akvo Flow

This week we have released fixes to coping translated survey forms to make sure all translations are copied well and you can quickly get started with your data collection.

Akvo Flow

If questions do not have their dependencies (skip logic) properly set, you cannot publish the form. With this release, Flow now highlights such questions and question groups making it easy for you to finish the form. We also added Sidaama to our list of languages when translating Flow forms, to support our partners in Ethiopia.

Akvo Flow app (2.9.7)

Tired of having to scroll through those endless cascade lists? From now on you can also search for your option when answering cascade questions.

Akvo Flow

Today we updated exporting and importing data in Akvo Flow to ensure we support a variety of languages and fonts, for example for when you collect data in Arabic.

Akvo Flow

Over the last Flow releases, we have been improving the copying of forms. Not only is the process now faster we also ensure dependencies, options and translations are copied properly. Furthermore, we added support to translate question tooltips (with the new maximum character limit set to 1500) and question groups.

Akvo Caddisfly app (1.0.19)

Today we updated two strip tests’ instructions to match the testing steps. The changes for the HACH 5-in-1 strip test reflect how long you need to wait before reading the result. For the HACH Nitrate/Nitrite test we changed the implementation to support the latest version on the strip tests.

Akvo Caddisfly app (1.0.18)

This release includes 6 new tests: Boron, Bromine, Ozone in presence of chlorine, Ozone in absence of chlorine, Sulfide and Sulfite.

Akvo Flow app (2.9.6)

This release includes bug fixes and improvements for datapoint downloads

Akvo Flow

With Flow’s monitoring features you can track change over time. Assing existing data points to enumerators who then simply download them to their Flow app. With today’s release, we resolved issues around downloading thousands of data points to the app.

> Learn more about assignments

Akvo Lumen

Over the last days, we simplified how you recognise different data types in your dataset, fixed an issue with filtering out empty cells for visualisation, added the option to filter data for maps using geographic shapes, and improved loading of dashboards with many visualisations.

Akvo Flow app (2.9.5)

A part for several bug fixes, the app will now display updated forms in bold.

Akvo Lumen

Datasets are now split into data groups to make it easy to clean and transform your data. Get a better overview regardless of the side of the dataset. A dedicated data group holds all transformed columns to keep things organised. In the future, this new view will support data from repeated data groups and become the default.

> Read more about data groups

Akvo Caddisfly (1.0.17)

This release adds a new Dissolved Oxygen test

Akvo Lumen

Pivot tables are our second most used visualisation type! Based on your feedback, we improved how they work. To make them even simpler to use, we now calculate and show the total value for tables only based on row data.

Akvo Flow

Are you planning to go back to the field and monitor the progress of your project? Are you about to start a midterm evaluation? With the assignments feature you can distribute specific data points to enumerators. With today’s release, we resolved issues around assigning more than a thousand individual points to an enumerator.

> Learn more about assignments

Akvo Lumen

With the lastest Lumen changes, we switched to a faster database and added a new setting to map – the option to centre the world around the antimeridian (the 180th meridian)!

> Check it out here

Akvo Lumen

Today’s Lumen release makes it effortless to analyse and visualise data from Flow multiple option questions. With a new data type – Option, Lumen automatically groups the selected options in data visualisations removing the need for you to transform data. You can now analyse such data simply by selecting the column in any visualisation!

> Read more on analysing data from multiple answer Flow questions

Akvo Lumen

With Lumen, we aim to make it easy to create meaningful data visualisations. This also means that data is well described in the chart, in the legend. With this release, we added the option to define how the values are ordered in visualisation legends.

> Find out more here

Akvo Flow app (2.9.4)

This new release improves and simplifies location data collection.

Akvo Caddisfly (1.0.16)

This release adds a new Nickel (256) test for the MD610 device.

Akvo RSR

It’s bit easier find your way around RSR now with our new navigation (upper left corner). We’ve also refreshed the IATI reporting page design so that it also easier to quickly make your next IATI export.

Akvo Flow

Working with long survey forms can be a tedious process. This Akvo Flow release ensures that after editing a question, you remain in view, so you do not lose sight of the part of the form you are currently working on.

Akvo Lumen

We have been experiencing performance issues related to updating large datasets with hundreds of transformations. Today we released changes that address these issues.

Akvo Lumen

We strive to make it easy for you to understand your data. This means making it easy to visualise data and transform it in Lumen’s data grid. Today we released fixes that ensure the data grid expands to the full width of your screen. We also made it easy to remove variables from your visualisations with one click.

Akvo Flow app (2.9.3)

Do you need to download many points for monitoring to the Akvo Flow app? The latest version now enables you to easily download thousands of data points. We also simplified the look and feel of the data point list to ensure you have all important details in view. We updated the minimum supported Android version, 4.1 or newer.

> Read more about assigning data points to devices

Akvo Lumen

With this Lumen release, we resolved a larger performance issue around maps. Secondly, we improved the error messages shown when updating a dataset fails and resolved one of the causes of failure.

Akvo Flow app (2.9.4.1)

This release fixes an issue with datapoint download related to faulty images.

Akvo Lumen

Today we updated some missing French translations and the design of our data grid. We are working on some larger changes to how you view data to better support large datasets and today’s changes are the first ones coming your way.

Akvo RSR

A small but delightful change to RSR – we given the Project Update page a facelift. And the results are quite nice. Have a look for yourself.

Akvo Caddisfly (1.0.15)

This release fixes the issue of tests images not properly loading on Android 10 devices.

Akvo Flow

We fixed a bug that was preventing publishing of certain forms as a result of the new webforms feature. We fixed an error that caused the tooltip text to disappear after the user hovered over it with their mouse pointer. And we also updated French, Portuguese and Spanish translations.

Akvo Flow

Today we added a new setting to all question types, holds personal data. This way data marked as personal can be hidden when exporting the data with the Flow API. Secondly, we added support for repeated question groups when collecting data via webforms.

Akvo Flow

Do you need to collect data but cannot go to the field? Do you want to quickly get answers by submitting data from your computer or any mobile device? This is now possible using Akvo Flow Webforms.

> More on submitting data with webforms

Akvo Flow app (2.9.2)

With this versions we updated French and Spanish support and added a warning before submitting a monitoring form for the same data point multiple times.

Akvo Lumen

This Lumen release holds fixes to visualisations’ performance for datasets with more than 2500 rows. When creating visualisations for large datasets, Lumen used random sampling. Now for such large datasets, we instead guide users to select the right columns and aggregations to make the visualisations render. We also now ensure filters on dashboards apply to maps too.

Akvo Flow

We improved assigning forms and data points to devices. You can now easily search and select the data points to assign and we improved the interface too. Furthermore, all existing assignments match the new changes, showing ‘All data points assigned’ for monitoring surveys.

> Read more about Assignments

Akvo Flow app (2.9.1)

This version includes fixes for the datapoints download and display and simplifies language setting in the app.

Akvo RSR

We’ve added a splash of colour to RSR with the introduction of the new Programme Overview feature. If you’re working with project hierarchy (i.e. core results framework) you can now clearly see your hierarchy’s aggregated results data via ‘My Programs’.

Akvo Lumen

To make it as easy as possible to understand your data also means explaining when things go wrong or making sure they simply don’t go wrong. With the latest Lumen improvements, we enhanced our error messages and made sure you cannot delete a data column that is used in a visualisation.

Akvo Lumen

Today we updated Lumen with some ‘behind the scenes’ improvements that ensure the languages we use to create Lumen are up to date and how we handle data in different parts of Lumen is even more secure.

Akvo Flow API

We improved Akvo Flow’s API. Before when you wanted to get data out of the system had to read all the data every single time and then try to “detect” what has changed. The Sync API provides a way of getting changes removing the need to get everything with each call.

> Read more 

Akvo Flow app (2.9.0.1)

With this new release, we will no longer remove any datapoint from a device when you press “Download”. In order to delete existing datapoints, you can use the “Delete collected data and images” inside “Settings”.

> Find out more about app settings.

Akvo Lumen

Add filters to your Lumen dashboard. Lumen dashboards are a great way to showcase the insights from your data. Create one dashboard for the entire country or programme and use the filters to see what you need to on a lower level to make decisions and improve results.

> Check more here

Akvo Flow app (2.9.0)

With this update, when monitoring feature is enabled, we will only download specifically assigned datapoints to your device. Datapoint images will also be automatically downloaded when you press the ‘Download’ menu option.

Akvo Flow app (2.8.5)

With this release we fixed a few issues and removed the need for a passkey when performing admin tasks such as reloading all forms in Settings.

Akvo Caddisfly (1.0.14)

The latest Akvo Caddisfly app version is fully translated to Spanish!

Akvo Flow

We have released a major improvement to Flow. You are now able to monitor data collection for your entire organisation by downloading a stats report that presents a summary the total number of submissions per form within a selected period e.g. within the last week. For more information on how this works take a look at the stats support page.  In order to do this you need administrator-level permissions.

The survey assignments interface has been given a facelift with some items rearranged to improve on the user workflow when assigning survey forms to devices.

Akvo Lumen

We have released a small improvement to navigating through Lumen dropdowns. We now have searchable dropdowns that enable finding a specific item in a long dropdown list by typing the first few letters.

We have also made a small improvement in the data analysis view.  We added an additional header that groups the dataset columns together based on their content when viewing data imported from Akvo Flow.  You will see metadata columns, named question group columns and derived data columns.

Akvo Flow app (2.8.4)

In this release, we fixed multiple issues related to repeatable question groups.

Akvo Flow app (2.8.3)

In this release, we fixed the language change preference which had stopped working on some devices.

> Find out more about the app languages.

Akvo Lumen

With Lumen’s transformations, you can easily clean and analyse your data. The Derive column – javascript transformation provides the most flexibility. We improved error handling and how the transformation is applied on updated datasets. Make sure you don’t use the word “function” nor the sign “=>” as these are not allowed.

Akvo Lumen

Bar charts are a great way to visualise data. Often you want to also split the bars based on another text or number column. With today’s release we added the option to visualise more than one metric column in Lumen bar charts.

> More on all the customisation options for bar charts

Akvo Lumen

Did you have troubles deriving a number column using Lumen’s most flexible transformation Derive column-javascript? Did you water quality image not show in the map pop-up? Or did you create a group in the Derive Category column and you could not click away? With the last releases, all these issues are now fixed.

> Read more about Derive transformations

Akvo Flow

One of the tricky data types to analyse are answers to option questions where you can select more than one option. To easily see the frequency of individual answers Flow’s Data analysis export creates separate columns per each option. With today’s release, we pushed out a fix to ensure these columns work well.

> More on Flow’s Data analysis export

Akvo Flow app (2.8.2)

With this release we fixed the issue where the image location was not displayed in the dashboard. When an image location is available, its coordinates will also be displayed in the app underneath the image.

> Read more about image questions

Akvo Flow

Today we changed how you log in to Akvo Flow. The new login allows you to access Akvo Flow and Lumen with one email account using any email. We removed the need for Google emails to set up a user in Flow. Switch to any email!

> Check out the new login

Akvo Flow

We optimized data exports. Previously, when you downloaded the data, you might have seen the draft columns and wondered why they miss data. From now on, all data exports are based on the last published form version. The survey form export remains the same, exporting the current form version.

> Find out more about our export options

Akvo Flow

A new login allows you to access Akvo Flow and Lumen with one account using any email. We removed the need for Google emails to set up a user Flow. Switch to any email! We will be releasing the new login to you gradually to ensure we can quickly support you. We also simplified assignments. One assignment now holds forms from one survey. All existing assignments were automatically split ensuring ongoing data collection is not affected. 

> Read more about the new login and simplified assignments

Akvo Lumen

We pushed out a few improvements to Lumen over the past days. Did you have issues importing or updating Flow datasets? Did creating a Derive Category column or a Collection fail? All these issues are now fixed. We also limited which columns you can use as a second metric to the x-axis (sub-bucket) for bar charts to only TEXT columns.

Akvo Caddisfly (1.0.13)

The latest Akvo Caddisfly app version is fully translater to French!

Akvo Lumen

When you go to access Lumen, you’ll see a new login page. Here, you’ll be able to log in to Lumen using any email address. If you’d like to continue using your Google account, simply click ‘Continue with Google’.

> Read more

Akvo Flow app (2.8.1)

This Flow app release expanded the use of offline maps. Besides being able to download an offline map and to see your data points on the map in comparison to your location, you can now also capture geographic shapes when offline using and offline map.

Akvo Lumen

This Lumen update fixes issues with the Transformation log and improves the design of the dataset editor. For example, number data are now aligned to the right to make them easier to read. Furthermore, we are now testing our new login system that is to be released soon.

> Check it out here

Akvo Caddisfly (1.0.12)

Today we launched another test, a combination of measuring levels of e.Coli and Total Coliform. You can use the current Aquagenx method with an extra UV flashlight to perform this test. Furthermore, we simplified the workflow for testing the microbiological parameters.

> Read more

Akvo RSR

The RSR project editor has been completely redesigned with a clean, uncluttered and fast UI. An autosave feature has been implemented limiting the possibility of losing data when there are connectivity issues. We’ve also made big performance improvements to the Results and Indicators section and have included a ‘Full preview’ feature of your results framework.

Akvo Flow

Today’s Flow release brings improvements to overall product performance. We are now also testing user login through Auth0 that will allow us to move away from the restriction of supporting only Google email accounts for users and to have single-sign-on for Flow and Lumen users in the future.

Akvo Flow app (2.8.0.1)

With this Flow release, we have added the possibility to download map areas to view datapoints on a map offline.

> Read more

Akvo Lumen

We improved Lumen’s update dataset logic to handle removed questions defining your Flow dataset and cases when you have an apostrophe in the column name. Now you can, even more, enjoy the flow of setting up all the rules to transform your dataset, updating it with new data, and seeing all the rules being applied without any issues.

Akvo Caddisfly (v1.0.11)

As our software so do water quality tests evolve. With this Caddisfly release, we added support for the new growth medium when testing e.Coli. Furthermore, when using strip tests the app will now guide you through each step.

Akvo Flow

In preparation for future changes around Assignments, have upgraded the survey-form selector across the online workspace. Furthermore, we do not allow you anymore to save empty assignments, we fixed the wrong published survey links in the Messages tab, and we now ensure data point IDs are always 14 characters long.

Akvo Flow (2.7.4)

With the latest Flow app update, we ensure you do not lose your Caddisfly test results if your device is low on memory. We also added a few checks to improve your data upload and to the data point ID creation resulting in IDs always being 14 characters long.

Akvo Lumen

Select all your columns when merging two datasets, or create ranges from numeric data using the new transformation – Derive column, Category column. These and more improvements are brought to you with our latest release.

> Check out the new data transformation

Akvo Caddisfly (1.0.10)

The latest Caddisfly version improves the workflow when testing pH and Chlorine with Lovibond’s Pool Tester.

> Read more here

Akvo Lumen

Besides improving our tooling to ensure a more secure Lumen, we have improved the design of the visualisation and dashboard exports.

> More on exporting data

Akvo Lumen

We are introducing a new Lumen transformation that helps simplify data in text columns, Derive – Category column. Group unique values into new categories, simplify visualisations and better convey data insights. Next, we’ll support using number columns, as well as allow editing the category rules after the transformation is applied.

> More on the new transformation

Akvo Caddisfly (1.0.9)

The latest version of Akvo Caddisfly adds support to test Zinc with Lovibond’s Checkit Comparator. Furthermore, we round up answers to three decimal places.

> Read more here

Akvo Flow

Besides improving our architecture to enhance Flow’s performance and to prepare for future changes around Assignments, we fixed issues with importing clean data back to Flow.

Akvo Lumen

Do you capture geographic shapes with Akvo Flow and want to analyse and visualise them better? With this Lumen release, we now support Flow geoshapes. Visualise your geoshapes on a map or analyse data about their size, length or point count easily. We also now combine columns using hyphens and round up derived number columns to three decimal places.

> More here

Akvo Lumen

We improved Lumen dashboard pdf exports. If a visualisation or a text doesn’t fit on the page we move it to the next to keep the layout nice and organised. We also added extra details to why updating datasets fails to support you in making sure your data flow smoothly and transformations are automatically applied with each update.

Akvo Flow

This Flow release focused on improving data exports. We support the new Caddisfly tests and enhanced the data exports to make sure you can easily export datasets with more than 100 repeats per submission. We also removed the option to select all devices to add to a group based on your input to avoid accidental changes to all devices.

> Read more about exporting data

Akvo Lumen

Have you ever wondered what to do when your dataset showed the error Column mismatch? We added details, as column name and reason for failure, to the message to clarify why updating failed. We also ensure values show properly in horizontal bar charts and now support transforming results from the new Caddisfly water quality tests.

Akvo Caddisfly (1.0.8)

Each water quality test is different, different steps to take, different things to remember. To make testing water quality as easy as possible we added the steps you need to follow as part of the testing workflow. Plus we now support testing 11 more parameters with Checkit Comparator.

> Check the tests here

Akvo RSR

We’ve recently made some changes to RSR project reports. Each of the project reports has had a design revamp and a new, helpful feature (i.e. Actual Value Comments checkbox) was added to the ‘Results and indicators review’ PDF report. We also launched the ‘Kick-start’ report, a customisable, comprehensive project report in Word.
> Find out more.

Akvo Flow

With this Flow release, we have updated the development tools, resolved several issues related to assignments and survey design. Reports will now contain form versions.

> Find out more

Akvo Lumen

Today we share another Lumen release fixing small but confusing bugs. In the percentage horizontal stacked bar charts, we now make sure your labels show properly. We also removed the green loading icon from maps exported as a pdf.

> Read more on exporting visualisations and dashboards

Akvo Flow app (2.7.2.1)

A hot fix has been released due to a bug affecting devices with Android version 7.0 and higher (Nougat, Oreo and Pie). After installing version 2.7.1, these devices were unable to update any further. We will contact the affected users separately with alternative instructions on how to update their devices.

Akvo Flow app (2.7.2)

This Flow app release focuses on fixing several issues such as the one affecting repeated groups deletion, the failure to detect a camera on some devices and a minor issue on file processing. New translations have been added for Spanish, French and Portuguese.

Akvo Flow

With this Flow release, we updated one of our frameworks to enhance our security, removed unused code and streamlined our processes. We fixed the bug causing duplicated data point IDs and are now cleaning up the existing ones to ensure your datasets are well structured for analysis.

Akvo Lumen

Today’s Lumen release fixes small issues around visualisations. We now ensure line charts always show both axes, selecting where to place the legend works also for stacked bars, and we improved how percentage stacked bar chart perform when displayed horizontally.

Akvo RSR

Essential upgrades to the RSR backend continued with this release. This time we upgraded the Django framework to 1.11. And the front-end (JS + CSS + static) build pipeline has been improved. These were two key steps towards one of our priority areas for 2019 – refactoring the RSR Project Editor.

Akvo Lumen

Sometimes you want to add a chart or dashboard to your report, presentation or just print it out and put it on your wall. With the new ‘Export’ option in the visualisation and dashboard editor, you can export your visualisations and dashboards as a .png or .pdf file.

> Check out more 

Akvo Flow

Besides updating one of our code frameworks and ensuring you can always also manually download surveys to the Flow app we have improved the form editor. Survey forms are now ordered alphabetically with the registration form always first for monitoring surveys. Secondly, you can rearrange options in questions by moving them up and down.

Akvo Flow app (2.7.1)

This Flow app release focuses on updating to the latest Android tools. New app users with a device having the Android version 6.0 (Marshmallow) or later will be asked to manually accept some permissions such as Location and Access to Files. These changes are the first step towards bringing the Flow app on the Google Play Store.

> Read more

Akvo Lumen

In the past when you filtered rows without selecting categories in a pivot table, Lumen gave you an error. With this release, we fixed the error while also improving our overall code set up.

Akvo Lumen

With this Lumen release, we introduced some great improvements to visualising data, as well as fixed some bugs and improved the product’s code. From now on, you can draw the sub-buckets of your bars on a percentage basis. Do you not like having the legend of your visualisation on the right? Change it.

> Read more

Akvo Caddisfly (1.0.7)

The goal of Akvo Caddisfly is to make water quality testing in the field easy. For us, this means also guiding you through all the steps of a test. With this release, we have added the instructions as part of the test working for measuring water quality with Lovibond’s MD610 photometer.

> Check out more here

Akvo Flow app (2.6.4.1)

With the previous app release, we added a check to make sure all your photos are submitted well. But this check introduced a bug making all photos mandatory regardless of how the question is set. Today’s release fixes this issue.

Akvo Flow app (2.6.4)

This Flow app release focuses on making sure everything you submit syncs well to your dataset. We now check that all photos you capture are not corrupted to ensure that they all upload correctly.

Akvo Flow

Outstanding Orange release holds many improvements as showing signature responses in maps, ensuring that your bulk upload never fails, or exporting all repetitions in a geographic shape export. We now also clean up the device list removing those that have not connected for more than a year. Furthermore, we simplified adding water quality tests to your form.

> Find out more

Akvo Caddisfly (1.0.6)

Besides improving some issues around how we handle translations on the app (yes, you can now test some of our supported tests in French and in Spanish too), we added support for 3 new parameters: Copper, Nickel, and Zinc. You can test these using the Lovibond MD610 Photometer.

> Read more here

Akvo Lumen

When visualising data in Lumen’s charts or maps you can filter which data to show or to remove from your visual. For instance, you can choose to focus on data representing one gender only. With this release we improved how you can see which filters are added to the visualisation by showing the full filter definition, for example: remove rows in which Year exactly matches 2019.

> Find out more

Akvo Caddisfly (1.0.5)

Our latest version of the Akvo Caddisfly app includes French translations for all the tests we support and Spanish translations for testing e.Coli with CBT kits.

> Read more here

Akvo Lumen

With the first Lumen release of 2019, we now support for Internet Explorer. Furthermore, we have added many technical improvements to ensure better error handling, speed up our development processes and enhance Lumen’s performance.

Akvo Sites

Besides two new header styles, we have also added the option to add a moving/ video slider cover to pages. We have updated our Akvo SaaS Terms of Service and created a separate Akvo Sites `Privacy Policy that you can read at the next login.

> Learn more here 

Akvo Flow

Did you try to export your dataset but you could not select the survey and form because the dropdown did not show? With this 1st release of 2019, we fixed this issue. The loading of the page is now improved and the bug fixed, so the dropdown will always show.

> Check out more