ContributionsMost RecentNewest TopicsMost LikesSolutionsRolling sum for 12 months RPSUM I want to get a rolling sum for 12 months broken by each month. In past community posts it was mentioned to use a function "RPSUM". could not find this function is this function deprecated now? https://community.sisense.com/t5/knowledge/rolling-trailing-12-months/ta-p/565 Is there any other way to achieve this Re: SiSense Security Concern True it's a very vague email.. don't have any detail on what type of customers where affected.. changing all password and keys is a tedious task.. don't have any clue how self hosted customers will be affected by this. And no response from [email protected]. latest email mentioned to open a serv 1 ticket. When opening serv 1 ticket response from customer support is send questions to [email protected]. its just going in loops Re: SiSense Security Concern Is this only affected to sisense cloud customers?.. does it affect self hosted customers? Maps for zip code We have to visualize some data which are zip code level , I had tried the scatter map widget but it just breaks when number of records are high, is there any map widget which show data at zip code level Adding Grand Total in Bar chart Is there a way to add grand total in bar chart like below Display all the values in Million (M) pivot Is there any way to show all the values in millions even if data is in thousands, the default million formattings will show the values less that a million in the regular format Sorting on two columns in table widget I want to sort a table widget based on two column, first sorting based on Column A and then Sorting based on Column B so it will come within sort values of column A, is it possible is sisense table widget Default the end date to yesterday or today date in calendar filter Is there a way to default the 'To Date' to latest date or Today always, so when the user runs the dashboard it will be refreshed for latest date, now the user have to manually select the To date to latest date every time they run the dashboard Freezing the header row for a pivot table Is there any way to freeze the header row in a pivot table, when the number of rows is very high it is difficult for users to scroll up and see what each column refres to SolvedCreating rolling sum for 30 days We are trying to build a pivot where each week will show the running sum of the past 30 days , is there any way we can achieve this in dashboard level