ggenovese Contributor

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!

If you have more than one year of data you'll need to account for the year, and not only the month. You can use the LAST_DAY() function to normalize your dates: — % Change Costs ( — current month costs SUM(CASE WHEN LAST_DAY(`Your Date Field`) = LAST_DAY(CURRENT_DATE()) THEN `Costs` END) - — prior month costs SUM( CASE…

I see, it's a file that you're importing and the source has a value but somehow during the process of importing the file the value is getting dropped. If the values are being dropped sporadically and you can't determine a reason why then I feel that it's a Domo Support issue.

Is the dataset being displayed the output of a dataflow? Do total billed and total margin come from different datasets? If so it would appear to be a join issue.

I run into this too, but I don’t recall it ever behaving any differently. I used to find myself having to reset everything and rebuilding the group by with the additional category columns. A work-around that I’ve discovered is to use the SQL editor to alter the group by.

If the Quarter ID is "2019 Q4", is there ever any other Prior Quarter value besides "2018 Q4"? If not, then it's logical that the Total Amounts are the same since the same rows are being aggregated.

Yeah, you can do it in Windows Task Scheduler as I described, you just need to use the -script parameter for the CLI tool and provide the path to the script. See below, just replace the placeholder values with your actual values.

Have you tried putting the commands in a script and then calling the CLI tool in the scheduler and passing in the path to the script? EXAMPLE: java -jar C:/Domo/java/domoUtil.jar -script c:\directory\<uploadfile.script> the scripting option is described at the bottom of the KB Article:…

There unfortunately is no way to dynamically set the default for a variable without using code engine. However maybe you could make the default value "MAX" and then update your beast mode? CASE WHEN MAX(CASE WHEN Days Aging>= From AND Days Aging<= CASE WHEN To = "MAX" THEN <Your Dynamic Value> ELSE To END THEN 1 ELSE 0…

The JSON No Code OAuth connector can do this, when you create the connector account you should choose the Client Credentials flow, and Pass Client ID and Secret in Basic Authentication Header options. In the Access Token URL textbox paste in the URL that you use to get the access token.

In order to apply a range filter, you need a number to filter on rather than text. If you were to include the actual age of the invoice in your dataset then you can filter on the range of days. In your example that would be 0 to 180 days. However, a range filter would also include the invoices for Customer B. If you still…

You can do this by combining a Variable with a Fixed Function. First create a variable named "Age Range" and populate it with your Aging Range bins, then create a beast mode: CASE WHEN Customer = MAX(MAX(CASE WHEN Aging Range = Age Range THEN Customer END) FIXED (BY Customer)) THEN 'Include' ELSE 'Exclude' END place the…