ggenovese Coach

Is Academic Plan the identifier for degree being pursued in the Term? If so, if you add it to your fixed function partition you would get a count of terms by student and degree being pursued. After that I believe you can divide by the number of students to get an average of terms per student.

I'd recommend using the global data filter in the Controls section of the App Studio dashboard as well as some filter views for frequently used options.

I don't have a lot of experience with the Smartsheet connector, but according to the FAQ in the knowledge base it says: Can this connector pull custom fields? The connector can pull your Smartsheet spreadsheets as they exist in Smartsheet. Ensure that the spreadsheets are formatted using the best practices for normalized…

If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.

In Magic ETL you can use a Rank and Window Tile with a ROW_NUMBER function, sort on Overall Credits descending and partition by Student ID then add a filter tile for ROW_NUMBER = 1

I did some digging around and apparently Pandas has two Integer Data Types: int64: The standard integer type in pandas for 64-bit signed integers. Nullable Integer Type (Int64): This is a special data type in pandas (note the capital "I") that allows integers to coexist with NaN values. This is useful because the regular…

This is interesting, and I have no idea why it happens, but for whatever reason your Nulls get converted to 0's by the read_dataframe() function only when they are Integers. If you add print(input1.head()) right after line 5 you'll see it in the console. Since the values are 0's then there is no NaN value for fillna to…

Check your schema in your python tile and ensure that 'ACAD_PLAN' is included in the output

According to the FAQ for Fixed functions, they can't be used to filter a card. I recommend going the ETL route that @MichelleH suggested instead

If you add a row number column in your ETL you can use it to place a blank row between two other rows. For example, if I want a blank between Revenue and Wages I could assign a row number between them And then I can hide column 1 in the chart properties: This would create an empty row: You can also play around with column…

It depends on your goal, if you want to preserve the timestamp that was applied in an earlier run then you would place it directly after your non-recursive input dataset. This would apply the timestamp on the new data and preserve the timestamp on the recursive data. But if your goal is to overwrite any prior timestamps…

You can use an Add Constants tile or an Add Formula tile, if you go the Add Formula route the the function you would use is called CURRENT_TIMESTAMP()

Can you bring the fields in separately and then concatenate them in an ETL?

Can you give this a try? SUM( CASE WHEN amCollectorPrice > 1 AND nmOrganizer IN ( 'Live Nation 2 s.r.l.' , 'Live Nation 3 s.r.l.' , 'Live Nation 6 s.r.l.' , 'Live Nation Italia s.r.l' ,'Comcerto Srl' ) THEN qtTicket END )*2.54

The issue you're running into is that month('2024-12-01') is greater than month('2025-01-01') if you break up your case statement that should fix it for you: CASE WHEN YEAR(`SSD`)< YEAR(CURRENT_DATE()) THEN 'Past Due' MONTH(`SSD`)<= MONTH(CURRENT_DATE()) AND YEAR(`SSD`)= YEAR(CURRENT_DATE()) THEN 'Past Due' ELSE 'Future'…

Hello, I'll refer you to the Knowledge Base Article on Summary Numbers which will explain much better than I can. Hope it woks for you!

I don't believe that you can choose an average of a sum in the total row, but you could display the average in the summary number instead.

Just a guess, but could it be that you have duplicate column names? Instead of SELECT column, T.* FROM TABLE T can you try SELECT column as uniquely_named_column, T.* FROM TABLE T

In Magic ETL you can write a REGEX expression to strip out everything that's not a number or number-related, REGEXP_REPLACE(your value,'[^0-9,.]','') however an additional problem is that 5.76% would get turned into 5.76 which is a totally different number. So I think your idea to turn bad data to nulls is safer. You can…

If you add a RANK() beast mode then you can filter your card on RANK < = 7 RANK() OVER (PARTITION BY `date` ORDER BY `pie value` DESC)

If I am understanding correctly, you should be able to do the following steps using Magic ETL: add a filter for Types IN ('Survey', 'Cutover and Test', 'EPIK','Greenix' ) add a Group By and group by Site and count distinct types add a filter and filter on count = 3 join that back to the main dataset on site

The most simple method of achieving this would be to self join your list of conference attendees to itself, joining on person id. This will create a lot of rows, but I've found that Domo can handle it. If you want to figure out how many rows it will create in advance you can group by person and count the number of…

In your configuration there is an "Allow Leading Digit in Column Name" option, if it's not checked then every column name that starts with a digit will be prefixed with the letter "C"

Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied…

FYI - FROM_BASE64() and TO_BASE64() are MySQL functions that will not validate in the Beast Mode editor BUT if you save them they still work even with the error. It would be nice if these functions would pass the validation though!

I think this is a factor of whether the timestamps provided by the Five9 connector are in UTC and also what your company time zone is set to. If the time stamps are in local time and Domo is assuming they are in UTC then Domo will try to convert the time stamps to your local time defined in the company settings. Take a…

I'm having a little trouble following the logic, it might be helpful if you shared your excel formula. Is the case statement you shared supposed to produce the New Fee A value, and you'll have another for New Fee B? Also, should this part of the expression: (Charge(Proceeds A/(Proceeds A+Proceeds B))+Proceeds A) be changed…

Having an export button would be great, until then as a workaround you can select all the tiles in your Magic ETL and then click "copy to clipboard" this will give you the json of your ETL that you can paste into a file for version control purposes

You can do this with period over period charts without the need for a specialized beast mode

@Arthi Annadi - I'm not sure if any table cards provide hover text out of the box. You may want to look into DDX Bricks, or search the app store for custom pivot table apps. Another option would be to pivot your data in an ETL so that you can use an HTML Card instead of a pivot table but this has limitations as well. In…