-
Dynamic "Last Business Day" filter
Hello Domo product team, Submitting the following: would be great to see the option of dynamically filtering cards by last business day. For reference, this feature should be included in the top right corner inside Analyzer. Thank you for your consideration!
-
Number abbreviations
Hello! Is it possible to abbreviate numerical quantities displayed as currencies inside analyzer? For example, in the picture below it says 21 but that is times 1 BN. Is there a way to include the 1 BN abbreviation without having to do any sort of modification inside the ETL? Thanks!
-
Beast modes with multiple datasets
Hello! Is there a way to make beast mode computations with different metrics from different datasets? For example, I have the below cards that, although the numbers are the same (I am building a reconciliation section of a dashboard), the datasets used to create them are different. Now I'd like to compute the difference…
-
timestamped date to only date
Hello everyone, Is there a way to work out the formatting of dates that are originally dates with timestamps to only dates without having to change anything inside the ETL? Screenshot below: Basically, I want to remove the timestamp part and just keep the date. Is there a way to work out this formatting on the dashboard?…
-
Real null count in dates
Hello everyone, I am trying to get an accurate count of the number of blank cells for a column inside an ETL prior to using a formula to estimate the date in the event that it is blank. I included a test output dataset inside the ETL to track the number of blank cells as well the estimation before/after creating a new…
-
Spreading out labels so it's easier to read
Hello, I am trying to spread out more the following labels that come from a Lollipop chart so it's easier to read, but am having trouble finding the setting in analyzer. Thanks for the help!
-
Actual month name in smart text - date range
Hello everyone, I am building a card using smart text in the card title to include the time range for which this card is depicting data. However, when I include the date range feature in smart text, the card title preview shows literally "previous month". Is there a way in which I could get it to show the actual month name…
-
Blank vs empty square
Hello everyone, I encountered these two fields in one of my columns ("blank" vs empty square), which is messing a bit with my formulas. Why is this happening? What's the difference between the two? Thanks so much!
-
Multiple cases in CASE WHEN
Hello! I am trying to include a formula with three possible outputs based on three different conditions inside an ETL but I don't know what's wrong with my formula: Help is appreciated!
-
Made and worked on a copy of an ETL; want to delete original
Hello, I started working on an ETL and then later made changes to a copy of it. I want to delete the original in order to keep the Domo instance clean (the completed task is in the copy). Will deleting the original cause any harm? Thanks in advance!
-
Table to display number of null values
Hello, I am trying to create a table to display the number of blank cells in some columns in analyzer. I calculated the blank cell count using beast modes. However, when I filter in analyzer to display the blank cells as a count aggregation, the count evidently decreases in all fields as the filter function is an…
-
Smart text format
Hello! I have a question in regards to formatting smart text in dashboards. Currently I have a timestamp of which a date was last updated, but I only want to keep the date and get rid of the timestamp. Below is a screenshot: Any advice? Thanks!
-
Warning, not all data is shown on card
Hello, I have a question in relation to cards: how can the "warning not all data is shown" be removed from a card, such as below? Thanks!
-
No values in cards
Hello again! I have a question about the "no data filtered in range" in cards. How can I turn this to display 0? Thank you!
-
Changing to date format
Hello, I am having the following trouble when changing the data type inside an ETL: basically I cannot change this string format to a date format: Any help would be greatly appreciated!
-
Date formatting in ETL
Hello everyone, I am trying to remove the 0 to format my dates as in the following screenshot: Any advice? Thanks!
-
Rank & Window Function
Hello, I am trying to use the rank & window function to grab the latest date in a column, but am confused as to how to set up the tile. Currently this is my set up: I just want to grab the latest date, but it says that the tile/action is not being configured proprely. Any advice? Many thanks in advance!
-
Dynamic dates in dashboards
Hello, I am trying to include the date up to which data is included in visualizations in a dashboard but I am having trouble finding the function in smart text. All I can find is the timestamp in which the dataset powering the cards was last updated. Would greatly appreciate the help!
-
Remapping nulls in Analyzer
Hello, I have a question about the remapping nulls function in Analyzer. Maybe I am not understanding what this function is supposed to do, but basically I am trying to replace all blank cells in a column with another numerical value. However, when I do it through the remapping nulls function, I see no change in the cells…
-
Counting nulls/blank cells in beast mode
Hello everyone, I am struggling with the syntax a bit on how to count blank cells/null values in a column. Basically what I'm doing is COUNT(CASE WHEN column name IS NULL) Would greatly appreciate any help!
-
Creating a Stream
Hello! How can I create a new stream? Thank you in advance!
