AnsweredAssumed Answered

Charting question

Question asked by DavidZakary on Apr 22, 2017
Latest reply on Apr 22, 2017 by weaverd

Looking for some advice on a charting requirement.


Items can be stored on racks that are varying sizes; different rows, columns and a depth of either 1 or 2 units. I've built a system where the user can input the number of rows, columns and a depth and then a table of storage locations is created.


Once inventory has been assigned to a location on a rack, the client wants to be able to visually see what is in each slot - is it empty or occupied and if occupied what's in it (maybe a tooltip to display the item name).


As described to me, a scatter graph that is rows vs columns vs depth is desired. Or a visual cross tab report. Given that a rack can be variable in size - probably up to 20 x 10 x 2, creating a fixed cross tab layout is less desirable.


Questions - doable natively in FM (the z axis might be tricky) or better off using an external charting source - could be an embedded Javascript library or something online.


Any suggestions?