Windowed Function Beastmode Will Not Update Dynamically
Hi I need help using a windowed function in Domo. Here is my formula making up the "Fall Out Rate Average Line" column: sum(sum(case when `CanceledDate` is not null then `Units` when `DeclinedDate` is not null then `Units` else 0 end)) over() / sum(sum(case when `ApplicationDate` is not null then `Units` else 0 end)) over ()
Everything seems to work dynamically as expected until I apply a filter then the Windowed Function Column does not respond dynamically. (AKA the rate does not update)
Before Screenshot: (Numerator and denominator are highlighted)
After Screenshot: ( you can see the windowed function column is not dynamically updating it is stuck showing .13 the value above before the filter is applied)
Answers

Have you tried extending how many decimal places are showing on your Fall Out Rate Average Line? 44/319 and 44/329 are pretty similar, so it might just be a display rounding issue for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 
I have tried expanding the decimals yes, I tested it the denominator is stuck at 329. Thanks.
0 
@Matt_Umolac93 typically for trouble shooting window functions you should separate components into separate columns. i.e. put the numerator in one column and the denominator in another. this way you can isolate the culprit.
are you confident your CASE statement is working as expected?
if you write sum(sum(amount)) over () are you getting expected results? (have you had the feature enabled in your instance)?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 
Hi Jae, yes I separated out the numerator and denominator to troubleshoot. If I write your statement I am not getting the correct results, rather I get the denominator value before applying a filter.
0 
Could you do a call with me to look at this? If you have my work email we can jump on a quick call.
0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 288 Workbench
 4 Cloud Amplifier
 7 Federated
 2.8K Transform
 94 SQL DataFlows
 593 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 667 Beast Mode
 42 App Studio
 34 Variables
 644 Automate
 165 Apps
 434 APIs & Domo Developer
 42 Workflows
 3 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 378 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 5 Software Integrations
 109 Manage
 106 Governance & Security
 8 Domo University
 23 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 95 Community Announcements
 4.8K Archive