-
Why would a copied card have a different Type in a duplicated beast-mode field?
I made a copy of a dashboard that copied all of the data cards as well. The copied dashboard I've been playing around with the tooltips on a map. My modified map is having some different behavior to the original map. In troubleshooting I noticed that the original's field used in Values...is Text, but in the copy, it is a…
-
Beast Mode Manager - Cards using this Beast Mode
I'm working on some consolidation and updates to some frequently used Beast Modes. On the Beast Mode Manager page, one of the formulas in question is used on 103 cards. But the summary only shows 20. Seems the list has a hard cap of 20. How do I see all cards using this formula? Is there a setting to show all somewhere? Or…
-
Help calculating YOY and MOM beast mode calculations to be used in a standard table.
Data pulled in via API. Data using to calculate in use in other cards, so is clean and robust. Just need somebody with a little more expertise.
-
Datediff Beastmode Help
I am attempting to write a beastmode that will give me all cases (tickets) that have not been updated within the last two or more days. Here is the beastmode I am attemping to create but get asyntax error. Can anyone advise? (case when DATEDIFF(`Current Date`, `Date Last Updated`) >= 2 end) Thanks
-
Deleting Beastmodes
I am almost 1 year into using Domo and am in the process of trying to clean up cards and datasets and would like to remove old beastmodes. I am having trouble where Domo is telling me the beastmodes are in use on cards that I cannot find or access in my instance. I am an administrator of my instance so I should be able to…
-
how do you find the maximum number of column value & substrct
Dear All, Below is pivot table created via chart type in domo I want subtract latest week - week 1(e.g. week 4 - week 1 next time week 5 (dynamic) - week 1) next time week 6 (dynamic) - week 1) e.g 1276 - 319 = 957 result simultaneously other line as well in one column Regards
-
Visualizations don't fit into report
I created some pivot/html tables for reporting purposes but they are relatively wide with a few rows. When I try to export it as a report columns toward the right hand side of the table are being cut out from the report. Is there a way to adjust the width of the table so it fits into the exported page width of the report?…
-
Beast Mode - Refer to Other Segments in Case Statement
Basically, what I'm looking to do is create a percentage column in the dataset. For example: Let's say I have some shapes: 'Rectangle', 'Square', 'Small Square' How would you go about creating a variable that shows the percentage of that shape as compared to the next largest category of shape? For example, the column would…
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
COUNT(DISTINCT... CASE WHEN... THEN)
Our company just adopted DOMO and this beast mode is always registering as invalid, but it seems to be the correct syntax (or so I thought), any ideas as to what I am doing wrong COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled')
-
Renewal Rate Calculation
Hello! I have my data set pulled in and I cannot figure out the best way to calculate the renewal rate or churn rate. The calculation is taking a specific timeframe now, say all of March 2022. Then taking that total paid about and then dividing that by the same time period last month. So looking at period over period, but…
-
Beast Mode returning greater than 100% for Performance KPI
To keep it as short as possible, I have an On-Time delivery KPI. However, I have to measure on-time/late from two different columns depending on the type of delivery it was. I'm using this beast mode formula to capture those criteria, and then just simply divide it by the total number of deliveries: (sum(case when…