Godiepi Coach

Try your case statement this way CASE WHEN `mOrganizer` = 'Hub Music Factory S.r.l.' THEN CASE WHEN `nmPerformance` = 'The Offspring' THEN -2294.62 WHEN `nmPerformance` = 'Social Distortion' THEN -964.54 WHEN `nmPerformance` = 'RECONSTRUCTION TOUR 2025' THEN -1192.98 WHEN `nmPerformance` LIKE'%BAY%' AND `dStart` LIKE…

Try this DATE_ADD( YourDateField , INTERVAL YourIntegerField HOUR)

@pauljames have you tried using a formula for your filter ? something like this : (CASE WHEN IFNULL(`YourField`,0) = 0 THEN 0 WHEN TRIM(`YourField`) = '' THEN 0 ELSE 1 END) = 1 It should exclude everything that is NULL or Blank

Hello @ColinHaze Looks like this is not yet an option available but something that is in future plans. Check out question 2 in this post below about App Studio

@Cfunk Did you adjust the beastmode proposed ? or are you still using the exact code… Im asking because I see your Product Name value = 'Washington Summit - Guest/Spouse Registration' instead of just 'Guest/Spouse Registration' you will need to either match the exact wording or adjust the product name within the beastmode…

Hello @Cfunk Your beastmode is probably easier than you think. Im not sure how is your data structure but if it was like the "Data Sample" in the below screenshot , you could do the formula as follows: IFNULL(COUNT(CASE WHEN Product Name = 'Guest/Spouse Registration' THEN Registration ID END),0) + IFNULL(COUNT(DISTINCT…

Hello @MargieDomo Try this one : (UNIX_TIMESTAMP(`TimeStamp_1`)-UNIX_TIMESTAMP(`TimeStamp_2`))/3600

@TC1199A you will have to combine the data either by APPEND or JOIN depending of your needs.

@TC1199A To have 2 independent groupings (Group By) , you will definitely need 2 separate grouping tiles The reason why Minimum and Maximum is not showing up in the aggregation type is due to the field type you are using. Min and Max option only show when aggregating not TEXT fields… if you use an INTEGER , TIMESTAMP,…

Hello @domoexpert Try this STR_TO_DATE(CONCAT(`YearColumn`,'-',`MonthColumn`,'-01'),'%Y,%m,%d') (Didn't see Grant's post before answering here :) )

I see, In my opinion you should do it in a Magic ETL Select columns for a list of all Datasets , UserID and Content Group by Datasets, UserID and Aggregate COUNT(Content) AS Total_Content_Created Add a Formula tile to flag the UserID on a particular Dataset where they have more than 100 Total_Content_Created to equal 1…

Hola @andresperezfc , espero que esto te ayude… Looking at the description of what you want to accomplish, it sounds to me like you need just a table that lists the users per dataset that have created more than 100 contents. You can create a table card as this: Column 1 = Dataset Name or Dataset ID Column 2 = UserID Column…

Hi @tlammie1806 To add to Mark's answer. Consider splitting the measures into more than one chart (when looking at multiple things at once in a single chart , the message/story you want to tell might get confused) You can potentially split these metrics into 2 cards containing similar metrics or whatever you thing would go…

Hello @user029082 Base on the information you provided I have the following suggestion. It definetly sounds like you have some ardous manual work to do ahead :) I hope this points give you a light on how to make your reports a little easier to manage. Lets focus first on identifying what is contained in each template (I…

Hi @mhouk I built a Magic ETL that will get you pretty close to what you are looking for 1st on your data add a column and name it "ROW" that states the row number in your data. 2nd open a magic etl and copy/paste the code attached 3rd connect your input and name your output 4th run it and review the results your output…

Hi @newbee have you tried selecting hide legend within the chart properties in the analyzer of the card?

@Katie_Forrest_2022 checking your code , would it be that you forgot to say... and `HOLD_NAME` NOT LIKE '%Discrepancy%' instead of and `HOLD_NAME` like '%Discrepancy%' 

Hi @luizalauretti you can easily created a beastmode case statement as CASE WHEN `PPG` = 'MPA 90GRS' THEN 90 WHEN `PPG` = 'CTA 90GRS' THEN 90 END Adding as many conditions as you want individually or this is another option CASE WHEN `PPG` IN ('MPA 90GRS', 'CTA 90GRS') THEN 90 WHEN `PPG` = 'CLUMINOUS 70GRS' THEN 70 END…

@andres Can you create a table card with 3 columns ? User, MIN(Date), Max(Date) then filter to the user or users that get the error to actually see what the MIN and MAX columns display? is because nulls , is it a generic date associated that is messing up ? etc ..

@bradw I understand the process to make it work is a little difficult. let me layout for you by step You are working with [Order Created Date] for your filter and [Sales Amount] for you single value card Create 2 Beastmodes around [Order Created Date]as follows : Beastmode 1 = [Order Created Date1] formula = DATE(`Order…

Look for the [Activity Log] dataset, I think it is in the DomoStats instead of the Governance Datasets (dont remember) .... once you find it, look for report and issue or something like that in the [Action] field

@bradw you have to adjust the interaction on each selector independently to enable interaction filters to ONLY apply to selected cards. clicking on CHANGE will open the list of all the cards in your dashboard, from there you can select the specific card. You want selector1 to only interact with Card1 .... and Selector2 to…

@bradw You can created 2 Filter cards, locate them on top of each of the cards in your dashboard, then adjust the interaction settings so that [Date selector 1] only filters the card [Date 1 sales] and [Date selector 2] only filters the card [Date 2 sales] within your dashboard... that's the only way you can do that

Hi @Vova Try this, you might need to adjust the time depending of your time zone FROM_UNIXTIME(1656076776827/1000,'%d %M %Y %H:%i:%s')

You will need to set up a Magic ETL like this : 1) load your data into a Magic ETL 2) Split your Note column into multiple notes, In my example I use only 3 using the following configuration use a costum delimiter [\r\n] use regex 3) now you can unpivot to generate rows for each row by ItemID 4) the last step is just to…

Hi @Fadem You need to change the order if using "greater than or equal to" 6 like this SUM(case when DATEDIFF(CURRENT_DATE(),`Effective Time`) >=6 then 1 else 0 end)

That's interesting , are you trying to pull from a saved search ? have you check this ? Is it mandatory to select a Search Type for the Saved Search report? Search Type is only necessary if the Saved Search is a standalone search type, otherwise it is optional. A standalone search type is a search type that does not have a…

What happens when the datasets runs again ?

Yes no problem , no need to say WHEN again ... This way should clear out the error CASE WHEN LEFT(`ORDERSTATUS`,1) ='*' OR `ORDERSTATUS` like '%BAM%' THEN DATE_FORMAT(RIGHT(TRIM(`ORDERSTATUS`),10),'%m/%d/%Y') ELSE DATE_FORMAT(`orddate`,'%m/%d/%Y') end

@ozarkram check for the * character in the string if present then get the last 10 characters from the strings (if always is the date at the end) convert it to a date format month , day and year if the character * is not present then use the other column This beastmode should do the job -- name your beastmode…