- Welcome to this tutorial,
on how to create a chart using eazyBI.
We have divided this topic into two videos
and this video we will focus on the main
customization options of charts
and how to mix different types into one timeline chart.
While the second video explores,
other frequently used chart types
and how to adjust them
in order to get a useful final report.
In the previous video,
we learned how to build a report using eazyBI dimensions,
add measures.
We created the table with the predefined measures,
issues resolved and hours spent.
And added calculations for trend line and cumulative values.
In this tutorial we will save some time,
by using the report to create a chart.
It just needs a little simplification
by moving the issue type dimension into pages.
So we can concentrate more on the chart itself.
Charts enabled us to visualize the data
and make it easier to identify trends at a glance.
In eazyBI there are different types of charts
and each one of them suits different purposes.
They can be combined or used in different ways
that best meet the needs of the report users.
Let's start.
Since we are using the time dimensions in our report,
the timeline chart is the best match for the data.
Click the timeline tab.
When we switched to the timeline chart,
we can see that this perhaps
isn't the most compelling report ever created.
With the current selection,
all measures are represented as lines
which doesn't tell us much.
However, with some adjustments,
this view can change completely.
The first thing we will do,
is changing the view from the lines to columns.
Better already, but still there is room for improvement
as we have values with two different units in our report,
the count of issues and the hours logged
It would be better to display measures in hours
on a separate axis.
These simple changes have made the support much more useful,
but we can make it even more robust
by combining different chart types and the same report.
Let's use a dashed line for the resolved issue trendline
and area for cumulative hours spent.
We can also change the color which resonates better
with the nature of the selected measurements.
As we have account of issues resolved, and hour spent
as well as two additional measures using those units.
We can simply use two colors in the chart
to differentiate them.
We are almost there,
but the area of its cumulative hours spent
is taking a lot of attention.
It would look better,
if this measure would be in the background
so we could see other measures too.
Since measures in the chart are displayed
in the same order as in the table,
we switched to the table view
and move this measure into the first column.
Now we can switch back to the timeline chart
and it's looking great.
Last but not least, you can add a bit more detail
for users to better perceive the information.
Add names to axes so we can easily understand
which axis for which measure.
For clarity a description also could be added to the report.
Now we have completed the first chart.
Don't forget to save it.
Before we move on, there are a few more things
on the timeline chart to explore.
Like we did in the previous video,
when we build a report table,
the same page filters are applied to the chart.
Also like for the table we can drill into
or across the issues,
to see the issues behind those calculations in the chart.
A cool feature specific to the timeline chart
is the ability to zoom in on the time period
you're interested in reviewing.
Before we resume the video, let's do a quick quiz.
How data in the report chart are related
to the data in the report table?
The chart contains exactly the same information as the table
and data in them are changed simultaneously.
You can switch between the table and the chart at any time.
Charts and tables are defined separately.
Once you have started changing something in the chart,
data there are no longer comparable
with the data in the table view.
Tables are interactive, while charts are just cool pictures,
you can draw some additional information on.
The first answer is the correct one.
During this video, we learned how to display report data
as a timeline chart and customize it.
In the next video, let's get a quick overview
of the other most frequently used charts.