marcel_luthi Coach

I guess this mostly depends on whether your data is already including only a single entry per month, or if you have multiple entries in each month that need to be totalized monthly and then that be displayed. Another question would be what you expect to see if lets say Jan and Feb have values but March does not (this might…

It all depends on what want to achieve. In general if you just want to display the Date with the Total minutes you can achieve this the way @colemenwilson suggested, selecting only these 2 fields and setting your card to display by Day. This will give you a single entry per day with the Total Downtime for and this will…

@user15252 for that instead of LEFT(julian, 4) you'd to LEFT(julian, 3), under the assumption you will have only single digits centuries, otherwise LEFT(julian, LEN(julian)-3) and then add 1900 to that number, that will become your JYEAR, all other steps remain the same.

Do you want your dropdown card to be filtered by other filters in the dashboard, or is it meant to always show all people, regardless of what other things might be filtered? If the idea is for your Dropdown to always show the full list of people, you can go to the dashboard editing mode, and select the Change filter…

I've used LISTAGG in BeastMode with no issues in the past, even if not really a supported function, the only thing I couldn't select the character to use to join, so is always a comma delimited separated list, I also used DISTINCT in case multiple entries of the same might be retrieved. Here's the example that currently…

Welcome EJ! Hope you'll have a nice experience getting to know Domo, and enjoy being a part of the community.

Agree with what @trafalger suggested, without any other character CONCAT will likely put the two numbers together, so 10 and 20 would be displayed as 1020. Adding the "template" of the string you want to display to the formula should work, something along the lines of: CONCAT('Sites = ',COUNT(Panels),', Panels =…

Congratulations @colemenwilson !!! Well deserved and keep it with the awesome contributions and insights.

Not sure if I'm missing something when reading the question, but if what you want is the filter bar at the top of a dashboard to only show the option for date you can customize this on each dashboard, by going to the Filters option and decide what should be allowed vs not.

I guess the path to follow would depend on what you want to do with the dates. If option 3 works for you, then there is no need to do this in ETL, you can do this in the Views Explorer and Remap Nulls to the bogus date of your choice. Usually when a date is NULL and you operate on it the result of the operation will be…

QQ, did you try the following: const where = ['ELT_Code=COOR','RecordType=FTE','Blue_MA_SSP_Code=TCMV','TimeSeriesShort=CM','FTE_Position_Type!=Actual_Active_Positions', 'FTE_Position_Type!=Actual_Open_Reqs','FTE_Position_Type!=Yet_Another_Exclusion'] Since you want to exclude all of the 3 options then this might work and…

I see in your example that the 3 entries share the same SO#, so would the % you're trying to calculate be at the SO# level? if that is the case if you display your card by SO# instead of WTSTEP a formula like the one below might get you what you need: SUM(`Sales Price`- `Actual Cost`)/SUM(`Sales Price`) If for some reason…

I get that we join the calendar one with each possible granularity we want to be able to break things to, which would be the base table to which we'll then left join all the trailing calculations we've performed in the other transforms (or at least I think that is why there are so many there), but I'm guessing we're also…

Not sure if the version of MySQL currently used supports it, but you could try changing the REGEXP_REPLACE(`name`, '(M\d{5,}|C\d{5,}|\d{5,})', '$1') for REGEXP_SUBSTR(`name`, '(M\d{5,}|C\d{5,}|\d{5,})') (I know not all the MySQL REGEXP functions work, but it might be worth trying)

You'd need to check your group by clause, make sure you're not including the Wipe Date (BOD) nor the Forecast Due Date as the section that Identifies the grouping. Just after the group by the number of entries should go back to the same number as your original dataset.

@WorldWarHulk keep in mind that you're basically doing a cross join for the tables, so for example if in the original table you had an entry with a date of 7/5/2021, this will appear once for each exclusion period you have in your other table, the one you shared a screenshot of, and the filter will only remove the entry…

In the screenshot you shared you're using a filter view that has been set as the default, try turning that to None to see if the data shows. Sometimes saved filter views will have date range attached to them, or might have other filters that end up removing unexpected values. Another thing that could be happening is if you…

Done!

With your description the Regex version would seem to be the best fit. Just keep in mind that you'd need to change this since you just mentioned the campaign code might be anywhere in the text, so something like this might do the trick: ^.*\b(A\d+).*$ in this case you don't care that the code starts. You can see the…

@Dheeraj_1996 then @MichelleH answer is what you're looking for. From the sample data you've provided, assuming you were running it on the 25th line 1 will return 12 and line 3 returns 5, so the difference would be 7. If the idea is not to compare this to the current date, but be able to tell how many new files were…

@Dheeraj_1996 in your dataset what does each row represent? do you have a row per each file received and the local_collect_date_time is the timestamp of when the file was received? If what you want to know is how many more or less files you received yesterday than you did the day before yesterday, @MichelleH approach is a…

It'd seem many of your Count and Average columns are being retrieved from actual values from the Dataset your ETL generates, rather than being an aggregation at the card level: This would explain why you get two entries for the same half hour period for the same account. Ideally any aggregation and calculation that should…

Correct with a LEFT JOIN, not only will you be able to get what you want, but you could also surface a report that show unique entries that have no replacements to the department that manages the mapping file, so they can work on sorting those out and make sure the data is mapped the best way possible. You can build a…

So you're not using the actual date controls from Domo but a filter card instead, that is why the option to hide it won't work. What worries me is that you say that applying those same filters while editing the card does show results, that sounds like a really weird behavior and something for which you might need to reach…

@Aaron_w_SMG when you say you use filters, do you mean you're applying a DateRange at the Dashboard/Card level? If the idea of the card is to show time since the last incident, regardless of when it happened, you'd need to make it so that the card itself ignores the dashboard date filter by selecting the option to hide it…

As @colemenwilson said, most Beast Mode functions will return NULL if any of the parts being evaluated return null, this is why having the ELSE statement to return an empty string instead works. If you're not using case statements but something else as part of the values to concatenate, you should enclose those in IFNULL()…

Glad to see a "new" member join and I hope you'll enjoy the community, don't hesitate to ask and share your expertise with us all.

The backlog should be incremental if you selected the option as @colemenwilson described. However I was unable to get this to work without showing the big chunks at the start (Rolling Totals need to have a start value and add the delta on each period). For this to work you shouldn't change the Date Range of the chart…

This is expected, since to determine the first value you'll need how many Inflows and Outflows had happened until that point in time, if you see my card has two big chunks on the first displayed value while the rest of the entries do show what you would expect. Let me know if this is what you were talking about, if not if…

Thanks @MichelleH, I just submitted this for Ideas Exchange!