nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple stacked column bar charts for fixed-size groups of optional Y series values

tinad

Hello,
I'm trying to generate a report for a dataset containing the following fields:
<ul><li>ProJectName</li>
<li>EventId</li>
<li>EventName</li>
<li>StartTime</li>
</ul>For each ProjectName, I need to generate a stacked column bar chart having on X axis StartTime and on Y axis the count of EventId grouped by EventName (See the attached file).

Find more posts tagged with

Comments

micajblock

I am going to voice my opinion here. Don't do it!! Period! From a visualization perspective any stacked bar chart is completely useless with more than a few series. The point of a bar char is to be able to visually compare the size of the bars. As soon as you add multiple series to a stacked bar chart it becomes impossible to compare values.
Another very important note is that since the X axis is a date time the chart should be a line so one can see the trend.
If I was given this data what I would do is let the user select up to 5 events for a specific project and them use a line chart . That way the user can both compare the values and see a trend.

tinad

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="146029" data-time="1479487496">
<div>
I am going to voice my opinion here. Don't do it!! Period! From a visualization perspective any stacked bar chart is completely useless with more than a few series. The point of a bar char is to be able to visually compare the size of the bars. As soon as you add multiple series to a stacked bar chart it becomes impossible to compare values.
Another very important note is that since the X axis is a date time the chart should be a line so one can see the trend.
If I was given this data what I would do is let the user select up to 5 events for a specific project and them use a line chart . That way the user can both compare the values and see a trend.
</div>
</blockquote>
 
 
Thanks for your answer.
I agree wiith you. The stacked bar chart with so many events is completely useless, and my goal is just to reduce the number of events used to build the chart (also 5 as you suggest could be ok). My problem is that I don't want to leave to the user the task to choose the subset of events to use to build the chart, but I want automatically split the chart in more charts, each one built using a fixed-size subset of events.

micajblock

Try grouping the report on event name and change the interval to 'Interval' and use 5.

tinad

I tried to follow your suggestion without success.
 
Please find in attachment a little example built using the ClassicModels dataset.

micajblock

See attached example. The trick was to create a counter for the series. Look at the script on the data set. Then you have able with the grouping.
 
P.S. I still think this is a completely useless chart because there is no way to compare values from the different charts.

tinad

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="146115" data-time="1480003414">
<div>
See attached example. The trick was to create a counter for the series. Look at the script on the data set. Then you have able with the grouping.
 
P.S. I still think this is a completely useless chart because there is no way to compare values from the different charts.
</div>
</blockquote>
 
Many many thanks! It works exactly as I wanted!
 
Really, I completely agree with you on the lack of usefulness of this kind of chart, but this format is an explicit request of a customer and, as far as I'm concerned, I have fullfilled my purpose thanks to your precious support.