-
ETL and Beastmode
Hello, hope someone can help me. ========= I have a card level beast mode and filter: Company Name NOT IN "AAA" Destination - AAA Filter NOT IN "Exclude" =========Here's the beast mode for Destination - AAA Filter:CASE WHEN Destination like '%AAA%' THEN 'include' WHEN Destination like '%Tipp City%' THEN 'include' WHEN…
-
Help create ETL
Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please? Here are the details and filters for each card: Card 1: Company Name not in 'MR' Destination contains 'MR', 'TC', 'L', 'NP', 'PP' show count of ID ——————Card 2: Company Name in `MR' show count of ID ——————Card 3 (here's…
-
Not showing 'data' in Table View
Hello. I'd like to ask why my drill down card is not showing any data in my Table view. but when I checked the "Data Table", it should be showing something. When I tried removing either 'PO' or "LabelSerialNumber' columns, card data appears. But when both columns are present, no data is showing. I need both 'PO' and…
-
Starting Day of the Week - Monday
Hello, can anyone help me find a solution on how I could start with Monday for the weekly data? My data is dynamic, so it has to update on a weekly basis - I used Last 4 weeks. I have a table with weekly data showing like the one below, and when I created a bar chart in DOMO, originally, when graphed weekly, it will start…
-
Show the Average in Bar Graph (Days/Hours/Minutes)
Hello. Can you help us find a solution how to display the output we want to achieve? This is the current output that we have, but we wanted to see a view using bar graph. The problem is that, the values are 'string' and not 'numbers' because of the concat function we used in beastmode to identify whether the computed…
-
Getting the Avg Days, Avg Hours, Avg Minutes
Hello. May I ask for your help in getting the average days or average hours or average minutes between 2 columns of date + timestamp data? The thing is, the average could be 'days', 'hours' or 'minutes', depending on the values of the 2 data columns, so we want to show the output similar to a timestamp format to be…
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?
-
Pivot Data Issues
Hello, I have quite a number of rows or data for this table. I'm currently using Pivot Table to display the number of alerts for each of the items. I need to show the last 8 days data (excluding current date). The data should be dynamic, so I couldn't use static dates. However, every time I'm sorting the data according to…
-
Nested Case When?
Hello. I have this slicer and its beast mode below: Here's what I want to achieve: If Project Maya is selected, the column 'Action' should show only 'Disregard' results. If any of the other 3 was selected, the column 'Action' show only 'Resolved' results. Not sure if nested case when statement will work on this. Please…
-
Slicer Question
I need to show the following slicer options: Amazon Mendel Amazon US Amazon International Amazon Project Maya I created a beast mode, only the 1st three options are showing. Amazon Project Maya does not show up in the slicer options. Does it have something to do with the one's highlighted below? The thing is, the Cust ID…
-
Filter Select: 2-day or 3-day data
Hello, is there a way in DOMO beastmode that we can filter cards and show past 2-day or past 3-day data? For example, the current date is 7/21/23: If I select past 2-day data: this will only show data from 7/19 and 7/20. If I select past 3-day data: this will show data from 7/18, 7/19 and 7/20.
-
Show only Data Label of Max and Min point
Hello, is there any way that this graph would only show the data label for the maximum and minimum value? We'd only like to show the values of those 2 points with red circles.
-
Does a slicer work even if I'm using a sub dataset?
Hello. Hope someone can enlighten me or help me if there's a solution for this: I need to use one slicer for my dashboard, which contains like 16 cards. The slicer should be able to filter all cards in that dashboard. Here's my problem: I'm using three datasets for the cards in the dashboard: Main Dataset - let's name this…
-
Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
Hello, please help me create this in DOMO. Thank you. Here are the columns needed: Alarm ID = (given) Alarm Handled Store Time = (given - sort oldest to newest) AHT = with formula, see screenshot below AHT: currentRow - previousRow (from same column) (see detailed formula below) the only condition is that: if the computed…
-
Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
Hello, please help me create this in DOMO. Thank you. Here are the columns needed: Alarm ID = (given) TechName = (given) Alarm Handled Store Time = (given) Average Handling Time (AHT) = see detailed formula and condition below Sorting: TechName - A to Z Alarm Handled Store Time - Oldest to Newest Condition: If TechName is…
-
How do I get unique values from a column?
Hi all. I need help in getting the unique values from a certain column. See example below Say I have this column below with multiple duplicate names in it, I only need to show one for each name. Please help. If it's possible through beastmode, it would be better, because I'm also utilizing slicer/filter for this card, so I…
-
Can I create a pivot table using values from another pivot table?
Hello, please I need help here. I have a pivot table [IMG1] with the following data: Alarm ID No. of attempts before resolving (or basically number of attempts associated with the alarm ID) SF Alarm Count ('1', since we only have 1 alarm per alarm ID) [IMG1] So here's the output that we want to achieve [shown in IMG2]:…
-
How can I group these results by date?
Hello, I have to get the total unique alarm count per date, can someone help me, please? The output should look like below (see [IMG1]). I have two slicers: Healthcare Month What I wanted to do is: I want to count the total unique alarms per date, depending on which was selected in the slicer. The first two columns are…
-
How to get values from a different card?
Hello, I want to create a donut chart containing two values (both coming from different cards). Say for example below, I have these 2 separate cards (Single Value) [see IMG1]. The values of these 2 cards vary depending on which was selected in the slicer filter. Is there a way I could create 1 card (donut) showing these 2…
-
How to exclude a card from getting filtered? (slicer filter)
Hello, I have like 3 cards in my dashboard. Month Slicer Number of Orders for the Month selected from the slicer 12 month view of number of orders Question: Is there a way that I could exclude card #3 (12 month view of number of orders), from being filtered when I use the month slicer thing? I only want to use the month…
-
Sub Slicer in DOMO
Hello. Is there a way I could create a sub-slicer in DOMO? Given the sample illustration below, I have the main slicer selection as: Hospital Restaurant Store I need to add a subslicer under Hospital as: Hospital_1 Hospital_2 Is this possible?
-
HELP with Case When Statement
I need help on how to code this in beast mode. (It's like I need to tag a specific column that it's either included/excluded based on the CASE WHEN statement). I just dont know how to do in using the proper syntax. CASE WHEN ........... Then <field name> 'excluded' Else <field name> 'included' END