-
Creating a case statement based on Row Header
Hi, Would it be possible to create a case statement that basically looks at the row label and then takes the variance of the two? For example One column at the end called variance and for loads it takes the variance and for MPL it takes the variance etc.
-
Bar Chart Beastmode
Hi, This problem has been given me issues for awhile now and I am completely lost. I have a bar chart that uses a specific beast mode. CASE WHEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)- avg(DATAllinAvgCPL)) > 0 THEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)-avg(DATAllinAvgCPL)) Else 0 END The issues arises on the bar…
-
Radio button Filter
Hi, Is there a way to make the radio button filter always select the current date by default? Or would using a drop down filter be better for the user so that it displays the current days data without the user having to click anything.
-
Tool Tips
Hi, I am trying to use tooltips for the first time so that I can add it to the data label on my bar chart. I know when you use a pivot table you have options to do % of subtotal for certain columns. Is there a way to do that in the tool tip field?
-
STR to Date
Hi, I have a ETL formula tile That I am passing a str through and turning it into a date using this formula STR_TO_DATE(Get Fiscal Months, '%Y-%m-%d') however its coming out as NOV 1st 2023 12:00am. Is there a way to get rid of the 12 AM? Thanks in advance!
-
Creating a New column
Hi, I am trying to figure out the easiest way to create a new column. The new column would be taking dates and assigning them to a month. For example the values assigned to NOV 2023 would be between Oct 27th(3 working days (excluding weekends) of the last month to Nov 27th (3 working days before the last day of the month.…
-
Creating a visual with the Map
Hi, I have the lat, long of both the shipper and the destination city however, when I go to the map visualization I only see the option to put state name and state value. Am I using the wrong map? I ideally want t Thank you in Advance.
-
Running Total
Hi, I have a question related to keeping a running total and then moving that running total to a new column called 'Most consecutive days' and I am not sure if I need to do this in a beast mode or MagicETL Is there a way to, for example, product A sold for 10 days in a row, didnt sell a day then sold for 3 days in a row…
-
Title of cards
Hi, Just curious, Is there a way to move the title of the gauge card to the middle instead of the top right?
-
Dynamic Y axis
Hi, I am just wondering if its possible to create a chart where the y axis is dynamic. For example If I have a min of 200 and a max of 300 for one product and then another product has a min of 700 and a max of 1000 is it possible to get the y axis to be 80% of the min and 120% of the max of these two? Hopefully that makes…
-
Exclude from List
Hi, Simple question. I am trying to exclude values that contain a certain word in the beginning of the string. How would I write that as a beastmode? I know I could write a lengthy case statement saying Case where Bill_To <> 'Location A' then 'Include, Where bill_to <> Location B then Include, Etc…
-
PDP
Hi, Just out of curiosity, is there a way to remove PDP from a specific card but keep it on the others? I accidently created a card with a dataset that has PDP and I'm trying to avoid the long way of fixing it of copying the dataflow, turning off the PDP and recreating the card. Thanks in advance!
-
Beastmode to get first week of month
Hi, I am currently trying to get a field that displays the value for the first week of the month. Currently I have it written as (CASE WHEN WEEK(DATE_SUB(CURDATE(), INTERVAL 2 WEEK)) = WEEK(ORDERSTARTDATE_DATE) THEN (carrier pay) END) / (CASE WHEN WEEK(DATE_SUB(CURDATE(), INTERVAL 2 WEEK)) = WEEK(ORDERSTARTDATE_DATE) THEN…
-
MYSQL Time
Hi, Is there a way to cut down the time of MYSQL dataflows? I have a dataflow that takes 6 hours for 5 million rows of data and would love to find a way to cut that down.
-
Help with Bar Chart formatting
Hi, Quick question. Im having an issue where every time I remove the 'Series' part of my chart, it adds multiple values on the X axis that are the same. When I add the 'Series' it has two bar charts (Which is what I want) but it doesn't look visually appealing. I want the two normal Bar charts with the total Value (658,739…
-
Issue with Beastmode
Hi, I am trying to take the average for the year of a Column called CPL. (Formula for CPL is Carrier pay/Loads) I want a column where it is the average of $512,$235,$393, etc.. Any help would be greatly appreciated The beastmode I wrote is as followed. However, the error I am getting is Calculation Error : This calculation…
-
Creating a variance column
Hi there, I am new to Domo and I have a question that I believe has an easy solution, however, I cannot figure it out. I have a table created to display Cost per load over the past three months. The formula for CPL is SUM(carrier pay)/ SUM(Loads). I want to have a column that displays the previous months CPL - Current…
