22 Feb 2022 11:53 PM - last edited on 25 May 2023 05:51 AM by Michal_Gebacki
The customer created a nice dashboard with lots of funnel tiles and was happy 😀
But then noticed odd behavior when expending the timeframe of the dashboard over a day. Tiles were losing data 👿
We found the following message under funnel configuration when running long timeframes 🙄
To improve performance, your query was applied to a subset of 1/4th of the data. With your current average load, the maximum timeframe of the exact data is 19 h 21 min. The results have been extrapolated because the timeframe was bigger than this. To avoid it, you can reduce the timeframe to less than 19 h 21 min.
And after checking the UAs of the funnel we understood that they are sporadic and not used all day long and its look like that this is the root cause of losing data when look for long period of time.
Any way we can "ask" the tile not to improve the performance and select all the data for the requested timeframe or do you have another suggestion on how to funnel on sporadic UAs? 🤔
Thanks in advance
@yair_mashmor & Yos
Solved! Go to Solution.
Unfortunately, for your environment, the data limit on USQL is currently 19 h 21 min. There doesn't exist a way to tell Dynatrace to ignore this limit. See this same question asked here:
As a possible solution, you can create duplicates of the same tiles and set timeframe filters on each so that you can still compare the tiles over different timeframes. For example, the first tile can be set to now-12h, the second to -12h to -24h, the third to -24h to -36h, etc. I know it's not an ideal solution but it is something I used when I was met with the same limitation.
Thanks @AlexOsbourn for the workaround, not so elegant but should do the trick.
Anyhow it will good to get a switch that will tell USQL in some tiles not to stop after period of time.
All the best and stay safe