search

medic / config-covid

3 stars 6 forks source link

Create widget in Superset for displaying the number of HWs trained for EBS #77

Closed michaelkohn closed 3 years ago

michaelkohn commented 4 years ago

This will need to get data from Salesforce and this data probably won't be in Salesforce yet. But as a proof of concept from Superset, we can just grab the count from another use case such as ANC and hard-code the partner.

The widget can just have a label and the number of the latest count.

Screen Shot 2020-05-19 at 11 35 42 PM
1yuv commented 4 years ago

Hi @mouriceb , Since there's no trained user information for this project on Salesforce, can you suggest what number should we use for this ?

CC: @helizabetholsen

mouriceb commented 4 years ago

@Maigua please confirm. Alternatively we may use the total no of HWs added on the app as each trained HW is expected to be added on the app as a user, in case we don't have the numbers on Salesforce.

michaelkohn commented 4 years ago

FWIW... I'm less concerned with the actual data as I am with validating that we can connect to Salesforce from Superset.

Maigua commented 4 years ago

@mouriceb I have asked @alixemden to update the numbers on Salesforce and you are right, all the HWs added on the app are the expected user.

1yuv commented 4 years ago

@michaelkohn , From my initial research, It didn't appear possible without using 3rd party (Not free) libraries to connect to salesforce reports directly. Hence, I've added data to the table manually and used that table in superset.

1yuv commented 3 years ago

This was added to superset by manually inserting data from Salesforce to postgres table and referring that table in superset.