astones Posted October 24 Share Posted October 24 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 Link to comment Share on other sites More sharing options...
Solution barchiel33 Posted October 24 Solution Share Posted October 24 Hello @astones! Yep, this is entirely possible! What you'll need to do is: Add a text area visualization to whichever page you want to do this on Add a drop down property control in the text area Add a document property using the New button which will hold the user's selected column Use column selection to populate the drop down list In the column selection interface, click "Select Columns" Move whichever columns you want to be available to the user into the rightmost column In the visualization that you want to reflect this change, right click on whichever access you want to use the selected column for Click Set from property and select the document property from step 3 Done! When the user selects a value in the drop down, the chart will update to reflect the change. 3 Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted October 24 Share Posted October 24 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 1 Link to comment Share on other sites More sharing options...
barchiel33 Posted October 24 Share Posted October 24 @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. Link to comment Share on other sites More sharing options...
astones Posted October 24 Author Share Posted October 24 Thank you @barchiel33 and @David Boot-Olazabal for your quick and detailed responses, which are unbelievably useful. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted October 25 Share Posted October 25 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 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now