Godiepi Coach

Comments

  • Hello @domoexpert Try this STR_TO_DATE(CONCAT(`YearColumn`,'-',`MonthColumn`,'-01'),'%Y,%m,%d') (Didn't see Grant's post before answering here :) )
    in Date Transform Comment by Godiepi June 9
  • 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…
  • Hi @ozarkram if always the date you need is present at the end of the string and the identifier is * then first check for that asterisk character present, then get the last 10 of the string converting it to date format mm/dd/yyyy else use the column orddate this beastmode should do the job -- Name your beastmode…
  • @thwartted Ok, that's doable. You will need to do the following Make sure you have a field that only have the Time Minutes for the day. I see you have Date/Time Extract the Time from it in this format hh:mm (do not include the seconds) You will have 1,440 points for each 24hrs This formula should do the job…
  • @LCash Oh, I see what you are saying so , with your dataset being formated as the first table in your post, you will need to 1) bring forecast column into the Y-axis (sum Aggregation) 2) for the 'Series' part you will have to add beastmodes for each Product doing the sum of metric like this below Prodcut X: sum(case when…
  • @thwartted , what are you expecting to see as far as visualization? Are you trying to plot in a chart the average of calls per minute by call type for 30days ? that would be a long x axis with 43,200 minutes (there is 43,200 minutes in 30days) or you just want the single value (average calls per minute) by call type ? in…
  • Hi @Arjuman , Try this below, you might need to add a condition to adjust when dividing by 0 SUM(CASE WHEN YEAR(`ResolvedDate`) = YEAR(CURRENT_DATE ()) THEN `DaysToResolution` ELSE 0 END) / COUNT(DISTINCT CASE WHEN YEAR(`ResolvedDate`) = YEAR(CURRENT_DATE ()) AND `isBugResolved` = 1 THEN `JiraKey` ELSE 0 END)
  • Hi @LCash , It shouldn't be difficult to do what you are trying to do. Make sure to select the correct Chart Type and also you might need to create a beastmode to use as a sorting option to make the 'Forecast' series be the first one so that it plots as a line and the rest of series get stacked in a bar.
  • Update: I figured it out.. looks like in magic , the function needs to be added within the Group by tile add formula providing at least 2 fields containing the samples to analyze
  • @GrantSmith / @jaeW_at_Onyx Have you ever used any of these functions in Magic ?
  • @levand , What @GrantSmith is referring to is the [Activity Log] report from Domo Stats. It contains all activity in the Domo instance. Look into it for the field [Action] = 'VIEWED' and [Object Type] = 'PAGE' then the [Object_ID] and [Object_Name] will tell you what Dashboard was VIEWED by 'X' User ... [Event_Time] will…