-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Aggregate a Beast Mode
Hello, I am working with a retail dataset and need to calculate beginning and ending inventories based on a user selected date range. The calculation is straight forward but the problem is aggregating the result so it displays on one row per item. The goal is a table card of items reporting beginning inventory, ending…
-
Update Icons for Column Types Displayed in Dataset Views
Please update the icons in dataset views to distinguish between Floating Decimal, Fixed Decimal, and Double. This is problematic when attempting to union views and they columns all show the same icon but are different types. Thank you, Chris
-
Changing Number Formats with a Quick Filter
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…
-
Microsoft SQL Server Partition Connector
Hello, I am attempting to use the Microsoft SQL Server Partition Connector for the first time and I am getting zero rows returned. My partition column is a datatype of datetime2(3) which would be a date format of YYYY-MM-DD hh:mm:ss[.nnn]. Using this Custom Date Format results in an error stating Domo system error…
-
MS SQL Server Writeback Connector
Hello, Can the MS SQL Server Writeback connector be used to write data to an Azure database? Thank you, Chris
-
Graph by Hour Unavailable on Date Selector
Hello, I have a bar chart where the X Axis is a datetime beast mode created using the str_to_date() function and I am charting by hour. In design of the card I can set any date range and the card graphs by hour. When viewing the card if I change the date range the card defaults to a Graph By of Day and greys out Hour. Why…
