MichelleH Coach

You could try setting up your comparison using the YEARWEEK function instead of WEEK and YEAR separately. So your beast mode would look like this: Sum(CASE WHEN YEARWEEK(DATE_SUB(Current_Date(), INTERVAL 2 WEEK)) = YEARWEEK(`Visit Start Date`) THEN 1 Else 0 End)

Agreed! This would also be really helpful for logins to White Label instances and improve the customer experience.

Your best bet is going to be to reformat your data to have a separate row for each week the resource works, like below. That way you can simply sum the "Planned Units" column and use the "Week Start" column to group by week. Resource NameWeek StartPlanned UnitsxyxJanuary 17, 202132xyxJanuary 24, 202140

Hi @user19682, This behavior is to be expected when using aggregate functions in beast modes. It's not a bug since it's actually beneficial for certain calculations, such as percentages or ratios, where adding up the individual values is not necessarily meaningful. With that in mind, I would suggest using a dataflow to…

Hi @jbandley, You should be able to access this through the Activity Log data, but you will need to look at multiple rows to see the all the information. When a user shares a card, there are two separate actions logged: The first user shares the card, then the card grants access to the second user. It sounds like you were…

I don't believe there is currently a way to accomplish this with a single card based on the chart types available. If the categories in your data doesn't change much, I would recommend creating a separate card filtered to each name and then arranging them side by side on a dashboard.

Rather than trying to set up automatic forward from your own email, you should be able to add the email address for the virtual inbox to the scheduled report distribution list.

If the existing cards are currently stacked vertically, you could try inserting a one-card layout in between the cards you instead of a card. That way it would split your existing cards into two separate layouts rather than trying to squeeze another card into the same amount of space.

Last I checked, the filter interaction is not supported for Beast Modes even if it's saved to the dataset. I would suggest hard-coding the degree field into both of your datasets via an ETL. As for the "Rename Beast Modes" error, I've been noticing that show up erroneously on cards recently so I would not worry too much…

Alternatively, there is a transpose option in the general settings of table cards. Then you can store each stat separately as a number with their own formatting.

I see, I misread your question. Out of curiosity, what is the reason behind having different data formats in the same column? I don't know of a way to do this offhand, but there may be another way to present it.

You can set the number format for a whole column by clicking the pencil on the field name, then clicking "Data Format". Then you will see a drop-down where you can select the format you want. Also, if your data is showing up with different formats in the same column, be sure that the column is stored as a number rather…

You should be able to apply the same logic as your grouping beast mode, just returning the net amount instead of the label, and then summing it all: sum(case when `Group 2 Name` = 'Sales' or `Group 2 Name` = 'Sales Returns' then `Amount` when `Group 2 Name` = 'Direct Costs' or `Group 2 Name` = 'Protein Powder' then…

If you're using a MagicETL, have you tried using the Set Column Type tile to change it from text to a date?

The simplest way to do this would be to add a numeric filter to the page because of the way most data is bucketed. Since data from the past 7 days is also from the past 30 days, we aren't able to cleanly bucket the data the way a radio button requires without duplicating rows. To make the filter work, you will have to use…

The STR_TO_DATE() function should work if you match the format of your date column using the Date Format Specifiers: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/03Date_Format_Specifier_Characters_in_Beast_Mode Based on the example you gave, this code should convert…

It looks like the issue is because you are trying to account for the week in your Beast Mode, when the rows in your table are already separated by week. You can actually use a much simpler calculation that only compares the year over year because each row of your table is already only includes data from the same week of…

I don't think the Activity Log shows who reports get sent to, but if you are an admin you can also view more detail in the Scheduled Reports page, and clicking the three dots on the right side, the, "Edit Schedule". You can also filter this page to show all reports "Owned" by that particular user. 

If you have the Activity Log dataset, you can see when a scheduled report is created by reporting on rows where the Action field is "CREATED" and the Object_Type field is "REPORT_SCHEDULE". The Object_Name field will tell you which report was created, and the Name field will tell you who scheduled it.

MagicETL has a "Split Columns" tile in the Edit Columns section made specifically for this purpose. You can specify a delimiter, in your case "-", and it will create separate columns for text that occurs before and after the delimiter. You can also make as many splits you want, as long as the delimiter is the same.

Rather than thinking of this as a pivot, you could also use the standard Table card and transpose it (under Chart Properties > General > Transpose). If you list the columns in this order, you should end up with a similar result: * Date * AVG of Revenue * AVG of Spend * AVG of Profit * AVG of ROI

You could use a CONCAT function in a Textbox card to display the date in whatever format you'd like. For example, this code will give you the output below: CONCAT('Yesterday: <br>',DATE_FORMAT(DATE_SUB(CURDATE(),interval 1 day),'%m / %d / %Y'))

I see, you're looking for a month over month comparison with a target? You can try a Comparative Fill Gauge (Basic) chart like this: This chart type doesn't seem to like aggregate Beast Mode calculations when I tried it, so it may require an ETL to summarize the data into a single line.

Is your scheduled report a single card or multiple? The closest feature I can think of for this would be utilizing alerts (e.g. the max date has increased). Unfortunately, this is not ideal because it would really only be applicable to a single card and the user would have to click a link in the email to see the actual…

I have not run into this, however a Social user doesn't count against your licenses used. Out of curiosity, where do you see deleted users listed as social? 

I've had success with the Filled Gauge chart type since there is a Target Value field you can use. * To show last month's sales, use the date options in the card to select "Previous Month" as the timeframe (note that this will only work if you have a Date/Time field in your dataset). Then put your sales field in the "Gauge…

Notifications like Buzz have to be configured by the user themselves, but you should have access to manage card alerts by going to the "Alerts" tab, selecting "All Alerts", and creating a "Subscribed to by" filter for that user. This will show all card alerts that the user receives. From there, you can open each each alert…

Have you been able to use the "Stop Import" option in the dataset settings?

Hello, You should be able to accomplish this with a CASE statement in a Beast Mode. Try this as a starting point: case when count(case when month(`Submitted`) = month(CURDATE()) and year(`Submitted`) = year(CURDATE()) then `Order $` end) > 0 and -- Orders in the current month count(case when month(`Submitted`) <…

I've encountered the same thing, although I'm curious about your use case for needing the export the links. The HTML hyperlink embed is best suited for if the users need to navigate to a site directly out of Domo. If the export functionality is neccesary, I would suggest removing the HTML and only showing the URL. So your…