marcel_luthi Coach

Thanks @MichelleH, will this work even if I need the data shown to be responsive to card/dashboard filters? My data is not pivoted by name in the dataset, I do have Name as a column, but not really familiar with the Unpivot Tile functionality TBH, so I could be overlooking something there. Also, to make it easier, they…

Based on your description, it'd seem that instead of a LEFT JOIN, you should have used a simple APPEND ROWS in your ETL, this would allow you to have a single entry for everything, as long as your drill down only leverage the fields both tables have in common (date, team, shift), and from there you could see which stations…

@Chris_Wolman without knowing what your data really looks like is hard for me to picture a full path to follow. In general if what you want is to be able to know what was the inventory at any given point in time (captured using a Variable as @MichelleH suggested), is to have your Raw data being the movements to inventory…

What do you mean by them remaining the same? From your sample data, the planned hours on 7/10/2023 for Team A are: 40, but for 7/10/2023 are only 8, and if you look at team B you have 7/10 = 17 vs 7/11 = 42.5 if you then drill down to an specific Station, each have a different number, so not sure what you want to have…

So on your data, you have the current number of items in a field OnHand? If this is the case, this would seem an ideal scenario for a flex table instead, have you looked at this option and configured the columns to show First Value, Last Value and the change?

I had a similar request, where the Running total needed to show the all time history and took me a while to find a way that could more or less work for what I wanted, sadly it kind of renders the default date filters useless. Here is how I achieved this. 1) Create a beast mode that will transform all dates prior to where…

Just to be clear each record has a value for A, B and C, which will either be a 1 or 0 since they are basically flags and your card should show a single % based on all the entries that match your filter criteria (including date range). Can you share the examples of the list of values for A, B and C you're using and how…

If you want this to work the way you mentioned, you'll need to replicate all entries for the last 7 days + today on each day you want to graph (that way each entry will have all the columns and be affected by the filters you apply). I was working on a mock on what this would look like, but making the number of days to…

Love @DashboardDude solution, nice and clean! @lbg123 when you say 7 days average, are referring to the last 7 days from today, or the 7 days prior to each entry? This makes a huge difference on how the ETL needs to be built, also whether the average of the prior 7 days is meant to be responsive to the card filters or not.

Just keep in mind that this will show you the running total on the time window you're displaying, not the all time running total, it'll start with the delta between the values of the first week displayed and add or subtract based on the weekly delta from then on. Just making this clear as I'm not sure what from the…

Hi, I haven't tried yet, but this seems to be something you could workaround by creating a beast mode using the fixed function, that will return you the true total by brand, something like: SUM(SUM(`Retail`) FIXED (BY `Brand`)) And then using this beast mode for both the sorting and filter criteria. Might be worth giving…

You can kind of do this with the pfilter parameter added to the URL, but you'll need to code the link yourself and as far as I know this will not work with variables, or at least I couldn't get it to work with them. Not sure if this is what you're looking for.

I might be missing the most basic here, but I've been looking to build cards with multiple categories but have failed to find this option so far, none of the options I have under Vertical Bar Charts allow me to select multiple categories, can you point me as where to find this card and documentation about it?

That is correct. When using Pivot tables in Domo the fields you put in Rows tells the system what should be used to identify a unique entry in the table, and each of these fields will be shown as is own column. In Excel the same thing happens, but rather than showing then as individual columns it uses indentation to show…

@ccc123 without using Domo formulas, sadly I'm having a hard time following the logic since each part of your WHEN statement does not really evaluates to a Boolean value (I know this is not mandatory, but surely helps making it clear for others to understand when you want things to happen or not), could you explain how…

With OOB tables sadly I don't think this is possible, hopefully someone can prove me wrong here, mostly because all table values are defined by the columns you select to show so you cannot display different things on each row. If you have a defined set of Employees you can either try to recreate this with multiple cards,…

You could use either a Window Function (external video) or the Fixed function, but Beast Modes are no good to do aggregation of aggregations. If the aggregation will happen at a single level, then on either the OVER clause of your window function or the FIXED clause of the fixed function, instead of using a specific field,…

@AaronCrouch I had a similar situation and while I couldn't get the card not to show, I was able to get it to display no data when they don't limit to show information for a single customer, not sure if this might be helpful to you, so the cards show no Data until they actually narrow it down: In my case each customer is…

For a filter applied to a dashboard to affect cards from multiple Datasets, you need to be sure that the field you're filtering on exists on each of the datasets with the exact same name. Sometimes you'll need to prepare your data first via ETLs in case you need to join information from multiple datasets to append any…

@MarkSnodgrass awesome approach, definitely cleaner than what I was thinking about. Tested and works perfectly except for when the outcome does not includes a day part. Adding two case statements to it can help solve for those instances. CONCAT( CASE WHEN `dt` < CURRENT_TIMESTAMP() THEN '-' ELSE '' END, CASE WHEN…

The FIXED function can be used to get the MAX score on a product basis: MAX(MAX(Total Skill Score) FIXED(BY Product)) The normalized Score could be calculated as Total Skill Score/MAX(MAX(Total Skill Score) FIXED(BY Product)) I'm concerned you're trying to get data at multiple aggregation levels and if you want to do that…

Love @colemenwilson approach! I might be overthinking it but there is a slight change I would make to Step 4, since currently the formula would return Full Quarter for the following scenarios for example: something that only has entries from 1/1 to 1/31, since it is Q = 1 starting on a 1st and ending on a 31st. something…

Just to be sure, are you trying to add them individually or in bulk? Have you made sure that the .llc domain you want to add has been added to the Invite Authorized domains in the Admin section? I tried individually adding a person afterwards and it worked for me:

Completely agree, being able to set the default value for date variables to relative dates would be a huge improvement, and the amount of other thread asking for similar things (set it to Today(), Yesterday(), etc) shows how many people in the community are looking for this.

For each row in a Pivot table, a value needs to exist, so without joining a new Gross Profit Account, having this to display would be hard to say the least, and even then you'd need to work with the fact that the measure calculation will need to be worked differently on that one than on the others. You might be able to…

Sadly this seems to be one of the functions that is not homologous to its MySQL counterpart, so unless someone has tried it, I don't think we'll have much extra documentation (You can always test and share your findings here, from my initial test any other number results in the same behavior as 11). You could hack your way…

For this you'll need to get the Value of the rate rather than the %, and then calculate the new percentage as the ratio between the two. At the row level you'll need to have a value that is the Worth of the Loan times the Mortgage Rate of it. In your example for Loan A = 10K and for Loan B = 5.5K. Instead of averaging the…

This is based on the MySQL window functions, with the exception that you need double aggregation functions for them to work: partition_clause: A PARTITION BY clause indicates how to divide the query rows into groups. The window function result for a given row is based on the rows of the partition that contains the row.…

Can you share an example of what the desired output would look like? Depending on this there might be different card types that you can use to achieve a this behavior and the building of it might be slightly different. For some cards you might be able to use Segments to have a comparison line, in other cases you might need…

Just in case this might help others facing a similar problem, I was able to work around this by using a variable that determines the earliest date I want to show in the chart (you could do this to be a formula instead should you always want to start N months back), and changing the data we use for the X axis for the…