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
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.
I did not understand anything
i want use two for
one for , for my agent
other for , for all data that i have
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.
Here are group sum and group count value procedures you can use ...
group_sum.aia (6.5 KB)
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