Hi. I am attempting to create a scatter plot that represents the distribution of teleconsultations over time. I'd like to do so as shown in the image below, but am struggling with it.
Below is my code and a data sample. Any help will be much appreciated
Below is my code and a data sample. Any help will be much appreciated
Code:
gen one = 1
collapse (count) one, by(year month)
gen time=_n
tsset year month
twoway (scatter one time), title("Teleconsults, 2022-2024") ytitle("Number of teleconsults") ///
yscale(range(0 .)) ylabel(#6, labsize(small) angle(horizontal)) ///
xtitle(year)
Data Sample:
input str16 id float(year month) str4 hospital str55 location str4 department long state
"ADL-N10408" 2022 9 "KAR" "Ruyyadi" "RET" 31
"ADL-N15197" 2022 2 "KAR" "Echoda" "COR" 31
"ADL-N15739" 2023 1 "KAR" "Dasnapur" "GLA" 31
"ADL-N16765" 2023 2 "KAR" "ananthpet" "RET" 31
"ADL-N17225" 2023 5 "KAR" "Yenda" "COR" 31
"ADL-N17329" 2024 6 "KAR" "siri konda" "COR" 31
"ADL-N17536" 2023 7 "KAR" "venunagar" "COR" 31
"ADL-N17551" 2023 8 "KAR" "Darati" "RET" 20
"ADL-N17771" 2024 6 "KAR" "Kumhari" "RET" 31
"ADL-N17771" 2024 6 "KAR" "Kumhari" "RET" 31
"ADL-N19187" 2024 6 "KAR" "Sunna" "COR" 20
"ADL-N19203" 2024 5 "KAR" "Pembi" "COR" 31
"ADL-N19217" 2024 5 "KAR" "Lingi" "RET" 31
"ADL-N6440" 2023 8 "KAR" "Near Governament Hospital" "GLA" 31
"ADL-P1489" 2022 3 "KAR" "girnur" "RET" 31
"ADL-P1489" 2022 6 "KAR" "girnur" "RET" 31
"ADL-P1489" 2022 9 "KAR" "girnur" "RET" 31
"ADL-P37954" 2022 2 "KAR" "Chanda" "GLA" 31
"ADL-P49094" 2022 3 "KAR" "Hyderabad." "COR" 31
"ADL-P49108" 2022 1 "KAR" "Mavala" "RET" 31
"ADL-P51228" 2022 1 "KAR" "Jannaram" "COR" 31
"ADL-P51562" 2022 3 "KAR" "shanthinagar" "GLA" 31
"ADL-P52047" 2022 12 "KAR" "Khanapur" "PED" 31
"ADL-P52047" 2023 12 "KAR" "Khanapur" "PED" 31
"ADL-P53862" 2022 8 "KAR" "Shanthi Nagar" "RET" 31
"ADL-P54278" 2022 1 "KAR" "MALIPURA" "PED" 20
"ADL-P54278" 2022 2 "KAR" "MALIPURA" "COR" 20
"ADL-P65191" 2022 7 "KAR" "NIRMAL" "COR" 31
"ADL-P66047" 2022 9 "KAR" "Bazar Hathnur" "UVA" 31
"ADL-P66885" 2022 9 "KAR" "Adilabad" "GLA" 31
"ADL-P67427" 2023 1 "KAR" "Adilabad" "RET" 31
"ADL-P70072" 2023 2 "KAR" "" "RET" 31
"ADL-P71458" 2023 7 "KAR" "Mavala" "RET" 31
"ADL-P71790" 2023 6 "KAR" "Dhoki" "COR" 20
"ADL-P73744" 2023 12 "KAR" "Tirpelly" "COR" 31
"ADL-P74131" 2023 6 "KAR" "mangarla" "COR" 31
"ADL-P74737" 2023 10 "KAR" "Kinwat" "COR" 20
"ADL-P76049" 2023 12 "KAR" "Indervelli" "COR" 31
"ADL-P76904" 2023 11 "KAR" "Devapur" "COR" 31
"ADL-P77693" 2023 11 "KAR" "Nirala" "RET" 31
"ADL-P78461" 2024 1 "KAR" "Ralegaon" "RET" 20
"ADL-P79671" 2024 5 "KAR" "Adilabad" "UVA" 31
"ADL-P79671" 2024 5 "KAR" "Adilabad" "UVA" 31
"ADL-P79731" 2024 2 "KAR" "borikelapur" "RET" 20
"ADL-P81226" 2024 6 "KAR" "adilabad" "COR" 31
"ADL-P82091" 2024 5 "KAR" "adilabad" "PED" 31
"ADL-P9506" 2022 4 "KAR" "Rajura m" "RET" 20
"ADL-PN50306" 2023 8 "KAR" "Khodad" "COR" 31
"ADL-PN56519" 2024 3 "KAR" "Yavatmal" "COR" 20
"ADL-PN57843" 2022 2 "KAR" "Adilabad" "COR" 31
"ADL-PN58736" 2022 2 "KAR" "Nirmal" "RET" 31
"ADL-PN63748" 2022 4 "KAR" "Adilabad" "RET" 31
"ADL-PN65220" 2022 7 "KAR" "tatiguda" "RET" 31
"ADL-PN66138" 2022 12 "KAR" "Khanapur" "OCU" 31
"ADL-PN67892" 2022 10 "KAR" "Munial" "COR" 31
"ADL-PN67892" 2023 3 "KAR" "Munial" "COR" 31
"ADL-PN79188" 2024 2 "KAR" "uthnoor" "PED" 31
"ADL-PN79407" 2024 2 "KAR" "Bela" "COR" 31
"ADL-PN79799" 2024 2 "KAR" "Bheemsari" "COR" 31
"ADL-PN80431" 2024 4 "KAR" "pochara" "COR" 31
"ADL-PN82235" 2024 6 "KAR" "Ada" "COR" 31
"ADL-PN83891" 2024 7 "KAR" "Gimma Buzurg" "COR" 31
"BAM-N10299" 2023 3 "BBI" "Barida" "OCU" 25
"BAM-N10375" 2023 10 "BBI" "Hukuma" "OCU" 25
"BAM-N10641" 2023 7 "BBI" "Phulta" "PED" 25
"BAM-N10641" 2023 7 "BBI" "Phulta" "PED" 25
"BAM-N10737" 2023 6 "BBI" "Banabulapalli" "PED" 25
"BAM-N10737" 2023 7 "BBI" "Banabulapalli" "PED" 25
"BAM-N11314" 2024 1 "BBI" "Naikanipalli" "PED" 25
"BAM-N5538" 2022 5 "BBI" "Kumuli" "COR" 25
"BAM-N8198" 2022 1 "BBI" "Tillory" "IVR" 25
"BAM-N8254" 2022 4 "BBI" "Rambha" "GLA" 25
"BAM-N8899" 2022 7 "BBI" "Karatoli" "RET" 25
"BAM-N8899" 2022 7 "BBI" "Karatoli" "RET" 25
"BAM-N9723" 2022 10 "BBI" "Parlakhemundi" "PED" 25
"BAM-N9904" 2022 12 "BBI" "Rangailunda" "OCU" 25
"BAM-NP11173" 2023 12 "BBI" "B.L.n.pur" "PED" 25
"BAM-NP11183" 2024 2 "BBI" "Jagadebpur" "NRO" 25
"BAM-NP11328" 2024 1 "BBI" "Sarabadi" "NRO" 25
"BAM-NP11328" 2024 2 "BBI" "Sarabadi" "NRO" 25
"BAM-NP11328" 2024 2 "BBI" "Sarabadi" "NRO" 25
Attached Files
