Charting Related Records and Grouping

[ckai]

Buggered if I know how to do this or even if you can. I've been trying to sort it out for 2 days now.

I have a global table with a global start and finish date. I've created a relationship with another table (shiftsGraph) where the records from shiftsGraph are restricted to between the global dates, obviously.

What I'm trying to do is have a chart summarise the total hours for each day between the global dates. So the actual data looks like this:

Monday 10.5 hours

Tuesday 40 hours

Wednesday 2 hours

etc

I have a summary field the calculates the total hours and I dayName field but all I can graph using the related table option is a record for each one of those shifts that fall between the global dates. So instead of showing say 2 totals for a 2 day period I'll maybe get 9 since there are 9 shifts that fall within the 2 day period.

If I base the table on a found set, run a find, and sort the records, they're all grouped nicely like they should. Does this mean using the related record method can't group the records?

The only reason I decided to use the related record method is the speed of changing the global dates. Otherwise I would have to use the dates in a find script which seems slow.

Any ideas/workarounds/ or the like?

Thanks all

[comment]

This is not really a charting question. You cannot chart data that cannot be accessed and displayed as such. Sub-summarizing a portal, though possible, is far from being simple or fast. OTOH, there is no reason why a find (using the same global fields for entry) shouldn't be instant.

[ckai]

This is not really a charting question. You cannot chart data that cannot be accessed and displayed as such. Sub-summarizing a portal, though possible, is far from being simple or fast. OTOH, there is no reason why a find (using the same global fields for entry) shouldn't be instant.

I've heard you reply a few times to others on "charting issues" that it's not in fact a charting issue. I did think about that but thought I could display the required information. Turns out I can't!

It slipped my mind regarding how filtered relationships work in regards to displaying them in a portal.

I've spent too much time on this so I'll have a look at going down the find route. This I know I can do Hence why it was my backup plan. It'll just take a little more planning.

Thanks mate. As always, your knowledge has helped my over-complicating brain simplify :)