-
How can I remove these multiples?
Hello, I have a Magic ETL that provides open order data based on an item number. One issue I am facing is if I have two or more types of open orders for an item, then they will cross multiply. For reference, I have 3 open internal requisitions and 3 open sales orders for 1 item. Instead of displaying 6 rows (3 IR and 3…
-
How can I create a beastmode that will return the desired substring in a field?
Hi all, I've given this multiple attempts and just can't seem to get it. I have a field called 'Destination' that I want to use in a Beastmode that will return the first substring of "B-FGI" or "FGI" in a value such as "Doe, John A-B-FGI-20.15.0003.B-FGI" or "Doe, John A-FGI-20.15.0003.B-FGI". I also want to create another…
-
How can I format my Alert so that it displays the information in vertical text?
Hi all, Currently my alert just has an attachment and link for the report. I have a customer who would like to be able to scroll and see all the order info. The first picture is what I'd like to have. The second photo is how it is currently configured. Thanks in advance!
-
How can I get rid of extra characters in attributes
Hi all, I have a field that lists carriers in an odd fashion such as below: 000001_BOSMAN_T_GND 000001_UPS2_A_F-EX 000001_UPS2_A_LTL I'd like to get rid of the unnecessary characters at the beginning and the end so it looks like this: BOSMAN UPS2 Is there a Beastmode function or calculation that can help me do that? Would…
-
How can I make a historical/week over week chart without a provided date field?
Hi all, I want to make a new but related chart that shows the trend of the SUM of total value week over week. The problem is that I do not have an available Date field in my dataset/ETL except for Item Creation Date which does not seem useful. Also, this total value field is a calculated Beast Mode: (safety stock qty*item…
-
Requesting ability to schedule on a quarterly, semi annual, annual basis
Currently I am only able to schedule reports on a monthly basis at the most. I have a couple reports that need to be scheduled on a quarterly basis (or more). Can we make that a feature?
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
