Curso AppSheet Express Aula 6 | Gráficos e Dashboards Interativos

Welcome to our free AppSheet course, AppSheet Express! Purchase the AppSheet Manual course: https://go.hotmart.com/R102103111Y In today's lesson, I'll teach you how to create your first interactive visual charts and reports in AppSheet. I'll also share new formulas for automatically calculating values, which are very important for data analysis. For anyone who wants to learn AppSheet, this is the ideal course. Learning AppSheet for free has never been easier with these lessons that demonstrate the potential of no-code. Through the AppSheet Express course, you will learn how to create your first apps, create your first dashboards and charts, and also how to configure screens and actions in the best way. The most complete free AppSheet course on the internet! #appsheet #nocode #googleworkspace #appscript #nocode - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Gemini Prompt: Download your database and add it to the conversation, then in the PROMPT field add this text: "I am using this spreadsheet as a database for an app I am creating with AppSheet. Please generate 50 rows for the 'Movement' table with various values. If you include a value that does not exist in the reference with the 'Category' table, also generate the 'Category' rows for me, but try to use few new categories. Remember that the columns of this table are configured as follows: MovementId: Key, Uniqueid() MovementType: Enum = Entry, Expense Title: Text Category: Ref to the 'Category' table, use only the values ​​that already exist in this table Value: Price, only values Positive DueDate: Date PaymentMethod: Enum = Pix, Debit, Credit, and Cash Status: Yes/No PaymentDate: Date, only when Status = True - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Formula for the ENTRIES column in the Months table: SUM( SELECT( Transaction[RealValue], AND( [Status] = TRUE, [TransactionType] = "Entry", MONTH([PaymentDate]) = [_THISROW].[MonthNumber] ) ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 🚀 Video Topics: 00:00 Home 01:06 Data Entry 02:16 Reviewing the App 07:31 Starting to Build the Views 10:16 Calculating Input Values 22:44 Calculating Expense Values 23:45 Important! Micro-adjustment 25:04 Creating Our First Chart 32:00 How to Add Charts to Dashboards 33:22 Chart by Category 43:47 How to Show the Balance 53:22 Finishing - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 🔴 Subscribe to the channel for more content focused on AppSheet and AppScript and learn how to professionalize your processes and spreadsheets! - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Social Media: Instagram:   / omatheuslops   TikTok:   / omatheuslops   LinkedIn:   / omatheuslops