In this lecture let's understand how do we build dashboard flood tabular reports and for joint reports
on water on the latest limitations we have in there.
Let's go ahead and create a dashboard.
OK.
This is the flood dashboard that we created for the somebody's dashboard.
And these are all the reports that we have.
And among all these report this is the only report that we have scheduled so that cities and we are
able to see this uptick signal here because it marks a schedule.
And the other reports that we have.
OK good.
OK.
Perfect.
So coming to the of dashboard so let's create a dashboard and let's choose the data tools to be the
tabular report and it shows the competence.
Say for example.
How does art and buckshot.
And similarly let's choose the other competence S1.
OK.
And for this dash let me choose this.
Make the line chart.
The pie chart.
The lunar chart
with the fun chart
tabular tabular
gauge
so ought be able to see this vivid they're able to generate dashboard for the tableau report for these
competence like the horizontal bar chart vertical bar chart the line chart by chart their delivery chart
the funnel tract.
Yes but you know we are not able to use these components.
Which ones the scattershot the gauge competent the metrics competent we drive without the competence
S1
that is the table.
Let me choose a tabular report.
OK perfect.
So what does that we.
Descend from this tabloid report do not support on The View all the confidence that we have in dashboards
means specific the sky target we can generate scattershot.
We can all generate the gauge competent.
We cannot build a dashboard using the metric competence.
But otherwise yes pretty much you begin use all the other competence and the option that we have for
competencies that we should feel spacious.
You can very much use it.
We should focus as national competence for building its dashboards but not for the tabloid report but
otherwise for summary reports metrics.
You can use.
We should force competence as wit.
And also that is one more important thing that we got to note that tabloid reports.
We will be able to generate dashboards only if we're role limited to specified in the tabular report.
But that is option for all limit.
And that is available only for the tabular report.
And if the rule the specified only then you can generate dashboards for tabloid reports and the maximum
value for all limit that can specify is ninety nine so these are the limitations that we have in generating
dashboards for tableau reports but pretty much the other options.
They remain the same.
That is a good attribute to have options but and you can make it medium wide and you can have the header
for that options and it can save the dashboards and places in the respective folders all those are pretty
much the same.
But just that the limitation comes in which competence that begin used and that could rule the implementation.
So let me quickly go see if the dashboard and let me see w the dashboard and let me.
We'll keep our effect and know that you can see all the dashboards are getting refreshed.
In the meantime I would also like to highlight one more important thing that every dash out here does
is completely pointless a dashboard light and we have kind of seven dashes out here.
So every dash out here can point to a different component and to a different data source meaning which
one dashboard can have different components associated to that and from different reports associated
to that.
Say for example this dash it can have a horizontal bar chart from somebody at a board and this component
can have a vertical bar chart from the metrics report.
This can have from a tabloid report.
So a dashboard can half competent define competence from different reports.
Okay so save close so once we save and close the dashboard we'll be able to see the dashboard.
That's perfect.
And these three dashboard components we should have ideally removed those dashboard competence because
these components are not supported by tableau reports.
So you know what again tool is the next with the added attributes to have a client you have an option
for deleting that particular dash so you can just delete off these three dashes out here.
OK perfect.
So now that we'll be able to see the dashboard that we created.
Yes that is a tableau dashboard.
And we know what all the restrictions that we have in tableau dashboard.
The next we are going to understand about these giant dash means a dashboard bit that data as well as
as a giant report.
Let's create a new dashboard and we got to choose the competent and the data source.
So the component let's say like horizontal bar chart and data as well as we go to add the joint report
OK so you data is all right.
So what is it says you must select use will as defined.
This also report for this joint a competent.
So how do we access that option in the data attributes.
You will see option that and like it says use chart as defined and this will set a board so go select
this option.
So automatically the chart that you defined the joint report will appear here and all the options that
you used to for defining the chart but there to pretty much be defaulted out here.
That's it is anyone not able to edit any one of these options out here that neither the formatting nor
the company competent data.
So because all these information are pulled from the chart that is associated with a giant report.
So say OK.
And you would automatically see the chart that you defined in the giant and the chart that we designed
as basically a horizontal out.
Right.
So you guys if you choose a vertical bar chart and if you choose the joint report again and good add
it all saying like use that option.
So let me go check this option.
And when I say okay automatically if you pick the chart like feel associated with the joint report meaning
which in spite of you choosing a different component still it will stick onto the same chart that we
designed with our joint report.
So why being a giant robot you got to be very mindful of this information s but it is just not about
building the joint report it is about the chart that you actually with that.
So the chart has to be in with your business requirement.
If a business warns of vertical by chart by Cha then you learn what you basically guard will cash a
check which is a pie chart on a vertical bar chart.
Then you guard your chart has to be a logical bar chart.
So we had this important thing in mind before you create a giant report.
So let me save the joint dashboard and let me call it joined a dashboard but in real time ideally we
do not name it like this.
Instead we would say like OK the sales dashboard are the marketing dashboard and that dashboard would
have some falsified actions that does respect to the sales team.
If it's a marketing dashboard you would have simplified actions with respect to the marketing team.
So the naming conventions in realtime would be something like the sales dashboard of the marketing dashboard
on opportunities of this month.
Thoughts on the overall understanding of the properties in something like that and now you can able
to see the dashboard which we just created go to reports the dashboard will be listed out there.
That is a joint dashboard.