ST_Superman Domo Employee

Does the Data on the card update when you reload the page?

@MichelleH Mind sharing a screenshot of your settings and the graph?

Sorry, there was an extra comma: CASE WHEN MONTH(`Created Date`) IN ('2','3','4') then FLOOR(DATEDIFF(`Created Date`, STR_TO_DATE(CONCAT('2-1-',YEAR(`Created Date`)),'%m-%d-%Y'))/7)+1 WHEN MONTH(`Created Date`) IN ('5','6','7') then FLOOR(DATEDIFF(`Created Date`,STR_TO_DATE(CONCAT('5-1-',YEAR(`Created…

Have you looked into the Workbench tool? https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5

I guess I shouldn't try to post SQL code from my iPad. It seems that iPad's like to change single quotes to other characters. Try this as the week of quarter: CASE WHEN MONTH(`Created Date`) IN ('2','3','4') then FLOOR(DATEDIFF(`Created Date`, STR_TO_DATE(CONCAT('2-1-',YEAR(`Created Date`)),'%m-%d-%Y'))/7) WHEN…

Just be careful, when you calculate this within the dataflow, it will no longer respond to any filters you are applying to the card. For example, if you calculate the corelation of two events occuring in the same calendar year in a dataflow. Then the corelation number will not recalculate if you change your card to look at…

The only issue I see here is that you won’t always have a full week at the start or end of a quarter. For example, if quarter 2 starts on May 1... that is a Wednesday. So your formula will only include the first four days as part of that week. It is actually going to count that Sunday, Monday and Tuesday (April 28,29,30)…

Try this for the week: CASE WHEN MONTH(`Created Date`) IN ('2','3','4') then FLOOR(DATEDIFF(`Created Date`, STR_TO_DATE(CONCAT(‘2-1-‘,YEAR(`Created Date`)),’%m-%d-%Y’))/7) WHEN MONTH(`Created Date`) IN ('5','6','7') then FLOOR(DATEDIFF(`Created Date`,STR_TO_DATE(CONCAT(‘5-1-‘,YEAR(`Created Date`)),’%m-%d-%Y’))/7) WHEN…

You would still need to calculate the `Week of Quarter` field though...

I think something like this should work: CASE WHEN MONTH(`Created Date`) IN ('2','3','4') then concat('FY',RIGHT(YEAR(`Created Date`),2),' Q','1') WHEN MONTH(`Created Date`) IN ('5','6','7') then concat('FY',RIGHT(YEAR(`Created Date`),2),' Q','2') WHEN MONTH(`Created Date`) IN ('8','9','10') then…

Could you attach some screenshots of what you currently have and where you are trying to get to?

Give this a shot: case when (COUNT(case when `Abandon_Time`>15 then `contact_id` end) / COUNT(`contact_id`))<.05 then 'Good' when (COUNT(case when `Abandon_Time`>15 then `contact_id` end) / COUNT(`contact_id`))<.07 and `campaign_name`='Customer1' then 'Good' else 'Bad' end I used this for the "Abandon Rate" (COUNT(case…

While looking at this case statement, I do have a few questions. Are you wanting to use the same denominator for each campaign? It looks like you are counting the number of times there was an abandon time greater then 15 for campaign "VALUE1" and dividing it by the total count of contact_id's in your dataset. In other…

You should be able to get this to work simply by removing the dataset id from your link. Instead of something like this: CONCAT('<a href=''https://superman.domo.com/page/1823207411?pfilters=[' ,'{"column":"Territory ID", -- This is the part you want to remove. the datasourceid portion --…

I can't think of a way, or fully understand the use case, for getting the legend of this chart to display the county names. In your example, there are at least two counties with a value of 2 and several with one. Are you saying you want to see the legend simply list every county? Depending on your use case, I would…

You should create a beastmode to use as the value. Create a new calculated field and enter this: COUNT(DISTINCT `Account Name`) For your summary number. If you are wanting a count of distinct account name and stage combinations, you would want to create another calculated field (also known as a beastmode) COUNT(DISTINCT…

All in a day’s work

I would make a few changes to your beastmodes. Previous whole week: SUM(CASE WHEN YEARWEEK(`Date`,0) = YEARWEEK(DATE_SUB(CURDATE(), INTERVAL 1 WEEK),0) THEN ('Rev') ELSE 0 END) By using date_sub you will prevent errors when you are on week 1 of a year. Previous whole week from last year: SUM(CASE WHEN YEARWEEK(`Date`,0) =…

You could try LEFT(your_beast_mode, 10)

Go to learndomo.domo.com and log in. There will be a menu icon in the top left (3 horizontal lines). Click that and you should see my courses and learning plans

If you go to "My Courses and Learning Plans" and then click on the exam that you completed you will get to this screen: Than you can click on the "Knowledge Test" to see a screen like this: I would recommend searching for the training course that matches any category you missed questions in. Hope that helps. Good luck with…

@remember_Sagan I am more comfortable using MySQL, so I agree with your statement that I think this is easier using a MySQL dataflow SELECT CASE WHEN `Sales Rep`='Dan' AND `Order Type`='1' THEN 'Exclude' ELSE 'Include' END AS `Conditional Column` However, if the dataflow is already built in ETL, then I would recommend just…

I would start by pivoting your metadata schema Rank the field Names for each Object UID: select `Object UID` ,`Field Name` ,`Field Value` ,@rank := CASE WHEN @UID = `Object UID` AND @rankval = `Field Name` then @rank WHEN @UID = `Object UID` AND (@rankval := `Field Name`) IS NOT NULL then @rank+1 WHEN (@UID := `Object…

If you uploaded the file with file uploader, then you need to use file uploader to "update" it. Try creating a new data set with the excel plug in. Then, you can use the plug in to pull down the data set, make your changes, and then push it back to the same dataset. The issue is that for some reason Domo will not let you…

change the field to display as a percent with 2 decimals

change it to: `Total Revenue` - ABS(`Total Cost`)

You need to make sure that none of the other fields are aggregate functions as well. I'm guessing that =Profit is an aggregate field. Try taking it off or removing the aggregate from the beastmode formula

is `Total Revenue` ever null? try IFNULL(`Total Revenue`,0) / (SUM(IFNULL(`Total Revenue`,0)) OVER())

@meadow_ryan - I'm trying to understand your use case. You want to calculate a running total so that you can take the max() of that field to get a grand total? Unless there is more to this, why not just sum the column? If the intention is to understand what percentage of total revenue is coming from each company, you can…

The data set does not need to be the same, but the field name and values you are wanting to filter on need to be the exact same for each data set on the page. For example, if you created your icons using a field `Product Group` to identify different areas on an .svg file and the values were 'Produce','Clothing','Shoes',…