-
Unpivot
Say my raw dataset looks like this: And I would like to unpivot any column that has a month name is it, so in this example, it's 'Jan 2024 Total Pts Earned' and 'Jan 2024 Pts Redeemed', and the dataset would look like this (add a date column, total pts earned and total pts redeemed column): How can I do this with Magic…
-
How to change app width in App Studio?
It seems like you can only change app width with 2 options: Fixed width or Auto Width. But both are still too wide for my App. I'd like to make the width smaller by entering a specific px for the width. Is there a way a can do that in DOMO?
-
Any way I can add a column to a card table that I can write comment on it?
I have a simple table card with some columns and beastmode calculations. But I would like to add a blank column where I can write a comment on it. Is that something javascript/css/html can do?
-
Alter Column: file to convert type String to Date
My current dataset has these columns: Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 ………. and so on. And I'd want my table to just have 2 columns: Date and Point So I used Unpivot tile, but I am unsure how to label my the new Date columns (number 4), so it will turn into a date format using Alter Column tile afterward. Do I…
-
Column failed to convert from String to Floating Decimal
I have a column that show 2023 sales as "$3,432.12" kind of format which DOMO identified as Text. However, I think I need to get rid of the "$" at the front before using Alter Column Tile to change it into Floating Decimal. How can I do that?
-
Find missing records from 2 tables
Excuse me for not providing a screenshot as the data is sensitive but I have 2 sales order details datasets: - A (sales orders for the year 2024 - 1.7M rows) - B (all the historical sales order for all years - 14M rows) - I want to see which orders are in A but not in B. It's pretty straight forward to do a LEFT JOIN, A =…
-
Appending a dataset said "Data updated successfully" but no rows was added?
I was appending rows on my existing dataset by going to Data → pick that Dataset → Settings tab → Details (drag my other dataset in), update mode: Append) → but in the History Tab I saw no rows was added: P/S: I was appending just fine yesterday, so not sure what happened
-
Month filter not working on all cards in an App?
I have 2 card visuals for my app right now. Card #1use dataset 1 (have a month and a year column). Card #2 use dataset 2 (which has a date column, formatted as 'yyyy-mm-dd' And so my goal is to select a Month (say August), and both card #1 and #2 would show the data only for August. But if I create a "Dropdown Selector"…
-
Beastmode to return current month value? And what's the best card type to show the variance?
My dataset has these columns: year (int), month (int), target, actual I created a BeastMode to return the current month (Aug) value for both target & actual, but instead of showing an actual value for Aug, it shows 0. CASE WHEN month = MONTH(CURRENT_DATE()) THEN target ELSE '0' END Since I want to see the variance for…
-
Smart Text card title show year with a comma. How do I get rid of it?
So instead of '2024 Sales', the title shows '2,024 Sales'. How do get rid of this comma? I used 'Display any filter' Sales as Card Title
-
Data Labels disappear?
I have a line chart with category labels next to each line, and I have a drill path to this line chart as well. But the labels kept disappearing (the lines were still there) after I returned from the dill path. I don't prefer legend, but I'm not sure how to fix this.