ST_Superman Domo Employee

@Valiant - If I'm following the logic for your suggestions, I'm not sure that it's going to provide the results that he is looking for. If you apply a filter for a date range, lets say Q1 2017, then the data set that you are suggesting will return only the number of employees with a hire date or a termination date that…

You could use a beastmode to filter a date range: CASE WHEN `hire_date`<1/1/2018 and `hire_date`>12/31/2016 then 'true' else 'false' end You can then use this as a filter to show the employees that were hired in 2017 by putting this beastmode in a filter and selecting 'true' For the second date range, you can either create…

hmm... I didn't understand the time component of this request. Would you mind sending a sample version of your data set along with how you want the calculation to be done? My guess is that you will need to do some field engineering within a data flow before this calculation can be done. It would be helpful to have a…

case when sum(case when `status`='active' then 1 else 0 end)=0 then 0 else sum(case when `status`='inactive' then 1 else 0 end) / sum(case when `status`='active' then 1 else 0 end) end this should give you the number of "inactive" divided by the number of "active". This is case sensitive so you may need to change it to…

If you are wanting to look at this data rolled up to multiple location tiers (area, region, district, shop, etc.) I would recommend adding two fields at the employee level on your data set. 1. `Terminations` - this would be 1 if the employee was terminated (or left?) and 0 if they were still there 2. `Current Employees` -…

can you share the beastmode here? Have you tried escaping the special character? (i.e. 'America''s Campaign') That is two single quotes in the name

Agreed @DataMaven Good catch. Domo will display the data type next to the card when building a card. A string field will have a "T" and a date field will have a calendar. If you don't want to fix from inside a dataflow, you could use a beastmode to change the data type for this card: You can also use DATE_FORMAT(). Here is…

You could also create a "Running Total Line" graph. Otherwise, my suggestion would be to start with a view of the information by quarter and create a drill path that would then give the details by week. 

Hmm.... It is not behaving the way that I expected it to. However, a Nested Bar is a chart type that you can select from the Vertical Bar charts. Here is a look at what I just made. However, I was hoping that each quarter would only contain data for the weeks that were applicable.

You could also do a nested view. I know my data here is not matching your specific case, but you could have the nested group be the quarters (this way you could see the quarter total) with the inner bars being the total for each week. Then the summary number would be providing the total for the year.

I am still able to set up a page filter across multiple data sets on a page. I would suggest that if these steps are not working for you, that you open a ticket with Domo. The first step is to ensure that the field name and the data type are the same for all of the data sets you are using on the page. After that, open the…

I can't get this done in a single click, but here goes. You will want to go to your data center and select one data set by clicking on the check mark by the data flow icon (1). Then you can click on the "Select All" option that appears in the blue bar at the top of the page (2). Finally, you will want to click on the gear…

Could you provide a sample of your data and what you are wanting as a result? I'm not sure I am fully understanding what your data looks like and what output you are looking for.

if the `OLD/NEW` field is only determined by the `Age in Months` field, then you can do this via a beastmode case statement: CASE WHEN `Age in Months` >= 24 THEN 'OLD' ELSE 'NEW' END name the beastmode whatever you would like the field to be called (i.e.`Old/New GL`) You can enter whatever number you want to define as old…

as @AS mentioned, there are many different ways to do this. Your particular use may make one way better than another. However, in general, Domo accomplishes this by using a "join". The join is a tool that looks at one dataset and matches a column (or field) with a field in another data set. The field that you join on would…

If you are headed to Domopalooza; you may hear some very encouraging news on this front. There are definitely plans for this in the works.

You have to use "CREATE PROCEDURE" in order to do this. Here is an example: CREATE PROCEDURE transpose() BEGIN SELECT product_info into @sql2 FROM for_transpose; SET @str=concat('create table products as ',@sql2); PREPARE q from @str; EXECUTE q; END You then call the function in the next transform: CALL transpose;

I'll give this a shot in ETL, but you may need to use MySQL to make it work. You will also need to change your field names. In the example you gave, you had "Action 2" and "Action 3" both listed twice. You could either have "Action 2" and concat the locations to give you "Miami | New York" or you could have "Action 2" and…

I accomplish something similar to this when I have multiple tables that I need to index: Transform 1 → DROP PROCEDURE IF EXISTS indexing Transform 2 → CREATE PROCEDURE indexing() BEGIN ALTER TABLE table_1 ADD INDEX (`Salesforce Account ID`); ALTER TABLE table_2 ADD INDEX (`Salesforce Account ID`); ALTER TABLE table_3 ADD…

I think that this has to do with you when statement on your "today" part of the beast mode. Try this: CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', ifnull(max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end),0), ' Today') But know that if the period that you select does not include today, then…

What does that data look like under this beastmode? There must be multiple rows of data for each CheckIn. If you use the aggregate SUM() function, it is going to total them all up, not just that one row.

You could try this: ifnull(`Cash`,0) + ifnull(`Credit`,0)

Try using this beastmode as the first column: DATE_FORMAT(`Date of Invoice`,'%Y - %m') This will give you a date format like 2017 - 12 You could also use something like this: DATE_FORMAT(`Date of Invoice`,'%Y - %m %M') This would give you 2017 - 12 December You can't just go with %Y %M because it will sort the months…

If it's going to be accross multiple accounts, I would do a stacked bar instead:

This is how I would reccomend building the card. This allows you to see the total number of opportunities (by engagement stage). You can also use the quick filter to select specific solution plays. I added total opportunity value as the summary number. I think this is a better visualization than a table with 18 columns…

You could start by filtering out the zero values and then sort the data by your timestamp field in descending order. That should give you your most recent data first. If you could provide a bit of your data, I may be able to give a more in depth answer.

Thanks for posting the link to the Idea as well @Valiant Just upvoted ?

Are you clicking on the field setting to format as a percentage? If so, I think you want to change the Chart Properties instead:

Nice job. You beat me to it ?

So, you basically want to calculate the duration column in rows 3, 33, and 66. Is that right? that seems to be the answer to both questions 1 and 2 to me, so I’m not sure what the difference is. Could you elaborate?