Best Of
Re: How do I alter Date (in Text format : 01.09.2023) to Date format?
Based on the error message, it looks as though one of your rows contains a value of LAST_RUN and not any form of a date. You can try and handle this two different ways. In your formula tile, you can try wrapping a TRY_CAST function around your STR_TO_DATE function like this:
TRY_CAST(STR_TO_DATE(Date, '%Y-%m-%d') as DATE)
This will attempt to convert it to a date field and if it can't it will just make the value null.
In the alter tile, click on the settings cog next to the cast data type and select Null in the Bad Values dropdown list. This will do the same thing as above, as it will make the value null if it can't convert it to a date for you.
Re: Add a condition on line plot to toggle between AVG and SUM conditions
The issue is with the count portion, are you looking for distinct row counts you can CONCAT all of the fields together:
COUNT(CONCAT(Plant, Group, Code, Month, Name, Part Number1, Part Number2))
Re: Booking date and shipment date formula
I would use the QUARTER() function and the YEAR() function to ensure that you get the expected result. It would look something like this:
CASE WHEN QUARTER(dt) = QUARTER(CURRENT_DATE()) AND YEAR(dt) = YEAR(CURRENT_DATE()) THEN 'Same'
ELSE 'Different'
END
Re: Bar chart years not in sequence
Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.
Re: Remove dates from a card with a beastmode?
You can create a beastmode to flag certain dates and then select to either include or exclude those dates by adding the beastmode to the filter section.
Re: I have a column of part numbers and I need to exclude any rows where a part number has a character
You can use the split columns tile in Magic ETL to split up your string by looking for the comma. You would do multiple splits in that tile so that you can get to the 3rd and 4th entries. You can then do a filter tile where you filter out entries that have the values you want to exclude. Here's a KB article on the split columns tile.
You can also use the SPLIT_PART function to do this in a formula tile.
Re: I lost connction to DOMO. get "Could not authenticate user"
This happens when your password has changed or expired. You will need to click on the key icon on the left of workbench and then click on re-authorize. It should open a browser and have you enter your credentials and a code. After you enter that, be sure and click on the save icon in workbench in the top right where you clicked re-authorize or else your credentials won't be updated. After this, close and re-open workbench and your jobs should re-appear.





