rodekruis / cashpo

0 stars 0 forks source link

[Dashboard] update locations in dashboard. #207

Open corinamarkodimitraki opened 1 year ago

corinamarkodimitraki commented 1 year ago

This is issue No. 9 in the Excel "HRC Health Tickets Tracker.xlsx"

Is your feature request related to a problem? Please describe. We added some new locations in espo, but this was not adjusted in powerbi.

Describe the solution you'd like We want all the locations to show in the general filter (first page) that can be applied to all pages of the dashboard. The location axis table should be updated to contain all the locations. One of the locations that doesn't show in the dashboard yet is "MHT", which is short for Mobile Health Team.

angelinaRC commented 1 year ago

image

I see MHT locations there, or should it be just MHT?

corinamarkodimitraki commented 1 year ago

Indeed @angelinaRC . These were renamed to Korinthos clinics, Lesvos clinics etc after the pilot, but we were not able to change this in PowerBI yet. Next to that, we also added the Mobile health Team in Espo, which is also not in PowerBI yet. It would be great to update the names of that list.

In the screenshot you can see all the locations that are now available on Espo, with the correct way of writing them. Is it possible to update the list in PowerBI to these?

Screenshot 2023-01-05 at 09 21 56

angelinaRC commented 1 year ago

@corinamarkodimitraki can you send it as a text (so that I can copy paste it directly)?

corinamarkodimitraki commented 1 year ago

EHS Ano Liosion EHS Athens EHS Kallitheas Mobile Health Team Korinthos Clinics Lesvos Clinics Malakasa Clinics Nea Kavala Clinics Ritsona Clinics Serres Clinics

angelinaRC commented 1 year ago

one more question - so all the MHT + something are now just MHT?

image

image

(also, there is a vaccination case that has weirdly two locations, is that normal? see 1st screenshot)

corinamarkodimitraki commented 1 year ago

No, the list I sent you is how it should appear. So for example, MHT Korinthos becomes now Korinthos clinics. In addition, now we have added the Mobile Health Team as a location. I hope this is clear?

I checked the vaccination you mention and removed the wrong location. Once the dashboard renews, it should show only the Mobile Health Team.

corinamarkodimitraki commented 1 year ago

The HRC code for people registered under Mobile Health Team starts with ΚΟΥ

corinamarkodimitraki commented 1 year ago

[13:22] Markodimitraki, Corina Korinthos is 62e7a10790330b078

[13:22] Markodimitraki, Corina Lesvos: 62cff99f4f545e496

[13:22] Markodimitraki, Corina Malakasa: 6384997792778cc7c

[13:23] Markodimitraki, Corina Mobile health team: 637f593f3a762de33

[13:23] Markodimitraki, Corina Nea Kavala: 638499c380486181b

[13:23] Markodimitraki, Corina Ritsona: 638499ac48af6b0ce

[13:23] Markodimitraki, Corina Serres: 638499828ed709ee3