ST_Superman Domo Employee

I would approach this with a different chart type and beastmodes. You can create beastmodes for 2017 Actual Profit and 2018 Actual Profit: `2017 Actual Profit` ifnull(SUM(CASE WHEN YEAR(`date field`) = 2017 THEN `actual profit field` END),0) `2018 Actual Profit` ifnull(SUM(CASE WHEN YEAR(`date field`) = 2018 THEN `actual…

I was referring to the Dashboard layout beta:

I would pursue gaining access to the Domo Dashboard beta. While it wouldn't be in a single card, the dashboard layouts would let you line up the cards in a way that I think would meet your needs.

I agree. I'm not crazy about how it looks, but if you had enough reps and months to look at, it might highlight some outliers. Alternatively, you could adjust some of the properties to give a more uniform look:

The only option that comes to mind would be a heat map:

Hi @operatives - The first question that I would have is related to your data. You mentioned that the drill path should apply two filters "Sales Rep=___" and "Date=___" but your table does not display a "Date" field. You would first need to have a data structure that was flat. Something like DATESALES REPSALES1/1/2018Tom…

It is in Beta right now. Perhaps you could get more information from the Beta section of the dojo that @DaniBoy is working on adding. In the meantime, I would contact your Customer Success contact from Domo.

This sounds like a good feature request, but I do not believe this is doable currently. If the user is in Domo, you can share the data set with them and they can download from the data center as needed. Otherwise, you will need to download to excel first and then email to the user.

There may be a more sophisticated way of writing this, but here is the beastmode I used: case when (sum(Case when `Within Hours`<=1 then 1 else 0 end) / count(`Date`)) >=.99 then '1 Hour' when (sum(Case when `Within Hours`<=2 then 1 else 0 end) / count(`Date`)) >=.99 then '2 Hours' when (sum(Case when `Within Hours`<=3…

Based on the pivot chart you provided. It looks like they are interested in understanding how many hours it took for 99% of the jobs to be completed. Here is my final go at earning a solution here:

Sure. You may want to think about adding a few more columns to provide some additional information. I think it would be most useful to understand what question they are wanting to answer with this table. I added a few more columns that may provide some of the granularity they are looking for. As you mentioned, maybe the…

wow, so you need to show all months to 100%? Would it be worthwhile to have a final column that shows what the max hours to complete was? Something like this: Or does the granularity need to be there, all the way to 266?

Does the Pivot table need to be set up that way? Or can we swap the columns and rows? I was able to get this with a few beastmodes: Month Name is just MONTHNAME(`Date`) and then % Within X is just sum(Case when `Within Hours`<=X then 1 else 0 end) / count(`Date`) you can change the X to 1,2,3,4,...n

can you share some sample data and an example of what you want calculated? It sounds to me like the beast mode that you provided should work for the individual rows and the total row. Basically, for a beastmode that is an aggregate function, the total row will apply the same aggregate function to all of the rows of data.…

Why not remove the current Margin field and just use the beast mode?

I see why. Your Date field is Text format, not a date. Can you convert it to a Date earlier in the data flow? then this should work.

Actually, you can probably drop the "WITH ROLLUP" text as well

Maybe I posted an old version of the code. Try copying this in again? CREATE PROCEDURE pivot() BEGIN set @sql_dynamic = ( SELECT group_concat( DISTINCT concat( 'max(case when month(Date)=' ,month(`Date`) ,' and year(Date)=' ,year(`Date`) ,' then EBProjectHealth end) as `' ,monthname(`Date`) ,' ' ,year(`Date`) ,'`' ) ) as…

That's odd. It works for me. Does it error out when you run the Create procedure transform too?

Did I get the field names correct? I used "ProjectName", "Date", and "EBProjectHealth"

Try creating these two transorms in your data flow: number 1: CREATE PROCEDURE pivot() BEGIN set @sql_dynamic = ( SELECT group_concat( DISTINCT concat( 'max(case when month(Date)=' ,month(`Date`) ,' and year(Date)=' ,year(`Date`) ,' then EBProjectHealth end) as `' ,monthname(`Date`) ,' ' ,year(`Date`) ,'`' ) ) as `test`…

This probably has to do with the structure of your data set. Keep in mind that beastmodes are only able to look at a single "row" of your data at a time. Would you mind sharing a few sample rows of your data so that we can help troubleshoot?

I am also not able to see the data science actions mentioned in the release notes

I am unaware of a way to embed the video itself in a card or dashboard. But I would recommend exploring using a table card with HTML coding in it. Here is an example of how to create a link in a table card, I would assume that you could use a similar process to embed the video itself using HTML, although I am not an HTML…

I was looking forward to exploring this feature as well. However, I have had difficulty finding it. Anyone else able to view this? Do we know if this is actually available now?

Given that Data Fusions are not actually creating a new data set, I'm not sure how they would approach trying to apply PDP. Is there a reason that you don't want to join the data via an ETL or SQL dataflow? I think that is your only option if you need PDP applied to the end result

You could do this in a MySQL data flow: SELECT `Question` ,Group_Concat(`Answer` SEPARATOR ' | ') as `Answer` ,`ID` from table GROUP BY `Question`,`ID` This should give you an output like this for each user: Q1 -- A1 -- ID1 Q2 -- A2 | A2a | A2b -- ID1 ...

I'll take a stab at this one... Try creating new beast modes to calculate staffing level and number of employees Staffing Level: sum(staffing_level) / count(distinct ifnull(EmpID,1)) Number of Employees: count(distinct ifnull(EmpID,0)) Then use these fields in your table instead of the current fields you are using. You…

I'm not quite sure what the use case is here. If I'm understanding you correctly, I would recommend creating a page that you share with a user. Then, any card that you create on that page will be shared with them. They will not get an alert or email, but when they click on the page, they will see the cards