github.com/ClimateMind/climatemind-analytics commits

Merge pull request #5 from ClimateMind/CM-812_questionnaire_dashboard_improvements

CM-812 questionnaire dashboard improvements

0a818288a5720c705a366444c830267bc7e46a50 authored over 3 years ago

Fixed final bug

18f8536226e67267b5b44e11cbfcdfdff368f1e5 authored over 3 years ago

Correct question_numbering

d619ba593db3fa7f3df8c79199ecbfb521839bd7 authored over 3 years ago

Working but with error

Fixed all errors except for a question numbering error

92a33c31725a882126326faad4bea5b5478e6199 authored over 3 years ago

Selection of data source works

6bc2309f4725bbd317e79c2e16427e75920cdb20 authored over 3 years ago

Dash callbacks working

e7aedbc420be4635055c96c11edeec30db608d3d authored over 3 years ago

Progress

Still need to code the processing of the question_id:question_number
and parsing the database so...

35c0a693511705d7e6da900e2ff89aa1d17285e1 authored over 3 years ago

updated gif link

7f4c9839bfc38b9e5391b6e8de9721f1405a01df authored over 3 years ago

Merge pull request #4 from ClimateMind/cm-716-kpi4-dashboard

Cm-716 kpi4 dashboard

dc5e58f94dcb4a99bde0845600b92109ae1effd4 authored over 3 years ago

Changed file names

Changed file and folder names to be clearer what they are

ac5a267517aa5f52221a3dfd1a6a6b5bc114ddde authored over 3 years ago

Moved gif so docker works

468aefe4b8c5346024809dc791712159c8c4cb52 authored over 3 years ago

cleanup

6124707eb82f48a932a3f71207c387d8ce652af0 authored over 3 years ago

Corrected data analysis

There were 4 MAJOR flaws in the data analysis that I corrected:
- ignoring questionnaire_finish ...

47f187c97d1f894424cf1f6b900c3316b0fb40e4 authored over 3 years ago

Add expose 8050 documentation

9845dc79e845972aefc72785d6945d8272f62814 authored over 3 years ago

default threshold value to 3

09cae18b369da9436c09c235d116dcd50a2ac905 authored over 3 years ago

changed input type from slider to number.

f6b7bd0207fcb363898afcdf9e9cbdfa2777874c authored over 3 years ago

fixed 'latest event' field to be accurate

fixed 'latest event' field to be accurate

074a0bbe80dc99dccaa07455304a0f8444b1d649 authored over 3 years ago

add usage gif

9ab62550a191a0c057aed1ceea0b97ba90a54528 authored over 3 years ago

fix bug when the dataframe is empty

4223a0a72eb3968d22aa0367378287f49c705503 authored over 3 years ago

dockerfile finally working

3be52a4fa23b363bd8139e04d3f8c989790350c8 authored over 3 years ago

add Dockerfile

ce4fc1ff7b7fa7b14744132a399ef1bbdcbac1e0 authored over 3 years ago

update N calculation (question answers => unique users)

27dc94adf2ee2ddc772cbcbf84faf1d0d9144d69 authored over 3 years ago

add N annotation to violin plot

5ca33b7c763afa2f744b705bf8bebedc6b0ee253 authored over 3 years ago

forgot to delete line

67315b7ced37e5db9741134c262d7e94d39e336b authored over 3 years ago

added docstrings

57b34236b13c6545d357e693be9d6315f7ed0813 authored over 3 years ago

Fixed Docstrings and Dash is working

aee8c25ff814f950fd161aba000e2080cb9f05ec authored over 3 years ago

Fixed docstrings and Dash plots are now working

42764371917baf1ace95cd0014d6c6db2644af21 authored over 3 years ago

added Dash filtering to Mayuresh's script. Violin plots are now displayed in HTML (rather than JPG files) and supports filtering by date.

1ea3e17be62e2daef4b659ee4a4bc8acfc89662a authored over 3 years ago

changed column names to match those in SQL (e.g. "Timestamp" to "event_timestamp")

preliminary plotly graphs loading in a localhost server.

26a6f1331f409d95c241cd705fd0999dd4d8a13a authored over 3 years ago

Distribution for Total time in Seconds

a3d956a9cacb102a803ae8ac331491cdd1c09dfe authored over 3 years ago

User Drop-off % Graph

1c0fd05c7061321b04f5422ff870ed97e44a73d8 authored over 3 years ago

KPI4 Preprocessing Updated

d1490126aa0e5b5045d665b083205b9974bef588 authored over 3 years ago

