The color rules dialog has limited horizontal space to display the names of dataset columns. If the column names are similar and exceed this length, there is no way to differentiate them or to know what color rules are already set. As a typical example we have a column named "COL_SUBCLAIM1CATEGORYNAME" and a Beastmode…
Hi, Is there a way to build a filter with different column values in it and then build a beastmode that will select the column based on the filter selection? For example lets say I have full price and markdown data in different columns. I would like to build a filter that has options for full price and markdown and then…
I'm trying to exclude old items from my card. I'm using the following as a simple filter but it comes back as invalid. What am I doing wrong? Yes, I've confirmed they are both date fields. (CASE when DATEDIFF(`Close Date`,`POV End Date`) > 365 THEN 'Do Not Count' Else 'Count')
Hi, I'm not sure what I am trying is possible but here goes. I have my data stacked as per @GrantSmith's excellent post. What I need is a calculated column for the last year column that only includes the value if "Another Value" from the This year row = 'Y' So only show 600 if another value =Y from period type this year So…
I have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…
I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks
Hello, how do I create this kind of chart in DOMO?
I'm trying to work out the success rate of applications submitted, attached is a basic flow diagram of how this calculation works. I have setup an ETL which filters out any withdrawn applications and separates the approved and refused applications. Is there a way that I can sum the values of Approved Applications and…
I have a window function that takes the total count for a given error code and divides that by the total number of samples run. If a sample is run and does not generate an error, i.e. it completes successfully, then there is no error code. In order to calculate the Error rate (we use Errors per Million Samples), I need to…
Hello, Yesterday I received a request for the ability to change number formatting on a card with a Quick Filter. The format of the values is currency with no decimals. The ask is for a toggle to display the value in 1,000s. Any ideas on how I could add this functionality to a card? I know I could duplicate each row in the…
It looks like you're new here. Sign in or register to get started.