Clay
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Change Legend Category Names
Hello. This script works, however it breaks the slice/filter option of the pie charts by adding the custom values to the filter list instead of using the original values when clicked. Is there a way to modify the script to use the original values for the "click to filter"? Edit: Removing the line that updates the data portion of the widget seems to have fixed this. Haven't extensively tested to see if it affects anything else though. Remove this line: value[panelIndex].data = newItemMapping[value[panelIndex].data]1.8KViews0likes0CommentsCalculate Days Until Date+3 Years
Hello, I am trying to calculate how many days until a certain date, provided date+3 years within a formula. All I want to do, for example, is show how many days it is until expiration, given expiration is 3 years after the provided date, but I can't quite figure out how to do this. I know Sisense and date functions are like oil and water for some reason but this isn't that difficult of a calculation. I should also mention, editing the underlying data source or elasticube (live model in this case) is not (nor should it have to be with a BI tool) an option. Scripting would be a last resort but not off the table. Any help would be greatly appreciated! Logically it would be something like this, but of course this doesn't work (not worried about leap years so 365*3=1095 to simplify) DDiff(NOW(),[MyDate]+1095) A very simple Excel formula for reference as well: DATEDIF(TODAY(),EDATE(A2,36),"d")Solved1.7KViews0likes3Comments