turtleData123
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Sisense Table with Aggregation Not Working
Hi All, Our Table with Aggregation widgets have all broken and we're only seeing the following: We are seeing this across multiple members. Has anyone else experienced this issue and does anyone have any info on whether the widget's support was removed, etc? Also, any solutions to fix would be greatly appreciated. Thanks in advanceSolved1.8KViews0likes7CommentsRe: Rolling 30-Day Average
Hey DRay, following up in case this issue comes up in the future - I got back from support the following: We're sorry for any inconvenience, but the following function is no longer officially documented or supported. It was deprecated some time ago, but it hasn't been removed from the product yet. Thank you for your understanding. I did make a forum post to suggest adding a new version of these RP functions over at Product Feedback. Thanks again for the help2.3KViews1like0CommentsAdd a new version of Rolling Sum and Rolling Average (RPSUM and RPAVG)
Recently, we were trying to create a widget using the RPAVG function for a rolling 30-day average, which broke our connection to the live model while working (to an extent) on an elasticube. The function worked past the first 30 days on the elasticube, while the first thirty days were (SUM N )/ N. This formula works past those thirty days, but for the first value, for example, gives simply the first value. A new version of these functions would be greatly appreciated.652Views9likes1Comment- 2.2KViews0likes0Comments
Re: Rolling 30-Day Average
We're on version 2024.3. I'm testing the RPAVG with an elasticube currently, and it's giving incorrect values (checked using excel). I've uploaded an image of the widget's configuration page, each formula is visible as the title of the respecting value, for reference. Additionally, we need the average to run through the first days as well, which this doesn't seem to do - it begins with the [ first day value ] / 1, and iterates2.3KViews0likes0CommentsRolling 30-Day Average
Hi all, We're trying to create a rolling 30-day average in one of our bar chart widgets. I've tried using different solutions found online, but they all involve RPAVG, CURRENTDATE or other window functions that seem to break our connection to the live model or throw an unexpected token. An example we found was the following: AVG( [ Total Value], RANGE ( PREV ( [Days in Date], 30 ), CURRENT([Days in Date]))) from which we got the 'not supported by Live Model' error. I've also tried repeatedly adding together ( [Total Value] , PREV( [Days in Date] , n)) from n=1 to 30, but this seems to overwhelm the widget and break connection with the model (though it works in theory, I did get it to work with smaller n, such as 5) Any help would be greatly appreciated.Solved2.4KViews1like6CommentsFront-End Running Sum Left Join using Filtered Measure - Filters Not Affecting Widgets
Hi community, Recently we used the Filtered Measure plugin to create some running sum measures for widgets, which works incredibly well, using these steps. However, when we add our dashboard filters to the measure, they no longer work in filtering the data on the chart - for instance, if we filter out a few customers from the total, the total numbers don't change. (Total sum, for example, stays $10m if I remove all customers, when it should be 0 or empty.) Has anyone experienced this and found a workaround? From my understanding, this occurs because the plugin is including values prior to dashboard filters taking place, and thus preventing the dashboard filters from fully affecting the widget, resulting in always having the full set of numbers as though it were unfiltered. I'm trying to find a workaround, but not sure how to go about it considering it's in the plugin. Any help would be great! Thanks in advance657Views0likes1Comment