frankmol
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Disable/Deselect all other Items in Legend by double clicking on item
Hi All, Im trying to change the functionality of the legend in a line graph. Now when you click on an item in the legend the item will be disabled/unselected and disappear form the graph. I would like the functionality to double click on the item and only select the one item. This is especially helpful if you display multiple lines in one graph.1.2KViews1like0CommentsRe: Replacin 'NULL' with '0' in in calculations for column chart and pivot table
Hey Vik, Yes i have, While it successfully displays the '0' value, I actually need it to be included in a calculation rather than just for display purposes. The column chart I'm working on relies on the same calculation as the table seen below, the expected markt total for Client 2 should be 'Primair 5,1%' and 'Secundair 12%' Hopefully this wil help!4KViews0likes0CommentsReplacin 'NULL' with '0' in in calculations for column chart and pivot table
Hi all, For a culumn chart I calculated averages and divided the percentages into segments, the percentages do not add up to 100% After some searching I found out that this is because the 'NULL' values are not seen as '0' and therefore the calculation is not performed properly. See the pivot table below, for this pivot table I want to replace the null values with '0'. As can be seen in the updated table, it can be seen that the table generates null values but does not include them in the calculation of averages. I've already tried to solve this using IFs , but without success.Solved4.1KViews0likes4CommentsRe: How do i disable toggle switch button in filterpane?
Hi Angelina, Thanks, this works perfectly for single filters, but when I add a dependent filter, the toggle button reappears. Is it possible to hide these toggle buttons as well? Thanks again for your help! Regards, Frank3.7KViews0likes1CommentHow do i disable toggle switch button in filterpane?
Hi, For my dashboard, I would like to disable or delete the toggle switch buttons in the filter pane (shown in the picture), so the users of the dashboard do not have the option to turn them on or off. I can't seem to find the option in menus. Is it possible to edit the script using JavaScript? Thanks!Solved3.8KViews0likes4Comments