Remove some columns as choices from an Axis Selector

[astones]

Hello!

I'm interested in being able to have the dashboard user be able to select which columns to show on e.g. category or value axes, or in pie charts.

Is it possible to have this option in `Viewing` mode (not just Editing), so they can select from a dropdown which columns they want to show? Finally, is it possible to limit the choice of columns for a particular axis to a pre-selected few that I can choose when building the dashboard?

Thank you!

Adam

 

[barchiel33]

Hello @astones!

Yep, this is entirely possible! What you'll need to do is:

1. Add a text area visualization to whichever page you want to do this on
2. Add a drop down property control in the text area
   1. Add a document property using the New button which will hold the user's selected column
   2. Use column selection to populate the drop down list
   3. In the column selection interface, click "Select Columns"
   4. Move whichever columns you want to be available to the user into the rightmost column
3. In the visualization that you want to reflect this change, right click on whichever access you want to use the selected column for
   1. Click Set from property and select the document property from step 3
4. Done! When the user selects a value in the drop down, the chart will update to reflect the change.

[David Boot-Olazabal]

Hi,

Yes that would be possible, both cases actually.

Edit: I see that @barchiel33 already answered the first question. As we were typing in a solution at the same time, my first solution is exactly like the one above. But I'll leave it here for being complete in my answer. The second question is answered at the bottom of my reply.

For the first one, you can map your axis to a property. You right click on the axis column and select the 'set from property' option. You then select the property you want (in your case, a drop-down list):

Notice my drop-down list on the left hand side, which is a property control:
      

Now, whenever I map my x axis to this property control, each time I select a different column, the bar chart will be updated accordingly:

The second use case is also using properties, but instead of using a list of columns property, you define only those columns in a fixed list.
Notice the difference between the first and second option:

The drop-down list property control, looks like this now:

Kind regards,

David

[barchiel33]

@David Boot-Olazabal There's actually a difference between our answers to the first question and my answer actually addresses both questions. The main difference is that I used the Select Columns feature which adds a boolean column property to the table. When this column property is True, the column is included as an option, whereas if it's false, then it's not shown. This makes it so you can just select the columns without having to manually type in the column names in the Fixed value method. There is a potential advantage of the fixed value method though, with it you can have the drop down show a different name than the actual column name. For example, if I had a column called "Time To Order Completion / # of Orders (Hrs)" I could use "Hrs / Order" as the display name and "Time To Order Completion / # of Orders (Hrs)" as the value. 

[astones]

Thank you @barchiel33 and @David Boot-Olazabal for your quick and detailed responses, which are unbelievably useful.

[David Boot-Olazabal]

Hi,

Great to hear it worked out for you @astones.
And I do now see the differences in our solutions @barchiel33. It depends on the use case which one is better suited, but yours definitely needs fewer steps :-). 

Kind regards,

David