CantStopTheHopp Contributor

To make sure I'm following, you'd like to see a card looking at yesterday vs a week ago from yesterday where the X axis is your provincial groupings?

What kind of card are you trying to build? A multi-line chart showing week over week trends or something else?

I'm trying to set up a sharepoint dataset as well and having the same issue. I'm thinking it has something to do with the access rights associated with the login I'm using, but not 100% sure.

Yes, I'll reach out if I have any more questions.

At the agency I work for, we primarily use Domo for reporting to clients rather than internal analysis though that is changing. Generally we create a page for the client, give them a login, and share only that page with them. There are some exceptions, however. For simple reports on an individual campaign, we either export…

There's no way to do this currently. I suggested this a while back, so please upvote and hopefully Domo support will get on this. https://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/Make-Drill-Paths-Branch-Into-Multiple-Directions-Instead-of/idi-p/3848

I don't think adding a column should affect anything, but to be sure I would recommed copying the original dataset and dataflow, then editing the copied dataset to see if it affects the copied dataflow.

That is strange. I would send in a support ticket.

What dimensions are you pulling? I would recommend Ad Group and Keyword Match Type from the AdWords section, and Campaign and Keyword from the Traffic Sources section, and whatever date grains you want.

It may be prudent to double check the data in your Excel file. I had a similar issue once, and it turned out that due to a copy/paste error a couple of rows had text rather than numbers.

Looks like you've got your "Join Data" and "Select Columns" actions reversed. You have to select columns from each of your input data sets first, then you can join them.

This is actually very easy to do and does not require a beast mode. In the card builder interface, enter the number of rows you would like to display in the "Show Only" field to the left of the chart.

Never mind my last post. Misread the OP.

That is a good question to which I do not have an answer.

You should be able to by dropping in another series.

The only useful built in ExactTarget report I've found is the Send Report with sends, deliveries, opens, clicks, etc. by email name and day. For all other data, I've had to create reports in SFMC, then schedule daily exports to a Box folder, and then import the CSV or XLSX from Box into Domo. It takes a little while to set…

You'll need to reach out to your business consultant to gain access to that functionality.

Add your `Date` field as a sort and choose ascending.

One thing to note about the YouTube connector is that it does not pass through paid views from YouTube ads. I have been able to do that, however, by connecting our AdWords account to Google Analytics and sending a daily export of YouTube ad metrics from Googel Analytics to a Box folder.

Yes that is what I was thinking but was wanting to confirm. Fortunately it wasn't a crucial need so I'm not going to bother looking into it further.

Is it possible to shift this around to start on a different day of the week other than Sunday? In other words, look at Friday-Thursday instead of Sunday-Saturday.

Thanks @scherbelr! One thing to note is that the SUBSTRING function only works with strings, so you have to convert a value into a string to get it to work. In my case I had a CONCAT fuction to combine the number of emails sent and the delivery rate. The original formula looked like this: CONCAT(SUM(`NumberSent`) ,' Emails…

Does anybody know how to add thousands separators to numbers in CONCAT functions? I've tried using combinations of MOD and ROUND functions but haven't gotten it to work.