pauljames Contributor

@ananya_ravi01 , you could setup alerts for cards/reports that could trigger in this cadence.

@jakebutterfield the LinkedIn followers count can be found in the LinkedIn V2 Connector > Report = Get Company Followers Statistics > Retrieve Date for Time Period. You have to select a breakdown, but whatever you select you can just sum with group by in a magic etl to get account.

@jakebutterfield I found the Facebook follower count connector. Facebook Connector > Report = Page Info > Field = Common THEN followers_count. You could setup a daily append magic etl to start a recursive growing dataset which would eventually get you months time series history. Let me know if this works. I'll keep looking…

@RTData , this is a tough one. I think if the participant would have applied the filtering inside magic etl then one could just copy and paste for another card on a different dash quite easily. But if the participant applied filtering on the dashboard level then you could only share with others who have access to that same…

@Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.

@Cherilyn something like this?

Hi @chetan_cricut, have you checked out the KB yet?

how do you batch dates together in a beast mode? case statement?

@bennett_for_you the period over period multi value card would also be helpful! If alternatively using Michelle’s recommendation.

Case statements need else “category name” end language, I believe.

Hm. Perhaps you could create a template magic etl with a new column “Null Counter” you could add a column that uses the ifnull(column name, 1)? Then on that column name you could sum all rows that are 1, etc. You’d have to run every dataset you got through this etl example but perhaps it could work. Not easy necessarily,…

1st grade where I met my wife. I was scooby doo!

Hi, I have many Shopify connectors. Be sure it’s the custom app connector! This could be your problem.

@AO3 here are some snapshots for practical application. I hope this helps you! Specific date ranges need to be applied in this way.

@Mwatson , you could evolve the card that you created based on Marks input and make it a period over period multi value chart. Shows your progress of reducing errors or the unfortunate case of increasing errors. :/

@lawiti I like the treemap pie and funnel chart. You can plug in different data points using tooltip fields/hover text options.

@GrantSmith congrats!

Hey RTData, exactly what MichellH said. I just recently downloaded myself. The outlook plug in for email has become an essential and the powerpoint add is simple to refresh your visualizations without having to manually export or take snapshots. From Admin you can just scroll down to bottom of page to tool downloads.

Hi Rafi, use the pivot table chart in a card. Sales, Cost as rows with country as columns. Calculate Profit in a beast mode and add as row. Then in the chart properties be sure to select totals, then show total row and show total column.

@TiagoV , have you tried the 100% stacked bar chart? I know you can show a total label on top of each one of these regions as well as % of total. You could also edit the bar settings to 100 to make the chart type look like a Mekko chart if that's what you wish. In terms of values next to legend I'm not sure thats possible…

@carthur , perhaps you could save an ETL that has your most common historical ETL groupings. Then you could reference this same ETL instead of searching for those that you think you've used the same grouping in the past. But yes, I agree with Michelle on the upvoting in the ideas exchange.

@carthur , perhaps the column of data for the desired missing date range is missing even though rows of data with the date exist. Can you send a photo of your ETL?

After looking into the facebook ads manager platform on the channel side, we see conversion and conversion value. Perhaps this is an issue with the domo connector?

Hey I figured it out! Thanks Grant

How would you do that? I'm attempting without success.

@GrantSmith, I'm running this MySQL dataflow and its taking forever. What am I doing wrong potentially?

Hi Rutakale, have you tried a beast mode using CASE function? You can group by your custom categories you create then apply metric to fill the categories like you want.

Hi Oliver, I've had similar issues before but with calendars. You might need to create a magic ETL or beast mode to ensure the characters you want in the hover text are the right ones. You could try making categories with a beast mode. i.e. CASE WHEN 'insert column' LIKE '%insert characters%' THEN 'insert new category…

I've gotten a few private messages since posting earlier today. I'll send some more details now on how I did this. Important context, this is for our online e-commerce store here in the U.S. We needed to continue tracking important consumer behaviors such as bounce %, add-to-cart %, abandonment %, conversion %, etc. The…

Hi Anna, I always start with the knowledge base. :) 9 times out of 10 it answers my question, if I can't find the answer I search the forums to see what the experts have to say.