...
- when we finalize, I think we should always program in default filters. It will help filter the relevant information and still allow users to modify/update filters. Is there a way to make the defaults dynamic? Or can users set their own by user?
- CSC comment: users can set their own by user and save custom versions of the dashboard with their filters applied. I'm not sure how that works when doing it through iFrames. Note that row-level filtering will do a lot of work when it comes to making the data view specific to the user's field of inquiry.
- One issue with the table is that you will not be able to chronologically sort the table by Processing Period because it isn't based on dates but the name of the label. (i.e. all Aprils group together). Any thoughts how to improve that?
- CSC comment: I made it sort by processing_period_enddate in the background, so now May2017 is at the top of the table. I also paginated the table so it returns more data than the 250 max by default
- The stock status filter seems to be visually cut off.
- CSC comment: fixed
- I'm not sure the filter for facility is useful for the visuals (map and bar graph) for Stock Status. the bar graph is a count of facilities. Or is the need for that filter just for the table?
- CSC comment: we could remove the filter and use the "search" function to filter the table. Alternatively, we could split them onto separate tabs
- Stockout Rate % - there seems to be something funky happening (see the bottom with the 2 x-axis):
- CSC comment: I can remove that bottom line graph. What it does is allow you to adjust the graph to select a particular time frame that's smaller than the default
- I couldn't figure how which filters to use to make the stockout rate meaningful....If I select two products is it averabing the stockout rate? Unclear what rate I'm looking at.
- CSC comment: yes, it averages them. I agree this is maybe better at a district-level, where it will be the stockout rate of that district for all facilities within that district. Then applying a filter for a particular product isn't going to give you a graph that's only 100% or 0%. We only have one district in our data so I built it this way. The TZ people liked the idea of a district-level and region-level line graph for this.
- I like the Stock status over time bar chart (when the right filters are selected to make it meaningful). I do know the next question will be which facilities so I see the value of the table alongside it. However, the table is challenging to use since the table shows results back to April 2012 but the chart does not. If I sort based on stock status the list is too long to see them all.... Not sure I have an idea to make it better but wanted to share some of the challenges.
- CSC comment: another idea that we had today with the team in TZ was to adjust so that it returns a %. This way you can filter it to a particular facility and see the breakdown of how its products or stocked, or filter to a particular product and see how the facilities break down within a district. You can just scroll up to the previous table to get the list of facilities like you describe, I think
- `
- `
- CSC comment: another idea that we had today with the team in TZ was to adjust so that it returns a %. This way you can filter it to a particular facility and see the breakdown of how its products or stocked, or filter to a particular product and see how the facilities break down within a district. You can just scroll up to the previous table to get the list of facilities like you describe, I think
Consumption Tab
- Why is there only two products in the consumption tab?
- CSC: fixed that
- Processing Period Name selection is a bit strange since it isn't sorted chronologically.
- CSC: I don't know if we can get around that. I will investigate more
- The filter doesn't seem to allow me to select any facility other than Balaka. However, clearly there are more facilities in the Total Adjusted Consumption per Facility graph
- CSC: fixed that
