Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Custom Group valueexpressions in charts

Avatar

Level 4

Has anyone come up with a way to chart based on a valueexpression in the grouping?

 

Or can we put a custom form on hours yet?

 

I want to create a custom grouping on hours for  a chart, ie if Hour Type = Task Time => Task Name otherwise Hour Type.

 

The grouping text mode is:

group.1.valueexpression=IF({hourType}.{name}="Task Time", {task}.{name},{hourType}.{name})

 

but you can't use that in charts right? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

 

Hi @The_Real_Melinda_Layten,

 

To answer your questions in order...no, no, and yes you can't.

 

Given that, if you'd like to chat about a (yes you can) Magic Report to do so sometime, please drop me a line at doug.denhoed@atappstore.com; it would be great to work together again.

 

Regards,

Doug 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

 

Hi @The_Real_Melinda_Layten,

 

To answer your questions in order...no, no, and yes you can't.

 

Given that, if you'd like to chat about a (yes you can) Magic Report to do so sometime, please drop me a line at doug.denhoed@atappstore.com; it would be great to work together again.

 

Regards,

Doug