Beast Mode Values are changing on Drill Down
I have a Calculation in a Beastmode that is calculating the Length of Repai Cycle. The calculation is accurate and when run on its own it produces the correct number.
However if I put that Beast Mode Calculation into a Drill Down path the values displayed for that calculation are not correct.
So for example I can drill down from Region to Market to Location and each shows the Length of Repair, however when I get to the location the Length of Repair for my test location is showing a value of 9, when I open this drill down level to edit in Analyzer, or even if I run it in its own card I get a value of 6.1.
The 6.1 is the correct value but I can't for the life of me figure out why when its part of a drill path it comes up with the wrong number and even the edit shows the correct value, just not when your viewing the card live.
Any hints on what to look at would be greatly appreciated.
Thanks
Randy
Comments
-
Is anyone able to help out with this request?
0 -
Hello @Randyb,
It would be great to get a copy of what your calculation is. My thoughts are that the beastmode changes based on the grouping of a card.
This is purely an example because I do not know your calculation.
If I am dividing by a COUNT(`date`) when my card is grouped by 'Day', I will divide by the number of records I have for that day. Whereas if I divide by COUNT(`date`) when my card is grouped by Week my divisor value will increase.
So when I have a calculation similar to: MAX(`value`) / COUNT(`date`) I could see a value different than I expect depending on my card grouping.
This question sounds like it might be an in depth question that would require looking at your card to see the layout, data, and beastmode. I recommend reaching out to our support team to get some assistance with additional questions you have in regard to this. You can reach them through the support portal support.domo.com**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive