Comments
-
I'm not actually joining any data here. I'm just pulling in tickets with x= "Created Date" and Y= Count of "id". Both values are always present. Even so, my date filter is already ignoring empty dates by only pulling in data for a specified range. The standard table is fine, it's just the "1 Week Ago" data that Domo is…
-
I'm not sure how I would do that? I tried the following with no luck: * Using ticket id = null as a filter, but that doesn't work since there are no null/empty values * I'm unable to use an aggregate as a filter (i.e. COUNT("id")) * I also tried a beast mode IFNULL("id",0) and filtering out 0
-
That was actually a surprisingly simple solution that worked perfectly. The dataset is around 250 rows so I'm not all that concerned with performance at that scale. Thanks for the help.
-
Thank you so much for the very detailed solution. I was finally able to spend the time working through it and for the most part everything works. 3 things to mention: * Value mapper doesn't work for making the Key Date columns. Originally, I was able to do this with Combine Columns and Convert Type to Date/Time. However, I…
-
I ended up fixing the issue by creating a new data set and importing a wider range of entries. The larger sample size correctly cast the column type and I was able to finish the ETL. Thanks for the suggestions.
-
Thank you for your reply. Unfortunately, this does not solve my problem. The problem IS that there is a non-numeric value in the column. The column in question is cast as a number in the dataset, however it should NOT be a number as there are valid values in the column like "PM-123". Since the column is a number, it can't…
