ggenovese Coach

@DavidSawyers - the connectors are working for me now, according to support a patch was applied.

I have two Jira Issue Query connectors that started failing with the same error code on 8/25, I submitted a ticket with Domo but it hasn't been resolved yet. I'd suggest you submit a ticket as well.

oh, that's really strange. Out of curiosity if create a new card does it have the same problem?

Is the "Date" field set as the Date Range Field for the card? Usually when I see weird date behavior this is the cause. One field is driving the card and another is being displayed.

That's right, you mentioned that it was a top 20 report at the top. I believe that you can still get it to work with the following changes: Include the Style in your fixed functions: SUM(SUM(Sales) FIXED (BY Style)) Sort on Date Descending, then Sales FIXED Limit rows to 20

Hi @Mickey - If you come at this from the completely opposite direction you can get to a solution that works. Here are the steps: Create FIXED functions for Sales and Units Sold. Example: SUM(SUM(`Sales`) FIXED ()) Place "Date", "Sales FIXED", "Units Sold FIXED", and "Quantity On Hand" in your table card. You should have…

There's no way to reorder the columns in the UI as far as I know. This would be a great feature request though, either by allowing columns to be reordered like how the Add Formula tile works or by providing a method to convert an "Add Column" to be turned into an "Add Formula"

I'd recommend using a python tile, so that you don't have to assume or maintain a specific number of splits # Import the domomagic package into the script from domomagic import * # read data from inputs into a data frame df = read_dataframe('<INPUT TILE NAME>') #change <INPUT TILE NAME> # write your script here # Split the…

Hi @sangelov - when you say all words in a row, do you mean across multiple fields or a single field? The words in the field(s) are comma separated, is that correct? If the result should be only one column with a single word, what is being appended?

I'd recommend that you break up some of the work into separate transforms. For example your B sub query could be a separate transform that's joined in to the main transform. You can also pre-filter A in it's own transform and then do your joins. After you have parts segmented out into separate transforms you can review the…

The connector requires a unique id in order to retrieve more than 2,000 rows. You'd need to add a unique id to your report or you'd have to construct a SOQL query that replicates the report

Hi @deona720 In order to solve this I'd recommend creating the following beast modes: Member Count COUNT(DISTINCT `Member ID`) People That Attended IFNULL(COUNT(DISTINCT CASE WHEN `Member Is Registered for Event` = 1 THEN `Member ID` END ),0) People Who Have Never Attended an Event — This beast mode subtracts People That…

I see, your data is structured with semi-additive measures, rather than additive measures. If the data was structured with additive measures then you could use the "% of Column" option, instead you have to create a beast mode because SUM(Actual Custom) is greater than 14,312,756, is that correct? If so, I think a FIXED…

To get a % of Total you can select Show Value As, and then click % of Column Total

Hi afieweger I don't believe what you're looking to do can be achieved with a beast mode, you would have better success doing this in an ETL. The issue is that your distinct count will count all bm views when you remove the email column and that is why you're ending up with only the 250+ row. Even a FIXED function would…

Hi @Analyst_Mike You may want to try this update, if it doesn't work it might be helpful to share a screenshot of your pivot table so that we can see how it's configured: CASE WHEN MOS_Year = 2023 AND Metric = 'Member Month' THEN SUM(MM) WHEN MOS_Year = 2023 AND Metric = 'MLR' THEN SUM(COST_MLR) / SUM(REV_MLR) WHEN…

One option is to create a beast mode with a case statement that applies a dynamic format based on the variable. There is a MySQL Function called FORMAT() that you can use in a beast mode even though it's not a documented beast mode function and it will give you a validation error. Something like this: CASE WHEN `My…

Hi @Juan_Coronel_221b Can you try giving the beat mode a different name, one that starts with a letter instead of a symbol? Also can you add a total row, does it give 0% as the total too?

Hi @Scrapper140 If I'm understanding correctly, this may help get you started. Assuming your data is structured like my example below, and if you wanted to calculate the average for metric when the customer is not the selected customer and the date is not the selected date then you would build a case statement. Example:…

Hi @jslatham, I think the trellis options in analyzer would give you something similar to what you're looking for but it's not available on a bullet chart unfortunately. The only alternative I can think of would be to use a line-bar card and show symbols only for your line. Then use the trellis options to repeat it for…

According to the domo knowledge base only materialized datasets can be virtualized. A dataset view is not a materialized dataset.

Hi @Mickey It looks as if you're trying to create a "size" field in a beast mode because your dataset doesn't have a size column, instead it has a column for every size. Is that correct? If so, this problem is better solved in an ETL than with a beast mode.

Hi @Juan_Coronel_221b Can you share a screenshot of the card configuration as well?

Hi @SimonKing_Atolls You'll need two loops, one for each user and one for each pc: jsonData = {"user1":["PC1"],"user2":["PC4","PC5"],"user3":["PC1","PC2"]} datagrid.addColumn('User',datagrid.DATA_TYPE_STRING) datagrid.addColumn('PC',datagrid.DATA_TYPE_STRING) for (var user in jsonData) { if (jsonData.hasOwnProperty(user))…

Hi @zaclingen_fwm, You can do this with a window function: SUM(SUM(`Monthly $`)) OVER (PARTITION BY `year` ORDER BY `month number` )

That's interesting, can you share some screenshots so that I can see how it's configured?

Hi @jrtomici Can you confirm whether you are witnessing this behavior when you save and run the Magic ETL, or just when you preview? If it's only when you are previewing then I would suspect that you're not seeing any values in your new sum column because you're working with a large dataset and the max you can preview is…

Hi @giannzi - DATEDIFF() returns the number of days between two dates. Example: MIN(DATEDIFF(`Due Date`, CURRENT_DATE())) If today is 03/13/2025 and the due date is 04/04/2025 it will return 21 You can then use your ranges to provide the color rules. For example, the face card only allows 3 ranges and you don't have to…

You can use DATEDIFF to count the number of days and then use the range options in the card configuration something like this: MIN(CASE WHEN `Report Status` = 'unfinished' THEN DATEDIFF(CURDATE(),`Due Date`) END)

Hi @Makam - I reviewed the documentation for that API and I see that the "List Ledger Entries" and "List Ledger Entry Lines of a Ledger Entry" endpoints use a page based pagination method rather than next token. As a workaround could you try first getting all Ledger Entries, and then with a second JSON connector loop…