Godiepi 🟣

About

Username
Godiepi
Joined
Visits
244
Last Active
Roles
Member, Beta Premier, Beta Program
Points
1,024
Badges
24

Comments

  • @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…
  • Thanks Mark, I saw the article but I am looking more for an example
  • Good morning @NathanDorsch This is the equivalent of going into every card details present in your dashboard and adjusting the date range that is next to the title one at the time. the "Choose Date" in the top right corner does it for you all at once. as long as the card is using a valid Date field , it does not matter if…
  • the easiest way according to your screenshot is .... for question 1 : you can move the series to the sorting options and sort desc , that way BGT will show up first then , B and A for question 2: go to properties, general and type 2 in the "series on left scale" , this will make BGT and B be lines and A a bar.
  • Love it; It is a great way to learn new things as well as refresh your knowledge by helping others solve questions. Its awesome to see how other users come with completely different ways to get something done in Domo, that makes it fun and unique. I can't wait to have the opportunity to go to another Domopalooza in Salt…
  • @jaeW_at_Onyx almost got it Jae, They are talking about categorizing records into 2 types 1: Lic which I believe stands for "Licenciatura" in spanish and translates to Bachelor's degree 2: Maestria in spanish equals to Master's degree in english @user028384, me imagino que debe existir una columna en tu base de datos que…
  • This is the map I created for the front section of our Newspaper with zoom in and drill down capabilities. The idea of the newspaper dashboard by the way came from imaging the first thing a lot of people do in the morning (not nowdays but back in the day) was to get a cup of hot Colombian coffee and sit down to read the…
  • Hi @HashBrowns you can do it by going into MORE>ADMIN>GROUPS then locate the group and open it up as you were going to edit it. on the top left corner , hover over the circle profile picture and click on EDIT... A window pops up with the options to assign a new picture for your group. (See screenshot)
  • Hi @MichelleH you could try the following. I think it might help improved the efficiency of your flow Follow the instructions in the screenshot attached to * Remove the Group By and add a "Rank & Window" * instructions for the Rank window set up are in the screenshot * Click on Addf Function * Name the new column…