-
Integrating different social media platforms reporting
Is there a way I can extract data/metrics from all social media accounts (LinkedIn, Facebook, Youtube) together? I use connectors to extract data individually from each social media connecter. But getting all metrics in one Dataset can be helpful in getting a better visual view.
-
How to select which Metric should go on Line in a Line + Bar Graph?
I have a chart where one Metric is $ and rest all is Numbers. How do I graph it in a way where the $ shows as Line and other show on Bar graph. (Like how in Excel we do a secondary axis) In the picture below, its taking the 1st one(USB requests) as Line while I want to show the Red Bar as Line with $
-
Please help me write this filter formula:
How can I write a filter formula where I want to exclude everything that says 'INTERCOMPANY' from 'CUSTOMER TYPE' Column except this one scenario where we keep 'INTERCOMPANY' where there shows 'X' in 'COMPANY' Column. Similarly, how to write a filter formula where I can exclude everything that says 'ENDUSER' from 'CUSTOMER…
-
Month over Month % Change Formula
Hello, I'm collecting data from Google Analytics for my company's website. I'm graphing Date to Avg. Session Duration. I need to add a calculated field for Month over month % change. How do I extract months from 'Date' column here. Below is how I calculated Avg. Session Duration & have graphed it. I want to use the MoM% in…
-
Can't Graph by Month
I've merged two tables and used the following formula to make sure the date doesn't get converted to String The two tables joined successfully. But My chart doesn't let me Graph By - Month The Table format still shows as 'String' under the Date columns. What can I do maintain the dates as 'Date' format so that I can Group…
-
How to Remove Duplicate rows in analyzer?
I have used the LinkedIn connector to export the stats. I see duplicated rows. How do I avoid them?