-
Charts showing all 1s
For some reason I am seeing all ones in my stacked bar chart. I think it has something to do witht he Grouping but I am not sure. The Creaeted Dates are daily grouped as Months but it looks like it is counting only the dictince booking ids for 1 day or something I attached what it looks like. Any help, as always, woudl be…
-
I get the following error on most of my cards now "An invalid column was specified in your request"
Someone made a change to the data I believe. Is there any way to get more detail from this error - like which column it is. I am having a hard time finding the column it is referring to Thanks
-
CASE WHEN using IN
I am trying to filter my records by specific accounts. I am using beat mode to try and do the following: CASE WHEN `Company Name` IN('COGNIZANT', 'AARP') THEN 1 ELSE 0 END Then I use this as a filter set to 1 hoping to only return the accounts I am looking for. When I run this I never get any accounts returned. Any input…
-
Dynamic Filtering of cards
I am trying to create 2 dynamic date filters with no luck. MTD - up to end of previous week A rolling 13 month Has anyone done this before? Thanks in advance for the help.
-
Rolling 13 month calculated up to end of previous month
I have this calculated field whcih is a rolling 13 months but I cannot figure out how to limit it to the end of the previous month CASE WHEN `Start Date` >= DATE_SUB(DATE_FORMAT(CURRENT_DATE, '%Y-%m-01'), INTERVAL 13 MONTH) THEN 1 ELSE 0 END The results I am looking for if I ran it today would be everything from Feb1 2017…
-
Scrollbars on Presenation do not work
I am wondeing if I have done something. For some reason when I open the presentation I can see the scroll bars at the bottom but I cannot touch them or they do not work and there is always this screen that opens when I hover over the scroll bars. I have to be missing something.
-
Legends not showing when card saved as slideshow
For some reason I can see the legend when on the overview page but they disappear when I publish as a slideshow. Any ideas how to stop them from disappearing?
-
Make blanks 0s in Sumo pivot
In excel there is an option you can set on pivot tables to display 0 for null fields. Is there a simialr setting in Domo for Sumo charts?
-
Delivering Cards as they appear to shareholders
Hello Dojo, Is there a way to send results from cards as they appear on the card rather than the underlying data. I have a chart as well as a sumo card and I woudl like to send them to shareholders in the format they are on the card - not as the raw data like when you export to excel. Is this possible? Thanks in advance
-
MID Function
Hi there, I see Left() and Right() as listed functions. Is there a MID() or some other way of performing this function in Domo? Thanks
