david_cunningham Coach

You could use the group by tile in MagicETL to create a new column for the most recent completed month (or last 30 days, or whatever period you want to use). Basically you would use the rank/window function to identify the top 5, then calculate their total in the period as a column, calculate the total for the entire…

Good idea @ColemenWilson ! I would also like this for quarter-end for our financials. The ability to set up expiring / recurring schedules would be great. Right now I can set up only a single update schedule, but can't say on the last 3 days of a given month, I want this dataset to update hourly instead of daily. All other…

This might just be a screen resolution/sizing issue, as I haven't had this happen. One thing you can try, is to change the background color of the filter to the same color as the background image of the dashboard. Doing this will expand the space that the card can render in, and might fix your issue.

@LearningNinja in the example I provided for a different question yesterday, I showed you how you could have year display without comma, but still be used to get the previous year value. You'll need a combination of restructuring your data in an ETL, and a beast mode to generate your year filter. See my answer on the most…

it’s because your columns aren’t wrapped in backticks. You’ll need to add those in. The code blocks in the forum for some reason tend to remove the backticks. Wrap your column names in `

@jvsering - please send me a screenshot of your exact beast mode.

you’re missing a closing parenthesis around your sum. You need the sum because you are aggregating your other field. Try SUM(CASE WHEN Product != 'SEM' THEN (IFNULL(Impressions, 0) / 1000) * IFNULL(Monday.CPM, 0) ELSE (IFNULL(Cost, 0) + IFNULL(Cost * SEM Fee, 0)) END)

@Lu_zhang - because you have columns defined, the sort order within each column grouping is going to be the same. There is a potential way to get to the end result you want. You would need to restructure your data to create the groups you want. For example, you would need to have it in the following format. Note, you could…

@LearningNinja if you use Domo's built in date range/grain page filtering, this is handled for you. However, you can't specify the exact year. When you use a filter card, the rows are filtered down, so you would need your comparison values in a column to be able to reference them. For example, here is a card which is…

@luoqianhe - are you still running into issues here? If you are, please post some more details, the type of card you are using, the type of card you are drilling to, how your data is structured, along with example screenshots. I'm happy to try to look into this for you.

@DanieleSilva You would use the Formula Tile in MagicETL and then use the code provided above. You can name this column whatever you want.

@LearningNinja Why do you want to avoid using the built-in date-range/grain filters provided by Domo? Based on your question here, I would suggest that you take the following approach. Set your default card display date range to current year in Analyzer (this will make the card default to show the current year as you…

Congrats @Sean_Tully ! Love seeing your insightful and helpful comments 😁

For differences in time this is my preferred approach (UNIX_TIMESTAMP(new_timestamp) - UNIX_TIMESTAMP(old_timestamp)) You can then divide the result to get to the grain (day,hour,min,seconds) you want to.

If this is on a dashboard, you can change the size by going to "Edit Dashboard" and then dragging to resize the container the card is in.

Out of the box, Domo has color rules for single columns. If you're wanting to compare 2 columns and trigger a color rule, you'll want to set up a beast mode, and then key your color rule off of that. Something like CASE WHEN "Total Leave % Current Month" > 0.2 AND "Total Leave % Current Month-1" > 0.2 then "Last 2 Month >…

@Lu_zhang - Domo has a line + 100% stacked bar card type. You can then specify the number of series that you want shown on the left scale to get your 2 lines + 2 bars.

@mcih = @MichelleH - there's some weird bug going on where it isn't letting me edit my previous comment, so wanted to clarify what was meant. Also, in terms of series, I mistyped and now can't edit my previous column. What I meant to say is it's probably easiest if each of these columns is it's own series. So the 2 lines…

@Lu_zhang - you're looking at period over period cards. You'll want to use the line + stacked bar option, which will have the ability to set the number of series you want on the left scale. You can find this by going to "Vertical Bar" and then looking for Line + Stacked Bar. Keep in mind that for this to work, you'll need…

@Gojo I'm not sure exactly what your question is. What do you mean by "so that the data is handled as intended"? Is there a particular problem that you're currently facing with this approach?

@ColinHaze - I'm not super familiar with Domo Bricks, but I did notice something in your query. You are using backticks to encapsulate your SUM DISTINCT, but using apostrophes for the other fields. I would've expected the aggregation to be done in the query portion, but again, not super familiar with Bricks so take what I…

@RiaEunice here is a good reference document. I agree with @ArborRose Hopefully this is just a temporary issue, but if not, you'll need to reach out to your data storage provider where you are trying to pull data from.

@afrailer Domo has a feature called Trellis Categories. You can use this to specify various levels of grouping. Although the groups won't be in the exact way you laid out. Domo does have an out of the box grouped + stacked card option, but I believe that it is limited to 2 bars, and you can specify how many groups you want…

@hfruecht The function you're looking for is DATE_SUB. You can use this, but you'll want to think through your filter. For example, do you have daily data, do you want to compare to the last day of of the month for the given quarter? If your data is updated monthly, then what is the date of that import - maybe it's better…

@ArborRose how about something like this. you can see we have a max date per group. Set the default to the max date when count > 1, else use the group max date None selected, defaults to overall max date 1 selected - shows date for group case when COUNT(DISTINCT group) > 1 then MAX(date) else MAX(date) over (partition by…

@Ant T I don't know if this will work. But one thing to try - instead of creating a new card, create a copy of your old cards where min/max/avg was removed and then modify to fit your current data/need. I don't know if this will actually retain the old settings, but it's worth giving a try.

This is not in magicETL, but the way your example data is set up you could sum in the card using SUM and DISTINCT with a fixed function directly on your card. SUM(DISTINCT daily_average) FIXED (BY ID, date) By the way, this might just be because you're showing example data. But are you trying to get the daily average or…

Here is where you can find groups.

I'm venturing a guess here with very little context. But, to me it sounds like that there is a new team within a department, and they are looking to represent that in Domo. My guess is that the best way to achieve this would be via a group. You can use that group to control access to content in Domo.

@GarethR - there are 2 possible options. Domo has something called a flex table (see below). You could also use a faceted bar chart if your output doesn't have to be a line.