ST_Superman Domo Employee

There are two modes of scrolling on a Domo dashboard. If the height of the card on your dashboard is taller than your monitor space, you can scroll up and down on the dashboard without scrolling on the table itself. It's difficult to explain, By default a pivot table should freeze the header row for you when scrolling in…

I played around a bit with combining a multi-value gauge card with a flex table card: I feel like that provides a pretty clean look.

@MattLynn I think that you will be best served by splitting this table into multiple tables. One for case load by source, one for Resolution method, and one for Customer Experience. I'm not sure how your data is structured, but I took a stab at the first table (case load by source). The part that I stumbled on here was…

Using a table card per @GrantSmith you can do something like this: In this case, I added a Pareto to the drill path, but there is one extra step required in order to view all of the categories. You need to first drill into a single reason, And then click on the "x" to remove the filter: Conversely, you could just have the…

Hi @svetlana You could always use a Pie or Donut Chart. Just in the General Chart Properties enter 3 as the maximum slices: You can even get more details on the "Other" category by just moving your mouse over that pie piece:

Hi @RajNadar It would help to understand what format `Booking Year Nbr` is in. CASE WHEN `Booking Year Nbr` = YEAR(CURDATE()) THEN 'CY' WHEN `Booking Year Nbr` = YEAR(CURDATE())-1 THEN 'PY' ELSE 'Other' END

@dgsinclair - For pivot tables, you can only sort on any fields that you have in the table itself. If you sort on anything else, then you will only see the first value in the table (although the totals will still be accurate). I believe this is intentional. You may want to highlight the largest deal won in a month, but…

@Jones01 I'm not sure what chart type you are using, but I believe I was able to do this with three beastmodes. One to get the name of the day and another to capture the hour from your datetime field. HOUR: HOUR(`DateField`) Week Day: DAYNAME(`DateField`) Avg Total Count: AVG(SUM(`Count`)) FIXED (BY day(`DateField`)) You…

I'm not sure I follow you. A pivot chart value is, essentially the aggregation of a value grouped by the fields in the row/column. What would you expect the value to display if it is not an aggregation? a list of all values?

@RanjitR - you could always try the new FIXED function in beastmodes now. AVG(SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`)) FIXED (BY `YEAR_PERIOD_WEEK`)

@ozarkram - I think that @GrantSmith 's approach is a better option here. He has included safeguards for any null values. If you choose @MichelleH's solution you will get a null value if any of the three fields are null.

@Jmoreno - I would also want you to know, before you update the descriptions for 800+ fields... Those descriptions will not persist through a dataflow. Meaning that if you use that dataset in an ETL or MySQL dataflow, you will need to add the descriptions all over again. We only add descriptions for certain key fields or…

What does it mean to "Help one person get certified"? Is this like a referral program? Or is Domo going to pair up a sensei with someone who is looking for support getting certified?

Once you have your sales grouped by Employee and Date, you could also use a rank and window function. You would want to rank the Sales $s in descending order and partition the data by Employee. Then, in your visualization, if you only wanted to show the best day for each employee, you would filter the data to only include…

@Kunal You could try using a Dynamic Unpivot Tile, then a filter tile to remove any rows with a null value and then pivot the remaining data again. You could also look into creating a dataset view of the data. When you are looking at the "Overview" for a dataset, you will see a section called "Data Profiler". This section…

Hi @emilybaeli - It sounded like you were wanting to filter your cards to be able to remove those rows with a null value in your date field. I would consider creating a new field (either in the dataflow or via a beastmode). nullDateFilter: CASE WHEN `dt` IS NULL THEN 'Missing Date' ELSE 'Contains Date' END This would allow…

@adamxor - Do you have a dataset that contains a list of days and whether they are a "business day"? If you are only wanting to exclude weekends, then you could write a statement that changes the number of days to add based on the day of the week of CreationDate.

@ozarkram - I was able to get the Comment and BAM columns to work, but the Sold_or_Stock_Date column is proving to be quite difficult in beastmode. Can you use ETL to manipulate the data? Comment case when `orderstatus` LIKE '%*SLD%' then 'Sold' when `orderstatus` LIKE '%SLD%' then 'Sold' when `orderstatus` LIKE '%SOLD%'…

I agree with both @Ashleigh and @GrantSmith . I prefer to change column names within the ETL. As a best practice, I will also then make a note on the output dataset to state the source and original name of that field by utilizing the Tags and Description fields when viewing the dataset

I agree with @MichelleH . If you have a single shipment going to multiple customers and need to be able to show the value of that shipment at a customer level, then you will be double counting if you use the same data to view the data at a shipment level. Is there a reason that this needs to be on a single dataset?

At first glance, that seems like it should work. What is the data type for ORDER_MODIFIED_TIME ? I think you need to use the back tick ` instead of a double quote " as well.

@ozarkram - Could you provide a sample of data? It would be helpful to understand the structure better and to troubleshoot with schema that matches your dataset.

Hi @DataLawton - @MarkSnodgrass is spot on. It really depends on what chart type you are using. If you need more help, please let us know what chart you want to display the info in and we may be able to provide some detailed screenshots.

Are the beastmode calculations that you are looking for saved to the dataset, or just the card? If they are saved to the dataset, then you should see them in the dataset view as well. You may have to select the "+ Add Column" button first

@EWold - You don't need to include UE_OrgUnitID in the second part of the ETL tile. You only want to aggregate the three time values that you listed earlier. QA_TimeStarted -> Maximum QA_TimeCompleted -> Maximum CA_DateAccess -> Maximum This will take your data and provide you with a single row of data for each unique…

Have you tried a Heatmap table card? You can use the chart properties to select the color theme as well as which columns in the table should have the colors. You also get the option to use the same scale for all columns, or a different scale for each column.

If you want to display values in a notebook card using summary numbers, then they need to be values and not text fields. I noticed all of your players could be identified by a number so I took a stab at this one. I had to use an ETL to help with this prior to creating the card. I used magic etl to alter your table to be…

is the relationship a 1:1 relationship? how many rows of data do you expect to match? If it's a 1 to many relationship, you could be exponentially growing your output dataset which would cause all subsequent steps in the process to take longer as well

When you select "Top level page" the search bar next to "Make subpage" will be grayed out. You then just have to select the permissions for the page and you will be able to select "Move Pages".

If you only have 2 or 3 metrics to display, you can use the "Dynamic Textbox" card to display something like this: Here are the chart properties that I used, if you had a third value to add, you could use the Penultimate Category and value macros to include those. If you have more than 3 categories, I'm not aware of a way…