This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Summary view with information and filter from four different tables

Posted on 03-15-2024 01:53 PM
caburity
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

I have something like that database structure:

TABLE_PRODUCT

IDNAMEFK_CATEGORY
1Product 11
2Product 21
3Product 32

TABLE_CATEGORY

IDNAME
1Category 1
2Category 2

TABLE_COUNTRY

IDNAME
1America
2UK
3Portugal
4France

TABLE_ORDER

IDDATEFK_CUSTOMERFK_COUNTRY
110/01/202411
210/01/202421
310/01/202431
415/01/202442
520/01/202452
610/02/202462
712/02/202473
805/03/202484

TABLE_ORDER_ITEM

IDFK_ORDERFK_PRODUCTQUANTITYTOTAL AMOUNT
111110
212220
313220
421110
531440
632220
741110
842330
943550
1051440
1152330
1253220
1361550
1462440
1563330
1671330
1772220
1873110
1981220
2082220
2183220

I'd like generate a summary view and I'd like have summary of sales by date, by country, by country and date, by month, by country month with:
Total value sold per category
Total quantity sold per category
Total value sold
Total quantity sold

e.g.

Sumary sales per day

DateCategoryTotal quantity sold per categoryTotal value sold per category
1/10/2024Category 110100
1/10/2024Category 2220
15/1/2024Category 1440
15/1/2024Category 2550
20/01/2024Category 1770
20/01/2024Category 2220
2/10/2024Category 1990
2/10/2024Category 2330
2/12/2024Category 1550
2/12/2024Category 2110
3/5/2024Category 1440
3/5/2024Category 2220
Total 54540

Sumary sales per Month

DateCategoryTotal quantity sold per categoryTotal value sold per category
Jan-2024Category 121210
Jan-2024Category 2990
Total Jan-2024 30300
Feb-2024Category 114140
Feb-2024Category 2440
Total Feb-2024 18180
Mar-2024Category 1440
Mar-2024Category 2220
Total Mar-2024 660

Sumary sales per day and Country

DateCategoryTotal quantity sold per categoryTotal value sold per category
Amรฉdica 660
1/10/2024Category 1440
1/10/2024Category 2220
Portugal 12120
1/10/2024Category 1660
2/12/2024Category 1550
2/12/2024Category 2110
UK 30300
15/1/2024Category 1440
15/1/2024Category 2550
20/01/2024Category 1770
20/01/2024Category 2220
2/10/2024Category 1990
2/10/2024Category 2330
France 660
3/5/2024Category 1440
3/5/2024Category 2220

Can anyone help me with this? Thank you.

0 5 77
Topic Labels
0 Likes
5 REPLIES 5

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

To start with,  you may want to take a look at the sample app Slice based on user input - AppSheet  from the help article Get started by using the sample apps - AppSheet Help

The sample app is meant for single user. But you could build one for multiple users by having a Users table.

 

 

0 Likes

Posted on --/--/---- --:-- AM
caburity
Bronze 3
Bronze 3
In response to Suvrutt_Gurjar
Reply posted on --/--/---- --:-- AM

Hi @Suvrutt_Gurjar,

Thanks for your time, but that doesn't help, because I need to filter information from different tables. I can't do an inner join or use other SQL commands to set up a database view, for example. I would need something a little more complex that could unify summarized data from different tables.

Can you help me about it?
Thank you.

0 Likes

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
In response to caburity
Reply posted on --/--/---- --:-- AM

Hi @caburity ,

Frankly, I have not studied your further summary requirements in detail. I will study and revert if I can come up with something useful to suggest within AppSheet. However, if you are doing extensive  complex aggregation, you may want to consider utilizing services of some other dedicated service for the purpose  such as Google Data Studio/Looker studio where you can link the backend data and build the necessary analysis.

Solved: [Preview] Rich reporting with Data Studio - Google Cloud Community

AppSheet is a mobile app platform with some basic charting engine , fairly advanced report creation automation, bar code , QR code reading capabilities. But still more advanced use cases for anything from reporting , charting to analytics point of view may use external integrations.

AppSheet does provide some basic grouping and aggregation capabilities as well.

Control grouping in a view - AppSheet Help

 

Posted on --/--/---- --:-- AM
caburity
Bronze 3
Bronze 3
In response to Suvrutt_Gurjar
Reply posted on --/--/---- --:-- AM

Thank you @Suvrutt_Gurjar, 

I'll have a look in Data Studio to try understand is it should be the solution that I Need. Thank you.

0 Likes

Posted on --/--/---- --:-- AM
Joseph_Seddik
Gold 4
Gold 4
In response to caburity
Reply posted on --/--/---- --:-- AM

Looker Studio (formerly Data Studio) is your answer. 

Top Labels in this Space