MarkSnodgrass Coach

To get the time between the first entry of one column and the last entry of another for a particular column, you are going to need to use the ETL. You can accomplish by doing a Group By and group by the ID and use the MIN function on the HRC Create Date and the MAX function on the Status Change Time. This would give you…

The TIMEDIFF() function will get you the hh:mm:ss value between the two if you are just looking to get the difference between the Status Change Time and the NRC Create Date in a single row. Yours would look like this: TIMEDIFF(`Status Change Time`,`HRC Create Date`) Here's a link to the documentation:…

@hamza_123 You have to contact support or your customer success manager as this feature is only enabled on demand, per the knowledgebase. Here's a link to the article and further explanation about managing the roles. https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/Managing_Custom_Roles

You can actually do this really easily with the Split Columns tile in the Magic ETL. In the Split Columns options: 1. Choose your column 2. Select Custom and add the | 3. You can leave the checkbox unchecked since you don't care about the rest of the data. 4. Give your new column a name Hope this helps.

Are the values that are in "Value Owned" and "Managed Values" text or numeric?

I see a couple options for your depending on what you are wanting to do. I assume you are using a table card to display your results. Option 1 - If you are wanting to literally highlight the field, use color rules You could create a color rule for the Managed Values column and set the condition where "in" is blank and then…

You can do this with the Split Columns function in the ETL. Assuming your structure has 2 folders and then the filename, it would look like this: This would result in the following based on your data:

@Jeffsnake Have you looked at the Domo Governance Dataset in the connectors section of the app store? It contains multiple datasets about cards and pages that should get you what you are looking for.

Kiruba, You just need to contact your account manager and ask them to add the pivot table - beta chart type to your instance. They should be able to do it quite easily and you will have access to it. Hope this helps.

Looking at the options for a YoY by month alert, have you tried the following: Metric - Most Recent Month Meets this condition - Decreases by % For this value - 1% That seems like it would do it. Hope this helps.

I find that getting something like a country total works best in the ETL. You can get the country totals by adding a group by and then joining back to your main dataset. It would look like this in the ETL. If you didn't want to do that, have you considered using a Nested Bar card? It does a nice job of showing the…

To my knowledge, there is nothing like that in place. In the dataflow settings, you have 3 options: Manual, on a schedule, or trigger if a dataset is updated. You could build something pretty elaborate in the dataflow that would generate a row count and then if it is above the number you want then it could continue. I…

You need to replace the blanks with a zero prior to using the calculator. To do this, insert the value mapper tile and do the following in the steps of the value mapper: 1. Select your column that has the blank values 2. Choose Overwrite values in searched columns 3. Keep the original value 4. Click the wheel cog and…

I recently did a bullet chart as @Aditya_Jain suggested and created green, yellow and red bard based off of percentages by creating beast modes and color rules. The end result looks likes this: I created a beast mode for Green that just has a value I want for green and then put that value in the Range 1 value. I did the…

@hamza_123 Have you installed the DomoStats - Datasets and Dataflows app from the app store? It might have what you are looking for. It will create a page with a number of cards with analytics about your datasets and dataflows. I think you might have tweak one of the cards that it creates to get what you want, but it…

@AvinashK You should ask your account manager to enable the Shapes card in your instance. It is currently in Beta, but they can add it to your instance and I think it will accomplish what you are looking for. Here is a link to the documentation where you can see all the different shapes you can use.…

I tested with what I think is similar data and was able to get it to do what I think you want it to do. Try setting a color rule for Most Recent RP to be a certain color and then set another color rule for Self-Awareness to be yellow as well as setting a color rule for Self-Efficacy to be yellow. Then do the same for…

If you are not able to use the append method that is available in the Settings section as previously mentioned, you can build a recursive dataflow that would let you append new records to a dataset without duplicating your data. This KB article does a good job explaining it.…

Yes. The Dashboard and Story Dashboard are the same. I believe Domo initially called the new layout Dashboard, and then moved to calling them Stories, and now they have somewhat settled on Story Dashboard. Whenever you see any of those three names, they are talking about the same thing. Hope this helps.

I'm not sure if this will solve your issue, but here is an idea to consider: Instead of using Sumo cards, use the Pivot Table card. It is currently in Beta, but you can request it from your account manager. It is more powerful than a Sumo card and may allow you to put the numbers in a format that you are wanting. Here is…

You can do this by adding an additional column in the ETL that you can use to Exclude the open accounts and still keep your main dataset intact to do other analysis. You would build an ETL like this: (I'll break down the steps after the screenshot) SampleStatus - this is your initial dataset Days to Close - This is a…

@Ritwik It should be in the top right portion of the page. However, I believe that if your story is too long, the Export to PDF option becomes unavailable. The PowerPoint option looks quite similar to the PDF, but I at least have the option in PowerPoint to remove the filter language that I don't want to show up. I would…

Have you looked into the Domo Governance Datasets in the App Store? This might give you what you need. Search for "Governance" or "Domostats" in the app store and you should see it under connectors. One of the datasets you can pull is the Dataset Schemas dataset. This should give you what you need. Below is a list of what…

Domo has a connector called Domo Dimensions that is a data table of all calendar dates that is useful for this type of work. If you search for calendar in the connectors section of the App Store, it should show up. If it doesn't ask your CSM to enable it. This can save you some work when needing to build a table full of…

I'm assuming you are wanting to do this for a summary number since you can use the formatting options on a field when you drag into use if it is a numeric field. There a number of methods you can use to do this. If you search for custom summary number in the Dojo, you will see some other examples. Here is what I created…

Are you looking for information like this? https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Aggregate_vs._Non-Aggregate

Ok. This should work for you. I've added some additional columns just for learning purposes so you can see how it is put together. The column that I named NewDate is really the only column that you would need in your output. I've added some comments to explain what each part is doing. SELECT "datelen", --Gets the year…

I would say that means it is falling into the first part of the case statement and it thinks the values are less than 19000101. Can you add another screenshot that shows the datelen column without any logic applied to it?

Redshift and MySQL have different preferences on their use of single quotes and double quotes. Try this: SELECT "campaign", "date", "revenue", CASE WHEN "datelen" < 19000101 THEN NULL ELSE date(to_char(TRIM("datelen"), '99999999')) END AS DateEXTRACTDTE FROM "df_ga_int_emarsys_campaign_attribution_sql_prep"

It looks like I was using the Redshift SQL for this conversion. Do you have the option to use that? If not, we should be able to track down the equivalent functions in MySQL.