Comments
-
The other thing I've done is in a dataflow just appended a date dimension so there's a "row" for each date, even if there's no "actual" data. Only caveat is you need to make sure your blank date rows match your card filters otherwise they won't help.
-
DDX Brick is the way!
-
ETL is 100% the way to go, and you can use the Domo Date Dimension if you don't have a custom calendar.
-
Window functions in a beast mode are a good way to make this dynamic!
-
I agree with Michelle and Grant - blanking it out with a case statement is absolutely the move here!
-
@Rafi1470 you could expand the beast mode a bit like this: SUM(case when Particulars = 'Sales' then Amt else 0 end) - SUM(case when Particulars = 'Cost' then Amt else 0 end) And then group it by order or invoice or whatever and it should give you profit!
-
That sorta sounds like it's a Domo to Reddit API issue. I'd start with Domo support and get it escalated.
-
When I had clients change email addresses, it did make them new users. From the SSO attribute section under email it says this: "The user's email address. Domo uses this value as the unique identifier for the person's account, so any value included for Email will overwrite the SAML Subject value in the SAML assertion. Domo…
-
Another great option is the dataset copy - you can create a copy with whatever interval you want and have it append.
-
If you only want to apply it to the after the @, you could split it at the @, lower the company and keep the part before it uppercase
-
I'd try just 1 row and see if it times out, but it should have been able to use 7k rows. I'd double check your connections and your permissions.
-
I don't believe that's possible - but you might be able to pull in notebook cards that would have dynamic text.
-
You could use campaigns!
-
I agree with @ArborRose, using tags and standardizing your dataset names can help with this.
-
Ya I think just append them and then use either a filter or a variable. @vibhusharma2210 @tracy_gamlin
-
Could you just copy the card and then switch the dataset? What's the dynamic need?
-
Sometimes figuring out the date syntax can be annoying - I usually ask chatGPT like "I have text like "12/31/23" how do I make it a date in MySQL" and it will spit out the proper syntax… most of the time.
-
You could append two datasets together and switch back and forth with a filter or a variable - but I agree with @MichelleH, more information is needed.
-
Thank you @GrantStowell, @GrantSmith, @marcel_luthi and @Ashleigh!
-
Would something like this work? Case when SUM(SalesQuote) <> 0 and SUM(BannerAverage) <> 0 then 'Show' else 'Hide' end
-
With out of the box Domo functionality, I don't think this is possible. It might be possible with campaigns, but I've had the same issue and just end up sending 4 emails or if it makes sense combing the datasets into 1 and having the card show that.
-
Not sure if you could do this, but there are probably easier solutions. You could make a beast mode that says if it's the first of the month, show the prior month, else show the current month.
-
So do the same logic, but use @GrantSmith's post here on how to calculate rolling averages:
-
Just something like this:
-
Great job @DavidChurchman!
-
How are you calculating the average? Could you just go a group-by in the ETL by Creative type and then append it to the dataset? Then if anything new is added it would just get added automatically.
-
Thanks @DDalt!
-
I haven't experienced it in the handful of environments I was in this morning
-
Have you tried the grouped bar + line chart type? Your data does need to be structured a certain way to get that to work EDIT: I meant grouped, like @Juliann_Potter recommended.