GrantSmith Coach

Hi @RobB Are you wanting 30 days prior to the current date or from the date of the row? You might be able to filter your data (using a formula tile and ETL2.0 with a case statement to check if it's less than 30 days ago - alternatively you can calculate 30 days ago from the current date using a date time and then filter…

Glad I could help! If you could make sure to mark it as an accepted answer so others can easily find this I'd appreciate it!

Glad I could help! If you could make sure to mark it as an accepted answer so others can easily find this I'd appreciate it!

No it should work in ETL1 or 2 using the Replace Text tile. You just need to make sure to put the regex in the search and $1 in the replace and make sure you click the gear in the search field and select Use RegEx

Hi @User_32265 You can use a beast mode to compare your date to the latest date and then filter on the result using a window function and a case statement. You can then use this and filter for Latest. If you don’t have window functions talk with your CSM as it’s a simple feature switch CASE WHEN `date` = MAX(MAX(`date`))…

Hi @hanmari This issue doesn’t necessarily relate to the connector but how MySQL handles database reads. Whenever you need to read from the database it will issue a lock to prevent the data from changing until it finishes reading all the data it needs. Are you using a database user which has write access as well? It might…

Hi @Fadem You can do this in a magic etl dataflow with a regular expression and a replace text tile. Regular Expression: ^CN=([^,]*).*$ You can also just copy and paste the following JSON code into your MagicETL dataflow which should handle things for you: {"contentType":"domo/dataflow-actions","data":[{"name":"Replace…

Try this: DATE_ADD(`Timecard_Pay_Date`, interval time_to_sec(`Time_Out`) second) Its converting your time string to the number of seconds and then adding that to your date since dates have an inherent time of midnight

Hi @Salmas Beast modes are evaluated on a row basis and typically don't know of other rows. So in your case it won't ever see a row with rank 1 if it's on the row of rank 2. When you subtract NULL from something the ending result is NULL which is why you have blank output. You'd need to use the LAG (prior) or LEAD (next)…

With Domo when you're using the date selector it determines which month you're currently in and selects days 1-28/29/30/31 (month depending). It sounds like your business definition of a month is different since you're expecting the current month to be August 29th-Oct 2nd. How do you know that August 29th is the first day…

Hi @tejusarora Have you tried it to just return a TRUE / FALSE statement instead of doing your CASE statement? member = 'John Doe' AND `date` >'1/1/2021'

Its likely possible with a beast mode and just filter the card based on when that beast mode is the current month. The question is how do you define the current month?

Hi @Fadem Talk with your CSM, they'd have the best insight into what Domo can offer you and your needs. You could also ask about the Beta program and getting involved with those.

What is the format of your Time_Out field?

The GoogleSheet connector wasn't written to include a batch id or batch last run. You can simulate it using a dataflow to add the current timestamp as a constant and then selecting the max batch ID +1 for your new batch ID and add it to the data you're importing. You'd need to use a recursive dataflow to append the new…

How are you combining your date and time fields? What format is your time field in?

Window functions and pivot tables can be tricky. Glad you got it figured out!

Hi @JunkDoom Your configuration would work to assure you don’t have duplicate records. If you’re wanting to make sure you don’t pull in any record that already exist I recommend looking into the lastvalue replacement variable in workbench query. Workbench will track the last value it sees each run and you can add a…

Hi @etszyingho Your beast mode should automatically take into account your date filtering. Since you're using a pivot table things get a bit funky. How are you partitioning your data within your pivot table (what are you using for the columns)?

Have you tried URL encoding your pfilters since you're using IFrames? You can use a website like https://www.urlencoder.org to easily convert it for you.

Alternatively you could utilize some math functions to simplify your beast mode to calculate just the tenure in weeks - this would allow easier filtering using a single numeric value: FLOOR(DATEDIFF(CURRENT_DATE(), `dt`) / 7)

I don't believe there's a way to have the best of both worlds. It's either wrap text to fit everything or have a scroll bar. That might be a good idea for the idea exchange.

Hi @User_32265 You can freeze a specific number of columns on the left side of the mega table. Under General there's an option for "Number of Locked Columns" to input the number of columns to lock/freeze. When columns are locked, they always appear in the table, even when scrolling to the right.…

The multi-line and single-line uses the same UI. It can be a bit confusing. Good luck with your calculations.

Hi @User_32612 A regression line isn't possible in a multi-line graph as Domo doesn't know which data points to perform the regression analysis on. You can only do it on a single line chart. You may attempt to calculate those metrics manually for each individual series or across your entire dataset but out of the box it's…

As Mark said you’re not able to share filters currently. You could look into deep linking with pfilter parameters and sharing a URL https://domohelp.domo.com/hc/en-us/articles/360042933114-Using-Pfilters-to-Apply-Filters-from-URL-Query-Parameters-to-Embedded-Dashboards

To simplify your approach I'd recommend using a date offset dimension dataset and utilizing that to calculate period over period calculations. I did a whole writeup of it here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest If you would like to continue down your…

PDP is the way to go when limiting access to the different records in your dataset however PDP can’t hide a specific column. I’d recommend a dataset view to not select the columns with PDP to restrict access to solve your issues

Conclusions I hope you enjoyed this walk through and found it useful. Feel free to post any questions or clarifications or even your own tips / tricks!

Caveats Dates are a tricky thing. If you subtract a month from March 31st you'll get February 28th (or 29th depending on the year... again, dates are tricky) so there is a chance that if you're comparing month over month you might count a day multiple times (March 28->February 28, 29->28, 30->28, 31->28) so it may not be…