Best Of
Re: Show a card ONLY when a specific dashboard filter is in use
@AaronCrouch I don't believe this is possible in domo at this time, but you could submit it as an idea in the ideas exchange.
when you say only one option is selected - do you mean a specific value? one idea to explore could be creating a beast mode on your dataset that hyperlinks to the card you want to show only for that value. so when that value is filtered, you'd get the link and you could click over to the other card, otherwise the field would be blank.
mhouston
Re: Card updates later in the month than other cards - Beast Mode to keep previous value until update?
What are you using for your date range filter? Do you have set to this month? Or do you have it set to All-time?
If it is set to this month, then it will always show the current month regardless of any beast mode you create. I would probably set it to the last 2 months and then use a beast mode to do the toggling between months based on what day of the month it is with a nested case statement.
Re: Card updates later in the month than other cards - Beast Mode to keep previous value until update?
@Joe_M Would using a beast mode like the following work for the date on those cards?
case when DAY(CURDATE()) < 7 then DATE_ADD('Date', interval 1 month) else 'Date' end
This says whenever the day of the current month is before the 7th, add one month to the dates in the 'Date' column (show the previous month). On the 7th or after, don't modify the date (show current month). Not 100% sure if it will work but worth a shot.
Re: Create beast mode dates
The STR_TO_DATE function is going to be your friend in this case. Try this for your beast modes.
Start
STR_TO_DATE( CONCAT( REPLACE( REPLACE( REPLACE( REPLACE(`Start`,'th','') ,'st','') ,'nd','') ,'rd','') ,' ',YEAR(CURRENT_DATE()) ),'%b %d %Y')
Stop
STR_TO_DATE( CONCAT( REPLACE( REPLACE( REPLACE( REPLACE(`Stop`,'th','') ,'st','') ,'nd','') ,'rd','') ,' ',YEAR(CURRENT_DATE()) ),'%b %d %Y')
Here's the breakdown of what I'm doing from the inside out.
Use the replace function multiple times to remove the th, rd, st, nd from the day of the month.
Add the current year by using the year function and the current date function so you have a complete date.
Use the concat function to build a string that would look something like this: Apr 4 2022
Use the str_to_date function to convert that to a standard date. The %b %d %Y informs the function what format the string is currently in.
Hope that makes sense.
Re: Aggregating Numbers
You can’t change how the data is displayed conditionally based on the type of chart selected. You can graph it as a bar chart and by default it will display the raw data table when the user clicks on the card in the details view.
Re: Exporting a filtered file
Hi Damen,
I think that using Views Explorer on your dataset would make this a very easy lift. Once you're in there, click on the 3 vertical dots at the top of the purchase date column and select "Remap nulls"...put in a value like "rows to inspect" or whatever. Then you can filter just on those column and export to CSV. (repeat as needed for any other columns of interest)
Billobi
Re: How to remove 'page filter' sign at right corner of each card when you export a page as ppt or pdf?
@DavidChurchman Thank you for posting this, very helpful!
Re: How to solve this problem in Magic ETL - Link items to Header rows
Billobi - Thanks a lot for your solution. You have challenged your mind to make it possible. Great work
I had a time constraint due to project deadline , so I had implement the same with Python script tile.
sample code
input1["Ad run date"] = input1["ad name" ]
for i in Range(Len(input1)
if input1["Campaign"][i] = '-'
j = i -1
input1["Ad name"][i] = input1["ad name"][j]
else
input1["Ad run date"][i] = ''
Skhatri
Re: Bing Connection - Almost there but....
Hi there, I have felt the heartburn associated with the Bing Ads connector as well. The authentication method leaves a lot to be desired for, especially if you're not a regular within the Office/Azure workspace.
The KB article on the connector calls out the big 3 - making sure you have the dev token, the client ID & secret, and setting the redirect UI. If you haven't done all of those, be sure to circle back through the KB thoroughly...there are several tiny gotchas that are easy to pass by. Also be sure that your Microsoft account has all the right permissions (Super Admin) and can see the ads in the UI that you're trying to pull down.
The understated item that is pretty important (and perhaps relevant to your particular error) is that you need to use the same Microsoft account for all of those steps, then you need to use it again when you put in your creds in OAuth when making the connection in Domo. If you regularly switch between several Microsoft user accounts, the connector can easily trip up and try to store the wrong account. I always recommend using incognito browsers when setting up this connector to prevent prior credentials getting pulled in inadvertently.
Have you managed to beat this issue into submission since your initial posting? :)
Billobi