-
Cards suddenly show "US$xxx" instead of "$xxx" in summary number
Suddenly, our cards using the $ currency format for its summary number are showing US$ instead of $ - I suspect this is a setting that was installed in a DOMO update. Is the only workaround to do a CONCAT($) type function? This would take a while as we have quite a few of such cases and individual beastmode calculations…
-
Field that returns 1/0 based on all similar values in the same column
Hello, This should be pretty simple but I can't find the solution. I tried fiddling around in ETL and beastmode, as well as googling, but was unsuccessful. Here is the problem: I am trying to create a column that returns 1 when any unique Job has a PO#. For example, in the second row there is no PO, however the 1st row is…
-
SQL Transform for Customers With No Invoice Dated 2 Years Prior to Current Year
I have developed an ETL dataflow that outputs our gross margins per job. I have then used this dataflow to create cards that show total gross margins by customer. What I am looking for is to start from this exact same ETL flow but output only customers that have not had invoices in the 2 years prior to current year - so…
