search

onaio / reveal-frontend

WebUI for the Reveal epidemiological surveillance platform
8 stars 4 forks source link

Development of Superset Chart to Export Zambia Plans in CSV Format #1472

Open samkanga opened 3 years ago

samkanga commented 3 years ago

Akros would like assistance in building charts on superset that will enable them make csv exports for the following plans:

  1. MACEPA IRS-Lite Southern Live Plan
  2. MACEPA IRS-Lite Western Live Plan
  3. All records ever submitted for Zambia since inception

These are similar to the chart created here for MACEPA: Full Reveal 2020 IRS Plan CSV Export

moshthepitt commented 3 years ago

@samkanga would the client agree to getting access to this via the database directly? I fear that Superset is not the best tool for this. For instance, we will likely not be able to achieve "All records ever submitted for Zambia since inception" unless we put in an uknown (as of right now) amount of effort to make it such that Superset can request all those records reliably without overloading the Reveal system, or timing out.

cc: @Wambere

samkanga commented 3 years ago

@moshthepitt thanks for the insights. Based in the explanation, I think we can drop #3 and I can check with the client if they are OK with a csv download. Would the impact of #1 and #2 on the system be similar to #3, or can these be achieved easily?

moshthepitt commented 3 years ago

@samkanga the impact is similar. Superset is not ideal for these CSV downloads.

Last time it was Craig who create that download dashboard. So not sure of the LOE for 1 and 2, maybe half a day.