Bar chart with lots of data

[#1]

Hi everybody!  

I have a time-dependent characteristic. I want to display it in the form of a bar chart. I create bar chart, dimensions is a date (depends on the selected date range), expression is the characteristic.

appears scroll

I want that all the characteristics fit without to scroll.

I use axes property Continius

and scroll disappears. But also disappear and the individual bars.

I want to see the individual bars. Maybe can be done grouping data by month and show the sum value for the month. Depending on the selected dates change group (year, month, week, day).

Is it possible? if possible we would like to get an example of how to do.

[Roop]

You are correct in that your chart is showing bars but there are too many so they are merging.

You can create a drill-down group from your time field:

So in dimension for the chart select edit groups

Add a calculated dimension of =Month(Time_Field)

Then add your Time_Field

Finally name the group as _Time (so that it appears at the top)

Edit chart dimensions and remove your existing Time_Field and replace it with _Time

Now your chart will have the months on the X-Axis and you will be able to click on the month to explore the days

Hope this helps

[Roop]

You may wish to change the Month(Time_Field) to:

=Month(Time_Field) & ' - ' & Year(Time_Field)

as you have multiple years - sorry

[JoaquinLazaro]

Hi:

In Chart Properties, tab Presentation you can enable/disable the chart scrolling and you can set up the number of bars that you want.

Hope it helps you.

Joaquín

[JoaquinLazaro]

Hi:

In Chart Properties, tab Dimensions push in Edit Group to Add a new one with three fields: year, month and date from the calendar of your dimension.

You should create a Drill-Down group and Cyclic Group to understand and to check the difference between both.

Hope it helps you.

Joaquín

[#6 · Accepted solution]

In the end, I used a couple of bar charts with various groups and display conditions. thank you all!