lesley

How to present information graphically or as matrix

Discussion created by lesley on May 3, 2018
Latest reply on May 4, 2018 by philmodjunk

Hi Folks

I am trying to present a visual of data that I have held in a global storage field in my layout. Ideally I want to pull a matrix together to show as follows - then I can use conditional formatting to colour code the boxes based on level of allocation

 

Burst Interval   19.7

Allocated          118

Unallocated      403

Burst Interval   next

Allocated          x

Unallocated      y

Burst Interval    next

Allocated           x

Unallocated       y

Burst Interval

Allocated

Unallocated

Burst Interval

Allocated

Unallocated

Burst Interval

Allocated

Unallocated

etcetcetc

Using information from here my CountStatus box - global storage which stores the count result for the records below.

 

 

Don't know if this would be possible via the charting methods in Filemaker which confuse me more each time I refer to them, or whether this is something that it would be possible to do via container fields.

Will need this to work with WebDirect.

Any guidance would be really helpful

 

Lesley

Outcomes