It would be good if you can restrict what data is downloaded to points in time, e.g., all data for 2022 (1/1/2022 - 31/12/2022).
It’s frustrating now that you have to download everything and then delete the old data (e.g., from 2020-2021).
It should work the same as when you download banking/credit card data - there’s a filter that lets you select a date range (and other variables, that might be applicable, such as “everyone who answered question X” or everyone who said “yes” to question X).
This would be highly useful to all users.
You can do it a couple of ways by manipulating the URL, if you’re comfortable with that:
@Ahmad1, this is possible, but unfortunately there is currently no UI to easily create the filtered export. To do this, you can navigate to the following URL with your ASSET_UID and KF_URL depending on the server you are using:
Then paste the following JSON …
This is possible but you will need to follow the steps as outlined below:
Follow the instruction as outlined in the support article
Pulling Data Into Excel Power Query until you get something like https://kc.humanitarianresponse.info/api/v1/data/1314.xls if you are on an OCHA server and https://kc.kobotoolbox.org/api/v1/data/1314.xls if you are on a HHI server.
Then you will simply need to add ?start=20_12_03_00_00_00&end=20_12_03_23_59_59 to the end of the link which you have finalized as…
@rebeccalk, you could follow @nat’s suggestion for the time being. But we do have a features request for this already. Maybe you could VOTE for it to make it a reality in the near future:
I am exporting data quarterly, but every time i am exporting all the data from A to Z and then removing the previous quarters data in excel, but i wan to export only the data for the new quarter, is there any way to export data quarter wise or date wise?, please help me! Thanks