Layout of Batch Chart

Question

I created an Interactive Chart that is batched by department so the Interactive chart is creating 22 charts. When I render the charts, they are all stacked, one on top of another. Is there any way to make the charts display in 2 columns so they don't take up so much room? I would really like to avoid having to add 22 Interactive Chart tools to get the charts separated for layout purposes.

I've tried using an Visual Layout tool and a Layout tool and neither of them seem to be giving me the options I need.

CharlieS · Accepted Answer

Hi @ChristinaFPE

This is possible by adding a Record ID, Formula, and Layout tool. Here's an overview of the process:

- Assign each Chart a unique, sequential Record ID

- Use a Formula tools to group those [RecordID] values into counts of how ever many you'd like on a row with the following expression (where '3' is the number of objects per row):

CEIL([RecordID]/3)

- Use this new [Row] field to group each row into a Layout field set to "Horizontal" orientation.

Then Render these new layout fields as before. Check out the attached workflow to see this in action.

Aaron_Harter · Accepted Answer

@ChristinaFPE attached is a workflow with Batch Interactive Charts laid out in two columns.  Prior to the Layout, you can utilize the Tile tool to create a grouping number.  In my example I'm creating 9 tiles, for your example with 22 charts, you'll want to modify this to 11 tiles.