Streamlines the preprocessing for analytics data

591464b751ab95ef0f6cd866f3e40e9e51ce5959 authored over 3 years ago

changed "as of now" to as of the last timestamp seen. this leads to more transparent errors (e.g. if there was something wrong upstream)

3360969ca07f0ccd2d7a8919a9ae35fa940b2488 authored over 3 years ago

implemented data refreshing using SQL, instead of using the CSV tables. Every time the script runs, it will pull a fresh copy of the data from upstream SQL server.

Added "data pulled as of now"

e2e81de1dd0fdb48c3311abc24e3da38a162d823 authored over 3 years ago

added labels specifically on x and y axes.

removed legend for dropoff graph.
added default month when first choosing the date picker range

bfab8391b7989f1d29371dba22c157b32e084040 authored over 3 years ago

implemented daterange filtering. implemented dropoff graph. included new question tag `question_start` onto analytics chart.

a44c2d43686a8608eee79ca97ce0a36a149f60a9 authored over 3 years ago

improved datatable and some commenting, improved graph labelling, removed phantom question number "0".

9be01155c4cf967a69ce028ed5838a682689fc57 authored over 3 years ago

added datatable by pivoting, removed old code.

05dd8883f096dcd91d8da9ebc5b9bae61e2ae190 authored over 3 years ago

some progress for analytics on KPI4. Runnable if you install dash. `pip install dash`.

Uses a dash.RangeSlider for users to filter events using dates. Currently, Dash has no support f...

3462c637bdd92147275cf21486126c0293f668c4 authored over 3 years ago

cm-599

Updated README for instructions on how to run the analytics.

d96eb84cbf320cbb1d5393bfad8620f512fb704f authored over 3 years ago

cm-599

Added KPI 6 reusing KPI 5 artifacts.

a21754e0768e623a785c170b8805d6049108333a authored over 3 years ago

cm-599

Fixed KPI 5 because I learned of how card click events worked.

fb8aff71f7166b0a75878003a019e196e1ec4a57 authored over 3 years ago

cm-599

cm-608

done kpi 1 and 2, more comments, nicer graphs.

06256a1d307cbcfe0de2aff1892310daa2d9bb24 authored over 3 years ago

cm-599

cm-608
KPI 3, 4, 5 pushed to Git.
Was previously in Google Drive repository.

I need to convert K...

fb5207a38b12c71dbe6dfb776f3a0920bcac1c1e authored over 3 years ago

cm-599

cm-608
Visualization commits for cards clicked vs cards shown for different cards.
Visualization ...

d71a3db275c70d93e844f52bc2cf08b5b0c3b101 authored almost 4 years ago

Merge pull request #2 from ClimateMind/pipeline

standalone script for GA to DB pipeline + readme update

b5439ef68b5208027d4893e82068b0b576b70e9a authored almost 4 years ago

standalone script for GA to DB pipeline + readme update

bb26c4ac4966ff0f7a4da9eed1e30ce67b99e428 authored almost 4 years ago

Merge pull request #1 from ClimateMind/analytics-pipeline-readme

Update README.md

94514df7718b9d00588c86d206ab99e6a50f4639 authored about 4 years ago

working dependencies

fixed dependencies. Able to connect to the API with the service account

5bfb4c559447ba4961308365a9a68b9198c69b71 authored about 4 years ago

git ignore

added secret.json to git ignore, updated README

3fc1368a24e2631ecc413eefb666a042153f8865 authored about 4 years ago

added conda environment steps

cdebdce933c30b1429c0dc3aa73b0ba8af090241 authored about 4 years ago

Update README.md

b79d64339d8b85baf241318a5852ead50903b57a authored about 4 years ago

Repo initialization scripts

97c9188664d1b925393fda7be321b7457a3a474b authored about 4 years ago

repo name change

18a31c653e6666c3005fc21b8c134790ad59c0e5 authored about 4 years ago

formatting

e79cd6935dd1168f0a4dd7fa0daeddebd6c52786 authored about 4 years ago

typo fix and added clearing environment caching

bfe7ae7517cc5dc8a47d3b99a52d3d6c24868879 authored about 4 years ago

setting up the virtual environment

484c23d95526b4335bcae4c9e07e8899a5b5f147 authored about 4 years ago

initial setup

d9a3e756d5e22b988e2b14f41f8bee75d632ee8b authored about 4 years ago

Initial commit

f3a8229acc86bb1e42ceeb5e13262afcbec3360c authored about 4 years ago

Ecosyste.ms: OpenCollective

github.com/ClimateMind/climatemind-analytics