Jump to content
We've recently updated our Privacy Statement, available here ×

A separate chart for each group in the list


boribooger

Recommended Posts

hello! A have a table

secresultperson
1321
2121
33451
4531
1322
212
342
482
   

SELECT `sec`,
    `result`,
    `person`
FROM table

These data were grouped by people.

I create a group title in my blank A4 and place a chart, enter the confirmation date: 
Series: person, 
Category: second, 
Value: result. 

I thought I was filling each chart for each person with individual data, but I see this like multi chart for each person.

When I entered Series: “Series 1” in the field, I received the details of my second person for each person.

I need first chart with data first person and, for a second person chart with second person data. And this should be in Group Header

How can I get it?

Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Typically a data source is used in a chart, althopugh in this case you may need eiter a separate dataset / query.

Rather than aggregating on the report, use the field as the measure. Make sure no aggregation is being performed at either the group or chart level.

Alternatively, use a variable to control the aggregation (reset, etc.)

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...