How can I use two for each item?

seyed_ali_mousavi_al · February 5, 2021, 5:35am

hi
i want count my data that in a list from another list?
i have a csv list that all my data in this and want count how much of my agent repeted in a day.

plase help me
thanks

patel · February 5, 2021, 9:41am

I did not understand anything

seyed_ali_mousavi_al · February 5, 2021, 10:58am

i want use two for
one for , for my agent
other for , for all data that i have

i show my result in above picture.
my provlem that is i cant go to an item when i have to :
for each item
thanks

Taifun · February 5, 2021, 1:49pm

if your data is in a Google spreadsheet you could use the web component together with the Google Visualization API to use SQLish commands
see also App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps
see also the detailed guide by @TIMAI2 here.

this could be your SQL statement

select C, count(C) group by C

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

ABG · February 5, 2021, 3:38pm

Here are group sum and group count value procedures you can use ...
group_sum.aia (6.5 KB)

retail_sample-details.csv (998 Bytes)

Date,Category-SubCategory,Amount
2018-05-02,EXPENSES/BILLS,$5.00
2018-05-02,EXPENSES/BILLS,$3.00
2018-05-02,EXPENSES/CLOTHES,$7.00
2018-05-02,EXPENSES/FEES,$6.00
2018-05-02,EXPENSES/FEES,$4.00
2018-05-02,SALES/DRINKS,$1.00
2018-05-02,SALES/FOOD,$3.00
2018-05-02,SALES/FOOD,$3.00
2018-05-02,SALES/TOILETRIES,$2.00
2018-05-02,SUPPLIES/DRINKS,$5.00
2018-05-02,SUPPLIES/DRINKS,$2.00
2018-05-02,SUPPLIES/FOOD,$10.00
2018-05-02,SUPPLIES/FOOD,$2.00
2018-05-02,SUPPLIES/TOILETRIES,$5.00
2018-05-02,SUPPLIES/TOILETRIES,$3.00
2018-05-03,EXPENSES/BILLS,$1.00
2018-05-03,EXPENSES/FEES,$3.00
2018-05-03,SALES/FOOD,$6.00
2018-05-03,SALES/TOILETRIES,$4.00
2018-05-03,SALES/TOILETRIES,$7.00
2018-05-03,SUPPLIES/FOOD,$4.00
2018-05-03,SUPPLIES/TOILETRIES,$1.00
2018-05-03,SUPPLIES/TOILETRIES,$5.00
2018-05-04,EXPENSES/CLOTHES,$9.00
2018-05-04,EXPENSES/FEES,$5.00
2018-05-04,EXPENSES/FEES,$2.00
2018-05-04,SALES/DRINKS,$1.00
2018-05-04,SUPPLIES/DRINKS,$3.00
2018-05-04,SUPPLIES/FOOD,$4.00