Workspace - Freeform Table - More than 5 columns - In Bulk

[JohnOFarrell]

Hi

In this discussion

Workspace - Freeform Table - More than 5 columns

How to have more than 5 columns was answered.

However I have a follow on question namely (actually responded to the original thread which is over a year old so trying for better luck with a fresh post)

Anyway to do this in bulk?  For example I would like to to pull over each individual US DMA (designated market area) in the USA (there are over 200 of them) just as the example above shows with "page views and country".

• Got the first five over by default.
• Then I have been doing "cntrl..select multiple individual DMA" and move them over in sets of five or six.
  • Challenge is that when I use the the arrow to open up all of the DMAs I get DMA from all over the world, each US DMA is sprinkled in alphabetically.

Anyone know an easier way to do this?

[fsakjlfdsakljfd · Accepted solution]

What is your end goal?
If for example you are looking to trend the values you might try putting dates within the columns, DMA's in the rows, and adding a column filter for USA?

If the goal is instead to extract the data (which seems more likely than trying to viz 200+ values in AW), it might be advantageous to use the API or even Data Warehouse.

As an FYI, if you select an individual value, scroll down, press shift, and then select a subsequent value you'll be able to access the entire range.  After that you can press ctrl to deselect values within the range.