Changing Cells
On this page, you will learn how to change cells in the visual, both leaf cells and total cells.
Leaf Cells
- Click on the leaf cell you wish to change.
- Make the desired changes. To submit these changes, press the ENTER key, TAB key, or click anywhere outside the edited cell.
- After submitting the changes, the visual will perform the necessary calculations for the total cells. This ensures you always have the most up-to-date information in the total cells, facilitating better decision-making.
- If the measure is a boolean it will appear a checkbox and to change just click on the cell to change the value.
- If the measure is a date, click on the cell and it will appear a datepicker to select the date.
- And if the measure it is text and have a data validation of List it will appear a dropdown when you click on the icon that appear on the cell.
Total Cells
- Click the total cell you want to change.
- Make the desired changes. To submit these changes, press the ENTER key, TAB key, or click anywhere outside the edited cell.
- After you submit the changes the visual will show you a popup with three different options for you to choose the best option to distribute the values to the leaves. For more information about the different options to distribute the values go to Distribute Values.
- Next up, the values of the cells will be updated with real-time calculations.
- Note that you can only change Total Cells when the measure is of a number data type.