Comments
-
Here is a picture of my table view that will hopefully help. I'm looking to get the blank values to say 0 and the blank percentages to say 100% for those months.
-
Unfortunately, i cannot due to the sensitivity of the data. There will be a ticket_number field (alpha numeric), creation_date (datetime), start_date (datetime), and finish_date (datetime). The ticket_number and creation_date will never be null, but the start_date and finish_date will be null sometimes. Please let me know…
-
Certainly - when i drag the new measure that was created with the case statement to the y-axis field in DOMO, the area with the graph goes blank and it throws this error - "An issue has occurred during processing. We are unable to complete the request at this time". Please let me know if you need any more information.
-
The formula will validate but I get the same issue when adding it to the y-axis of my line graph.
-
Ricardo, Thank you for your continued help on this. I'm still getting the same error with the case given most recently. Is it possible that i'm using an improper series for this data which could be causing the error? I used a "total minutes in the month" calculation i made to get it to work with my previous one, but it…
-
datetime
-
that formula won't validate. now you have me thinking that the value isn't actuall null. would there be a way to throw a trim in here as a 'just in case'?
-
No - the graph will just have no value for the months where no records have values in those date fields. This is making the line graph look like a dot graph ?
-
Ricardo, Thanks for your reply. I've done this, but i'm still getting the same error. The formula validates, but when i go to make it my y-axis in the graph, it says "An issue has occurred during processing. We are unable to complete the request at this time". It had done this before on the other calculation, but i made…
