-
Case statement with two conditions
Hey! I have a case statement below for inventory to create a pie graph. Case WHEN `AVAILABLE_COUNT` <= 20 THEN 'Out of Stock' WHEN `AVAILABLE_COUNT` >= 40 THEN 'Sufficient Stock' Else 'Low levels' End The only problem is that I have 2 warehouses I included as filters. However, when the data populates it separates the two…
-
MTD Beast Mode
Hello, I am trying to gather a running total of an amount for a Bar Line Chart Card. Mathematically it should go: June 1st (Σ June 1st's Amount) June 2nd (Σ June 1st's Amount, June 2nd's Amount) June 3rd (Σ June 1st's Amount, June 2nd's Amount, June 3rd's Amount) ... June 31st (Σ June 1st's Amount, June 2nd's…
-
DataSet API: CSV options and alternatives
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
Conditional colouring
Is there a way that I can conditionally colour one line/bar in relation to another dynamically-changing value in the chart? I.e: if line/bar for actuals are above target then the colour changes from red to green? (Note: the goal-line in the chart is not helpful because the target values dynamically change). Many thanks!
-
How to show Group Total as # while Bars are shown as %?
I have a card right now using a Nested Bar Graph and I'm showing the series bars as % using the Data Label Settings as '%_PERCENT_OF_CATEGORY' but when I check the 'Group Totals' box it shows the total as a 100%, which is pretty useless to me because I want to see the actual count. How can I do this? I thought about…
-
道場内でのDOMO社の添付資料を検索したい
いつもお世話になっております。 「サマリーの活用.pdf」や「期間比較カードの作り方(3種類).pptx」など 道場内にあるDOMO社作成の資料を検索できる方法はないでしょうか? もしくは、まとめておいてある場所がありましたら ご教示いただきたいです。
-
Fix for concatenated summary number rounding issue - use to articulate data in full sentences
For the past three years we have been using concantinated summary numbers to articulate the results of our multitouch attribuiton models. I hope that sharing these will spark some interest in experimenting with more literary articulations of your data. We have been experiencing some issues since the update where…
-
How to apply Domo email?
-
Error in dataflow transform
I am looking to store a couple values in variables, to avoid clutter, of my MYSQL transform and am running into problems. How can I set variables in a transform and then use later in that transform? Here is what I have currently and then I call these variables later in the transform... -- Variables of actions taking place.…
-
How to change a string to date ?
Hi all, Domo has identified the Date Column as Text/String. I need to use this column in the quick filters on the card. I tried using STR_TO_DATE function, but it is not helping The data in the Date Column is mm-y format - Jan-18 (Example) Kindly help
-
I need to extract data from a string but I can't use charindex. What should I use?
So in Beast Mode, I want to calculate a new field from a current field. I want to get the first two pieces of data from a string like Email: DHE: DHE:read-more-horoscope-button so that the new field would read Email: DHE The pieces of data are 1) not a uniform character length, and 2) sometimes this current field only…
-
Not all accounts selected, is being displayed on the donut card
Hi, I have created a donut card to display 10 accounts. I have added a filter to select the accounts that I want to show on the card. But when i save it the last account is unselected and the sum total changes. When i click on the account, it appears on the Donut card and i click save it disppears again. Does anyone know…
-
Anyone have an SOP or form people in an organization use to ask their Domo admins to create cards?
Anyone have an SOP or form people in an organization use to ask their Domo admins to create cards?
-
Sorting Series AND Date (X Axis)
I'm trying to have the series' legend sorted alphabetically (which almost every other system automatically does) AND show the dates on the X axis in order (January before February before March...) (which should be pretty standard). I can't seem to figure this out. My chart either sorts the legend alphabetically but puts…
-
Page Analyzer Link filter not working
I am attempting a page analyzer link filter. It takes me to the page, but no filtering. Here is the beastmode: CONCAT('<a href="https://my_url.domo.com/page/-100000/kpis/details/xxxxxxx'…
-
Calculating Percentage based on multiple dates; calculations based on date selection
I would like to the calculate the percentage of employees who participated in certain programs (ProgramEnrollDate and ProgramDisEnrollDate) while employed (HireDate and TerminationDate where TerminationDate may be null for currently employed employees) in self-sufficiency improvement programs based on a selectable…
-
Category Scale X
Hey community, I have a x-label labels like below. ( overfitted words) Is there a setting allows me to rotate the labels horizontally? Thanks!
-
How can I change the setting for X and Y Axis.
I would like to change the Y Axis with Time format and X Axis for date format.
-
Linking two different cards in drill-down path
I have a pie chart, and I would like to link each wedge to a different card, but this option does not seem to be available in the drilldown edit menu. Can I do this through a beastmode script? Or is this not supported in Domo? If not, is it possible to simply link a card to a select set of different cards so that a user…
-
Sharepoint online data conector error type of file
I make a domo- sharepoint online connection at that point everything is right , when I try to recover the metadata and content of the file I am getting a type of file error , even I am selecting correctly .csv any idea?
-
Receiving Error when running domo build or domo login
[ERROR] The domo cli tool has experienced an error. As it is [ERROR] possible this bug has already been fixed, please try updating [ERROR] using `npm install -g ryuu` and run this command again. If this [ERROR] does not fix the issue, please contact your MajorDomo. [ERROR] error message: Login.getMostRecentLogin(...).then…
-
Collapse / Uncollapse Columns
I've been attempting to use the uncollapse columns feature to flip the dimensions of my dataset that has only 2 columns. I think I have been filling out the drop down boxes correctly, except maybe the second requirement: selecting columns that identify a row. Here is an attached example of what I need to flip. I want to…
-
Course Builder Slow
I have been having some issues with Course Builder being extremly slow and leggy the past couple of weeks. Is there some sort of update or anyway I could improve how it runs? Is anyone else having this issue?
-
ETL Calculation Error Illegal Type Change
I have a calculation in the ETL taking two Decimal(fixed) fields and adding them together but I receive this error when I run the preview: illegal type change from java.lang.Double to java.math.BigDecimal Anyone seen this before or know what this means?
-
Magic ETL equivialent to "Group" in excel
Hi, If I have an excel sheet with grouped columns in multiple layers as in the screenshot: Food is the big category ( that is the total of the others) , food at home is a sub category (total of the others) etc.. Is there a way to re-devide the data that way in domo? Thank you!
-
Is there a way to change which axis shows up on the left/right side for a combo chart?
When building a column + line chart or a column + symbol chart I can't figure out a way to change which axis label shows up on the right side of the chart. In the example image I've attached, I would want to move the % axis to the right side and the 'Num' axis to the left side.
-
YoY Beast Mode Issue - "Issue Occurred While Processing"
Hello, I'm relatively new to Beast Mode within DOMO and am running into issues trying to build a year-over-year calculation. I've built the below script, which was accepted by Beast Mode but is now giving me a "an issue has occured during processing" error. Any ideas on how I could fix this? CASE WHEN `Actual Revenue` = 0…
-
Convert Column Type: ETL or SQL
Hi, I have a column that contains letters from a to k and also numbers. I would like to replace the letter with 0 and change the column type from text to numbers. While doing this on ETL the run fails. The way I did it was: 1- replace text and enter each letter to be replace by 0 2-set column type I don't understand why I…
-
filters question
When adding filters on a card is there a way to have it so that if it meets the criteria of any of the filters added not all? We have 3 fields which are needing to be added to a filter but it can have any of the data from each filter and not all? If that make sense? thanks
-
Unable to Load Dataflow
Hello! I've recently had a few DataFlows transferred over to me (so the ownership has been changed to me from a previous owner). However, when that has been done and I attempt to edit the dataflow, I am taken to a page that reads "Unable to load Dataflow." Is there any way to get around this problem? It is preventing me…