Prepare your graphics and display them in Timetonic. In this video, we'll construct two following graphs, merge them into a dashboard, and display them in Timetonic. We’ve seen in the previous video how to export data from a table in Metabase. We're in the intervention table exported and we find the prepared columns in the view for export. We have columns for date, type of intervention, status of intervention, client, technician assigned to this intervention, and the number of hours worked on this intervention. We will exploit this data to create graphs in the exported database of my workspace on Metabase. I have different options available to me. I can filter, create quick groups, and edit new graphics from this location. You can also find your database in "Databases". This one is ranked in Timetonic regarding us, and you have two options on your table for quick access. To speed this up, the radiography of the table is offered (hover over a table and click on the lightning-shaped icon for radiography). Metabase automatically constructs a series of graphs from your data, which might be necessary, for technical reasons, to observe the details of type fields for this export. So, here we are looking at the information for data outputs for each field. We will create a dashboard. We will name the dashboard. The dashboard is created. We have a tab and we can create our first graph. I click on add new graph and we will create a graph from a new question. So, I will select the question, I’ll go to the Timetonic database and arrive in the configuration window that allows us to specify what we want to measure. There, we will count the number of rows and group them by type of intervention, then we have options to filter, sort, and limit results. Customized columns and advanced options like joins are features we don't always use. We'll see a preview that allows us to view the appearance of the graph layout. By clicking on visualize, a side menu opens that allows us to choose the desired layout of the graph that we want to display. We will choose pie. We will validate. You can click on the small wrench icon that will allow us to improve, change the layout. You can change the colors. You can apply different layouts inside the pie chart for percentages or the names eventually. At the appreciation of the layout, we will validate. You can apply a filter. You can apply a quick group, edit the configuration again, and save. We will rename this graph. Our graph inserts directly into our dashboard. We can enlarge it on the dashboard for layout. We can move it optionally. Here, we can apply a filter only to the graph to rework the layout, duplicate or eventually delete it. Once completed, we save the dashboard. Let's create our second graph. We click on new, questions. We go to our table. We're in our configuration window. On the intervention table, we want to summarize the total of the hours column. So, we will make a cumulative sum on the total of hours we want to group by technicians assigned to interventions. We will visualize the data. We will change the graph format to horizontal bar graph. We can modify the graph layout to indicate hours on the Y-axis suffix. Once the graph layout is complete, save, rename, select our dashboards and save. We find ourselves with our second graph. In detail, we will personalize the layout for our dashboard, which now has two graphs, and we want to apply a date filter. It's a global filter for the dashboard. We can also apply a filter on each graph. We will select the column of date of intervention end. We will set a default value for the last 30 days and validate. Save our parameters. We have a filter applied to the last days follow-up and can choose to filter for the quarter or eventually for the year. And if we want to remove the filter, we just need to clean it. You can add seven types of filters. You have the date selector, which allows you to filter on a date range or a specific date. Temporal grouping, group dates by time unit, day, week, month, or year. Location, filter by a geographic location, country, region, or postal code. Text or category, to filter on text with conditions like contains, equals, or starts with, number filter on numeric values between two boundaries, superior to or inferior to, boolean filter on a true or false value, identifier that allows filtering on a primary key or user identifier. To edit the dashboard, I click on edit my dashboard, and I can add a title in the textbox, drag elements up, add links or iframes to make a database, a schema external, a video for example. I can add new sections and integrate the layout by selecting a question and directly searching for a pre-existing previously created graph within the dashboard. You can apply full-width layout and then save. To share your dashboard in your workspace, head to the share icon in the embed section. Click on the publish button. Your filter date parameter must remain editable if you want to let the user modify it on another page of date. Then, get the URL of the browser, return to your workspace, click on Add, select the module Dashboard, name the dashboard, paste the URL, and an option displayed with a checkbox appears at the insertion of URL, requiring a configuration of user filtering for the code in the Metabase dashboard that we see in the next video. Finally, click on Add the dashboard to see the Metabase dashboard appear on your workspace. You get in your workspace, the dashboards updated each with your export data. On the follow-up of your data, and there you go, you can now track and follow your data visually in your workspace with a dedicated instance, export through secure file transfer, data that remains within your perimeter, a visualization designed for sectors where data mastery is essential, not an option.
