ggenovese Coach

If you don't need to loop through dynamic parameters then this should work, note that I have unchecked encoding on the values

I think what @ArborRose mentioned, and what I had missed, is that you're using the Dynamic URL option which adds the slash. Try using the Dynamic Parameter option instead.

Can you try making your parameter name "ApplyCreditDebit" and your value "True&$filter=FiscalMonth eq 12" and see if that works? Also, you may need to turn off encoded for your values. If you click the blue Encoding link and uncheck values that will prevent the connector from trying to encode your manual input

I realize you may only posting a subset of your data, but given what you've shared it seems as if you may want to union (in magic ETL it's called append) Table A and Table B. this would give you all the check in dates and property id's without duplicating bookings and capacity.

if you select the "Download from link to page" option, and then choose file type "Email Body as one row" it will create a column for the email subject line and a column for date/time received.

there is actually a TIME_TO_SEC() function that will convert to seconds, in order for it to be a decimal you have to determine if you want your value to be a fraction of a minute, an hour, or a day

If you use a Rank & Window tile in your ETL you can apply the DENSE RANK function to rank on MoveDate descending and partition by the Unit Id. This should give you a Rank of 1 for the most recent date and then you can add a filter to filter for Rank = 1

In that case you could use a Rank & Window tile in Magic ETL, using a Lag or Lead you can offset the prior month value onto the current months row so that you can calculate the variance

Trying to apply a number format in a beast mode can be limiting, especially if you want to comma separate the thousands. It might be beneficial to restructure your data in an ETL so that Revenue and Sales are in their own columns.

I prefer the way your data is currently structured, and I don't think it's necessary to pivot it in an ETL. The fastest way you can get a month over month variance, with your existing structure, would be to use a period over period card.

You might want to try selecting the "Offset by pages" option and then "No" in the pagination configuration, where it asks if the data contains the total number of pages, that has worked for me in the past. This works if you get a NULL response when you get to the last page, the connector will stop trying to keep fetching…

This is interesting, I did a test using the Domo Dimensions Calendar dataset using this variance beast mode: ( -- current value count(`d`) - -- previous value LAG( count(`d`)) over( Partition by `dayName` ORDER BY MONTH(`dt`)) ) / -- previous value LAG( count(`d`)) over( Partition by `dayName` ORDER BY MONTH(`dt`)) And I…

You could use an HTML table and then create a beast mode that pulls in an image of a checkmark CASE WHEN `myBool` then CONCAT('<div style="text-align:center"><img height="20px"…

Hi - your original beast mode was missing the second aggregation, you needed SUM(SUM(… CASE WHEN SUM(SUM(CASE WHEN `Ready Status` = 'No' AND `Previous Ready Status` = 'Yes' AND `Previous Ready Status` IS NOT NULL THEN 1 ELSE 0 END)) OVER (PARTITION BY `Case Number` ORDER BY `Case Number`) = 1 THEN '1 Time' WHEN…

Using the example data you provided I am getting a deduped SUM of 1,600 using the beast mode I provided earlier, if I add a total row it also evaluates to 1,600. Not sure why it isn't working for you. Going back to my earlier question, I'm curious what your DAX calculation would evaluate to if you were to add a Product D…

The DISTINCT expression in your DAX code is going to return a deduped list of qty values correct? Let's say for example, two items A & B both have a qty of 5, wouldn't the DAX code give you a total of 5 rather than 10? I don't know DAX so I want to make sure I'm interpreting that correctly.

Hi - when an item code is repeated, is the qty always the same corresponding value?

I feel that there is still a use case for recursive dataflows when your data does not have a unique identifier. In order to perform and UPSERT operation you need to have a unique key, but a recursive doesn't have this limitation.

Assuming your data looks kind of like this, where the same product qty is repeated within a year then this beast mode will dedupe and sum by product and year: SUM(MAX(`qty`) FIXED (by `product`,`year`))

There are a number of ways to handle this, but the easiest might be to simply use MAX or AVG rather than SUM

You can do this in a beast mode by starting with the number of days in the month then subtract the number of sundays and half of the saturdays and mondays: -- calculate the number of business days in month given a date (`dt`) in that month -- start with # of days in month day(LAST_DAY(`dt`)) -- subtract half of the…

Highlighting doesn't work on all card types unfortunately. You can see in my screenshot below when I hover over "Friday" in my upper left table card, it highlights the Friday bar on the bar chart but not on the other table card. Another approach would be to use a variable, where the variable selection would highlight a row…

In regard to the dataLastUpdated, I'm seeing the same thing on my side. A workaround might be to add last_updated to the filter of your search. "filters": [ { "filterType": "facetValue", "field": "tag", "value": "Your_Tag_Goes_Here" # Replace with your tag as needed }, { "field": "last_updated", "filterType": "numeric",…

This is great! Thanks for sharing your code! One small enhancement you can make is to use an Account to store your developer token so that it's not in plain text in your workbook https://domo-support.domo.com/s/article/36004740075?language=en_US#use_accounts

You can send a POST to this endpoint as referenced in the discussion you linked: https://{{your_instance}}.domo.com/api/data/ui/v3/datasources/search with this post body: {"entities": ["DATASET"], "filters": [{"filterType": "facetValue", "field": "tag", "value": "<YOUR TAG GOES HERE>*"}], "combineResults": "true", "query":…

If your WoW beast mode is: (mktg visits - lw sessions) / lw sessions then change it to: (SUM (mktg visits) - SUM(lw sessions)) / SUM(lw sessions)

Looking at this other thread, it seems the solution was sharing the card with the users receiving the scheduled report, can you give that a try and see if that works for you? https://community-forums.domo.com/main/discussion/66431/scheduled-reports-permissions-pdp

The developer portal has some sample code you can refer to. In my experience, the metadata.account.accesstoken value from the authentication section is not accessible in the process data section when you're developing, but the value is accessible once it's published so I just hard-code an access token until it's time to…

I'm seeing this in the FAQ for the File Upload Connector, is it possible you're hitting save before the preview appears? Why am I getting updates with the previously uploaded file? When you update the existing dataset by uploading a file, a preview screen appears in the Select tables pane after the file is uploaded. When…

I love this idea!