Level.com let's start with the total trips and hired Transportation this is the data set let's insert the first pivot table add the numbers for trips as a.
Count in the values field to get the total trips copy the previous pivot table for easier creation Now we will get the total of hired trans transportations we usually recommend.
Linking the text box to a separate cell use the vlookup formula to get the hired Transportation count in this video we will create the text boxes and charts and then we will.
Create the dashboard in the next video tutorial the next table will show the details about the trips classification add trips classif to the row and values field as you did previously link each.
Value to a text box next the driver and Buddy wages per trip classify column chart select the pivot table then insert.
A 2d column chart remove the chart Legend and make it small next we will analyze the cargo types select the pivot table then insert a 2d bar.
Chart we will get total expenses salaries and wages this table will be used for the dut chart showing the total salaries and.
Wages now get the percentage by calculating the salaries divided by total expenses select the table then insert a donut.
Chart remove the chart Legend and title it's time to get the expenses by month column chart add months in the row field and the expenses to the values.
Field select the pivot table then insert a 2D column chart remove the chart Legend and make it smaller next the total.
Posts Related:
- Power Apps New Features & Functions Index, Search, Find & Replace, String Interpolation
- Tutorial Airtable Automations with Make
- Fazendo Primeiro Cadastro de Membros - Planilha Cadastro de Membros e Controle de DÃzimos. #2
Distance the next step is to create a
Line chart to show the total trips by month and we'll add the ratio of differences between the previous.Month and now the total salary and wages amounts for the drivers then the total salary and wages amounts but for the Buddies this.
Time the final step of this analysis is to add two line charts showing wages by year one for drivers and one for buddies in this last part of the video tutorial we will create a table showing.
Details for the latest 10 trips to achieve this we will use the trips numbering from last to first now use vlookup formula to find these details.
Let's link these values to text boxes finally we will double check if we forgot to add any numbers or charts.
The dashboard's values are ready for use join our Channel membership and you will enjoy the next video tutorial however you can easily purchase this template from our website other-.