Godiepi Coach

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…

現在、一般的なチャートプロパティでは、すべての線の太さを調整できます。 1つだけではできません。色分けを追加して、線の1つをより多く表示することをお勧めします。たとえば、1行は赤で、もう1行はライトグレーです。

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…

When editing the dashboard , bring from the right options a Text card and select hiperlink (It show in the properties bar where you select font size color etc. its in the far right of the properties bar) then you can select to link to something already in Domo or outside of Domo. 

Hi @user057102 building the card , in edit mode you should be able to select from the "Chart Types" > Vertical Bars , the one named "Running Total Bar". as well as setting the last 12 months by month in the date grain options

Here it is Datediff( Date(`yourdatefmield`) , Current_Date()) or Datediff( Current_Date() , Date(`yourdatefmield`)) note: you might or might not have to specify Date for your date/time field thats why I usually prefer to do this: Date(`yourdatefield`). , but that is just me

add the "X-axis" column as a quick filter but on edit mode leave only 1 selected but on the quick filter area to the right of the chart not on the filter area (left upper corner) Update: here an example image

Hi @Techy007 Use a date column for your x-axis and set the card to dysplay by month... on the Y-axis use the value you want to display as a line which would be in your case the number of orders the second value to add is your forecast value and the third one your actual value , add these 2 to the series section then in the…

@hamza_123 in theory you can do it but it will involved some data manipulation. run a flow that aggregates revenue by product and call the column holding the product "X-axis" then run another table aggregation of revenue by Sales Person and call the column holding the Sales person "X-Axis" append the 2 aggregations and…

Hi @Randyb Sounds like you are an expert on how to use the assembler. I am tagging my co-worker Shannon @smaiolo who would be very interested getting in contact with you about this feature. Thank you

If you want to completely hide the values from Worse then you can add the label as a filter and excluded completely from the chart. if you want to have the ability to show the value but by default to turn it off , then in edit mode in the card preview, click once on the worse label series , it will gray it out. hit save…

Yes, @WizardOz go to the wrench drop down menu for each card and select edit drill path , then in the next window look at the bottom right corner and check the box "Prevent drilling to final data grid view" you'll need to do this for every card you want to prevent drilling to data view individually

Hi @Koen it seems that one or more values for the customer column is very long. go to properties in edit mode and general, check the box allow text to wrap

try this CASE WHEN ifnull(`opportunity date`,0) = 0 THEN 'Is null' ELSE 'Is not null' END also are you using the same date as your X axis ? that might cause trouble since is null .... not in the case of table cards

Unfortunately filter cards with search option aren't available right now in Domo. you can add this request as an idea in the Dojo. A work around I can think of involves the creation of 3 filters to get to a customer in a dashboard. not the most elegant solution but it might work to some extend. First filter carad:…