Comments
-
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.
-
I've done this before but by concating fields from Domo into the URL of the system, like companyid.netsuite.com/customer/DOMOFIELD. Those specific systems had the IDs of the things in the URL so it was just a matter of recreating the URL syntax in Domo
-
For previous year to date, I do: "Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End" Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
-
I believe it will keep 9/01 open and then also have 9/08 open. I submitted an Ideas Exchange topic about auto-collapsing:
-
For previous year to date, I do: "Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End" Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
-
Agreed, I ran into this issue yesterday and was frustrated I couldn't do this. Great request @marcel_luthi!
-
Why are you using the LAST_DAY beast mode here? That will make all of the dates the last day of the month that they're in.
-
It's irritating that NULL values tend to break math
-
Do you need the card to respond to page filters/date range? Because you could sum up the ChildPN's active qty in the dataflow and then join it back on and then filter on that? (Which based on your question, I think you do). Could you remove the line items from this view, filter the ChildPN here and then have a drill that…
-
If I remember correctly you'll need to link pages to cards to datasets, which can cause some cardinality issues, but then you can also credit a card/dataset when a page gets viewed vs. just when a card gets viewed.
-
Agreed with the others, I don't think you need the FIXED portion, as just a count(distinct) should filter it out. I had a client who did something similar and it worked great.
-
Agreed, I've done dynamic column renaming using a Stored Proc in a MySQL dataflow - you can query the system tables to get the schema.