Using the checkbox column type in a Table Visualization

[renzi.mendoza]

Hi,

I’m trying to use the checkbox column to know which items are selected by the user. However, I can’t seem to make it work.

Can someone give me an example on how the checkbox column type work?

Regards,

Renzi

[Inactive-Member-45702134]

Can you confirm the following to understand better your use case?

1. What is the expected result and can I have a screenshot from your view?
2. Are you trying to change hierarchy in row header to checkbox column type?
3. Can you share with me how far you went with implementing the checkbox column type? because you mentioned you could not get it to work.

I would also like to mention that the use of the checkbox column type is best applied to data with true/false values.

For example see use case below, showing a column type changed from text to check box with true or false values.

You would notice that the true values remained checked while the false value was unchecked.

Here is an article with more details

https://www.dundas.com/support/learning/documentation/data-visualizations/using-a-table-visualization#h5-12-1-column-type

Best regards

[renzi.mendoza]

I was intending to use the checkbox as a way to select the row. However, it seems that the checkbox is disabled and would just display the boolean data. Is that correct?

[Inactive-Member-45702134]

The column types are meant for displaying data source values and the checkbox column type is better suited for Boolean data.

To better assist you, can you help confirm the following in order to understand the ultimate goal of your use case and provide an appropriate solution.

• Is there a reason why you need to capture the item selected by the user?
• Do you want to show the selected row in the table? e.g. highlight the row.
• Do you want to perform more action on the selected data? e.g. filtering, navigating, drilling down or saving the information somewhere.

Best regards

[renzi.mendoza]

I’m currently using the tables to filter the other metric sets then after filtering I’ll hide the layer for the table. I would want to retain the selected rows by the user when the user re-open the table layer. In this case, I’m thinking of using the checkbox as a way to persist the selection of the user.

[Inactive-Member-45702134]

I have been able to recreate the scenario based on your use case using different features

• Formula measure with placeholders
• States

Please see below example of how this was applied using the assumption that the table contains some hierarchies and when clicked, the hierarchy value from the selected row would filter the other data visualization.

In my sample, I am using Adventureworks database and having Country in the ROW hierarchy and SalesAmount in the Measures.

1. Create a formula measure on the table with a placeholder
   

2. Click the placeholder to set it up as a String type and add a space in the Default value to be able to submit.
   
   

   

3. A new column would be created with the formula measure.
   

4. You can rename the formula measure to something shorter, e.g. SelectedRow
   

5. Add the parameter to link the place holder using the article (https://www.dundas.com/support/learning/documentation/analyze-data/formulas/adding-formulas#h7-parameter-placeholders)
   

6. On Table click event, add a filter interaction where you map the hierarchy to the above parameter. This step will set the formula measure to 1 for the selected row.
   
   

7. Then you can add a state on that formula measure column with the formula measure = 1 and set a color to that state.
   

   
   
   Once the state is configured on the formula measure, make sure you check off Apply State Styles to Entire Row.
   

8. Hide this formula measure column from the table.
   

9. After above steps, when you switch layers from the chart layer to your table layer, the table would highlight the previous selected row as shown in below:
   

   

Please tried this and let me know if that works for you Hope this applies to your scenario.

Best regards