-
Re: Adjust Image size in Pivot Table
The pivot table is more limited in the html that it accepts. I would suggest adding it to the idea exchange to see if it could be added in the future.1 -
Re: How can we stop the dataset from disabling with time automatically?
If you don't want the dataset to go into this state, I would create a card based off of it and add it to your Overview page. You might also build a scheduled report off that card to ensure it is…3 -
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 …1 -
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) …1 -
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 the…1

