Best Of
Re: Line Chart with Weekends Denoted
There isn’t a way to switch the color on a single line however I’ve used two lines with the same values and a beast mode to conditionally display certain values. You’d use your metric as the weekday which would display the weekend and weekdays.
CASE WHEN WEEKDAY(`Date`) IN (1,7) then `Metric` END
you’ll have to play around with the order in which they’re listed as values in your chart but it would allow you to have a “line” that alternates colors. Just set the color on your metric as the color for the weekday and the beast mode color as your weekend color
Re: How to grant permission for a user to access an ETL dataflow?
@GrantSmith Did your idea for this in the exchange get deleted? I tried to click on it and upvote, but the link is dead.
Hoping Domo is still working on implementing something to address this issue as we are in a growing world of collaboration including ETL's!
I don't want to give our users admin rights or super user privileges to edit all ETL's -- I just want them to be able to share access to their ETL's to their other team members so they can work on them / review them together.
PacoTaco
Re: Can you use _Batch_Last_Run_ as the date for a recursive dataflow?
The batch_last_run will be the value when your raw data is imported into the system, the currentdate in an ETL would be populated when the ETL actually runs. Depends on what you're wanting to track with your date.
Re: Sum if using Case When
Try moving the SUM to the outside of your CASE statement instead of being inside. I would also double-check your data to make sure you are matching exactly, such as case-sensitivity and extra spaces.
Re: Sum if using Case When
Try this:
SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END)
This should get the total you want.
Re: Filtering Report Data by Multiple Dates
@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"
mhouston
Re: Copy an entire dashboard
@damen Yes, if you click the wrench in the top right corner of the dashboard and select "Save As" you can copy an existing dashboard.
Re: Dataset refresh failure notifications
We had a similar use case and created a group email address, set up a user in Domo with that email, and then made that user the owner of the process the group needed a notification about.
akeating