ST_Superman Domo Employee

We use an SSO and the plug in is working for us. You may want to run this through Domo Support or your customer success manager. It sounds like it may be a bug? What is the specific issue you are having?

Not all chart types support HTML code You should be able to just remove the HTML code: CONCAT ('Total Daily Unique Visitors:', round(((sum((CASE WHEN `scenario` = 'AC_TY' THEN `daily_unique_visitors_scenario` ELSE 0 END ))) / 1000000),1),'M')

Would creating a new field for name work for you? I basically created the following beastmode: concat(`Owner`,' | ',case when `PE`='' then 'None' when `PE` is null then 'None' else `PE` end) This let me generate a chart like this:

It may help to understand the relationship between the Owner and the PE. It looks like the same owner can have multiple PE's and one PE can have multiple Owners. Does the PE Sat score reflect on both the PE and the owner? If not, I would recommend structuring your data a little differently: Basically, you want to have a…

I don't think that you would need to create a procedure for what you are trying to do. Have you tried just using the transform: SELECT * FROM `newexceltest` That should work. Is there something more to this query that would require using a dynamic select statement?

I think that you would need to make these changes in SQL or an ETL. Basically, you would need to add a field to your data set for `Previous Month Date` this would just be SELECT *, DATESUB(`Date_Field`, INTERVAL 1 MONTH) as `Previous Month Date` FROM data_table You would the new table with the original table SELECT a.*,…

SELECT fy.`Created Date` ,wr.`Fiscal Week` FROM `FY18 MQLs` fy LEFT JOIN `Fiscal Week Ranges` wr WHERE fy.`Created Date`>=wr.`Start Date` AND fy.`Created Date`<=wr.`End Date`

Basically, if you are wanting to group by customer, then you can list all Customer relevant fields (the fields that will always have the same value for the same customer) in step 1 of the group by tile. All Order information will need to be aggregated and listed in section 2 of the group by tile.

If you group by Order ID then you will get a separate row for each order ID. You want to group by Customer. You can't have Order ID in your output if you are wanting to combine data from multiple orders.

Yes, just don't inlcude order date in the list of fields. Otherwise you will want to add order date to the second section and create a "group by" field that would show you the Max of the order date as the most recent order.

Any column that you list in step 1 will cause a new row of data in your output for every unique combination. For example, if you have several different product families that you sell to customers, you can use something like this to get total sales grouped by account and product family: Or, if you remove "Product Family"…

Just add the extra columns in step 1 of the group by tile. Keep in mind that if any of the columns you add to that step contain different values, you should move it down to the second step and create an aggregate calculation 

This should be doable. Would you mind sharing what your ETL looks like, and where you are running into issues?

You could also display the POP veriance using the Period over Period Variance bar line card: This way you wouldn't need any beast modes. This card was made from the table you posted

I'm not sure if it will work for your larger data set, but I was able to use this formula to get to your desired results with your sample data: (sum(`Qty`) / sum(`Traffic (Sum)`)) * COUNT(DISTINCT `Date`)

Are you completely sold on the scatterplot? The box and whisker will label it for you

Nice. You beat me to linking my own post ?

I would recommend a combination of a box and whisker plot and a drill path to provide granularity. You could also just use the card in the drill path if you want all of the data on the first view, I liked seeing the spread with the box and whisker though. Box and Whisker Drill Path All Sizes at once

This is definitely something that can be handled in a MySQL dataflow. Select *, floor(datediff(curdate(),`Date_of_Birth`)/365) as `Age` from data_table then you can use the `Age` field to create your `Age Bucket` Field: select *, case when `Age`<18 then 'Minor' when `Age`<30 then 'Young Adult' when `Age`<50 then 'Middle…

I think you will want to restructure your data set a bit. If you can get a "flat" file with your categories and subcategories defined and labeled. You should be able to create the visualizations you are looking for, or use a Sumo card to create a pivot table with the information.

contact support@domo.com They have access to more details on the error messages.

You could create a beastmode that would bucket these products into larger groups. You could always then allow the user to drill down to a view that provides the actual product name. something like case when `Product_Name` like '%PageWide%' then 'PageWide' when `Product_Name` like 'LaserJet%' then 'LaserJet' when…

What happens if you filter the card for a single yearMonth? Does the white space go away?

would you mind sharing a screen shot of your analyzer? It looks like you have either a user or location id as your y axis, the % of print jobs as your value and then the name of the printer as a series. In this case, for location 201805, it is saving a spot for every printer name that exists whether that user or location…

That does look odd. Do you have a lot of series with null values? My guess is that you do, and so the chart is saving space for those series. I would try filtering out those null values and see if that fixes your issue.

Step 1: Sort By the field of your choice Step 2: Open the "Data Table" tool in the analyzer Step 3: Limit the number of rows as desired

@user06681 You are correct, when you mention someone with the @ mention tag, Buzz automatically makes the conversation private. However, if you just toggle that option off, then all users with access to the card should be able to see the message:

Does it have to be a separate card? You should be able to use the `Goal Complete` field as a summary number. If it needs to be a second card, then just make sure you save your beastmodes to the data set and you shouldn't have any problems. If you have any issues, would you mind sharing the formula for `Goal Complete` thanks

Is `Transactions` another beast mode calculation?