Hi everyone,
I am using extensively the new set actions and they are great! except when all the elements don't fit on the dashboard. I explain:
I am using shapes to put the custom logos of different elements and they are divided in 3 categories as per image attached (random shapes in this case due to confidential data).
The first two categories don't have as many elements as the third one so in the third one appears the "..." and some of the elements (logos) are hidden. I thought I could solve it by either 1) allowing the user to click on the "..." to expand that category or 2)reduce the space between category 1 and category 2 to make the third column bigger. Unfortunately I wasn't able to find how to do any of these two things, as I see it there is no way to expand the 3 dots and all three columns are forced to always have the same size.. any ideas?
I also tried an alphabetical search but when the user clicks on it the menu is filtered and then if it had to go to a different letter the first element is removed.
Any other way to allow the user to select the members of a Set ?
Thank you,
Nerea
Unfortunately to the best of my knowledge there is no way to expand the ellipsis to view the remaining members. However, with some table calculations you could organize your shapes into rows and columns, which would allow your table to scroll down. Try this:
- Create the calculated fields [Column] : INDEX()%3 and [Row] : INT((INDEX()-1)/3)
- Make both calculated fields discrete
- Add [Column] to Columns and [Row] to Rows
- Edit the table calculations of both fields, and set them to use whatever field you are using to distinguish your marks / shapes / logos
- Deselect "Show Header" for both fields
- Set your worksheet to "Fit Width"
You can change the number 3 in the calculations for whatever number of columns you want.
