Coupler.io is a data analytics and automation platform that can help you with all your data-related needs. It allows you to easily access your data, understand it, and act on it. And this means you can turn your data into informed decisions that power business growth.
With Coupler.io’s tools and services, you can: - Export data automatically from 60+ different apps - Refresh your imported data on a schedule - Power your self-updating dashboards and reports with fresh data - Automate workflows and eliminate repetitive tasks - Leverage our data analytics expertise for advanced cases
Try Coupler.io for free with our 14-day trial (no credit card required): bit.ly/couplerio
When you have to many imports from google finance it shows N/A. If you're importing from a JAVA supported page it fails. It's all over the net. Google finance to google sheets is becoming unworkable and many sites are switching to java.
Hi! To remove subtotals in Google Sheets Pivot Tables: - Click on any cell in the pivot table. - In the Pivot Table Editor on the right, click the drop-down next to each row or column field. - Toggle off "Show subtotals". This should remove the subtotals from your pivot table.
Hi! Unfortunately, GOOGLEFINANCE doesn’t support futures like COLD directly. For futures data, you might need to rely on external sources or financial APIs and import the data into Google Sheets manually.
Hi! Unfortunately, the GOOGLEFINANCE function doesn’t provide RSI directly. To get RSI data, you’d need to use external financial APIs or manually calculate it in Google Sheets using price data from GOOGLEFINANCE. You could pull daily price data and then apply the RSI formula to calculate it yourself.
Hi! If you can't find the Explore tool, it might be because you’re using a version of Google Sheets that doesn’t support it (like in certain business accounts or older versions). Try checking the bottom right corner of your screen, as it sometimes shows up there as a small icon. If not, you could also try updating your browser or switching to a different one to see if that helps.
Hi! Add a pivot table as usual. Then, click on the icon next to your metric and from the Comparison calculation menu choose 'Percent of total'. If you want to have both the values and percentages in the table, add the metric again to the chart. Hope it helps!
Thank you very much for the detail explanation. I am amazed that there are so many ways to remove duplicates. I need sometime and practice to master the "SORTN, FILTER, and ROWS formula"
Thanks! Yeah, there are so many different ways to tackle duplicates indeed. Check also our article on this topic with plenty of practical examples, it may help you master all these functions blog.coupler.io/how-to-remove-duplicates-in-google-sheets/
Hi! If the row and column dimensions aren't aligning correctly, it might be due to the data type or formatting in your data source. Double-check that the fields you're using are correctly set as dimensions, and ensure there's no mismatch in data types (like mixing text with numbers). Also, make sure you've selected the right fields for rows and columns in your pivot table setup.
Hi! Sorry if it was a bit more advanced than you expected, but glad you stuck with it! 😅 Maybe you’re leveling up faster than you think. Thanks for watching!
Hi! Drill-down with dates in a pivot table requires that your date field is properly set up as a "Date" type in your data source. Additionally, ensure that your date hierarchy is configured correctly. To do this: - Check Date Type: In your data source, confirm that the date field is recognized as a "Date" type. - Create Date Hierarchy: If the default hierarchy isn't working, consider creating a custom date field that breaks down into Year, Quarter, Month, and Day. This helps the pivot table understand the drill-down structure. This should allow you to drill down effectively from broader to more specific time frames.
I also have permission to all of the files but It still doesn't work. It says #REF! You don't have permissions to acces that spreadsheet. learn more. Please help me
Sorry to hear you're having trouble! If you’re getting a #REF! error even with permission, try these steps: - Double-check permissions: Ensure you have "Viewer" or higher access to the linked sheet. - Re-authorize: Sometimes, re-adding the IMPORTRANGE function can prompt the authorization request again. Just enter the formula and allow access when prompted. - Try incognito mode: Sometimes, cache issues can interfere, so try it in an incognito window. If it still doesn’t work, there might be a permissions issue with the specific spreadsheet. Hope this helps!
Hi, I would like to know how to get the sum with (-) negative value ie. profit/loss let say "A2-total earn" - "A3+A4" are the expenses but expenses are higher than total earn. If I do SUM and MINUS formula it doesn't show the (-). Thanks and hope my question is easy to understand.
Thanks for your question! To calculate profit/loss with a negative value when expenses are higher than total earnings, try this formula: =A2 - (A3 + A4) This will subtract your total expenses from your earnings, and if expenses are higher, it will show a negative value (loss).
Well, in such a case, the setup heavily depends on the organization of the data you use. But it seems like you need to add 'keyword' to rows, possibly 'dates' to columns, and use 'rank' as a metric. I hope this will help or at least guide you in the right direction.
@@coupleracademy Step by step instruction to build the following SEO REPORT IN Google looker studio from the search console dataset CATEGORIZED Average position (LIKE BELOW AND COUNTS by each month
@@semponmanickam5924 We have a free SEO dashboard template. Maybe it will suit your needs www.coupler.io/marketing-dashboards/google-search-console-dashboard
You can change the canvas size by clicking on the background, then, to the right you click on the icon that looks like a paintbrush. Canvas settings, there, you can change size.
Hey hello, how can I use this formula with GOOGLEFINANCE? I tried using it once but it didn't yield the desired effect/result. Is there anyway I can work around current limitations?
Is it possible to use the query method dynamically whereby a column houses the imported URLs of all the sheets to be queried, rather than individually cutting and pasting each ID/URL into the formula? Thanks.
Hello! If I understand you right, you need to follow these steps: 1) List the URLs or IDs of the sheets you want to query in a separate column 2) create a formula with INDIRECT 3) construct the QUERY formula In other words, to query a specific range in a sheet dynamically, you'll need to combine QUERY with INDIRECT. Here’s a simplified example: =QUERY(INDIRECT("'" & A2 & "'!A1:B10"), "SELECT A, B WHERE B > 10")
@@coupleracademy Thanks so much for the reply!!! Maybe if I give a bit more info, it could clarify my situation. So, my situation is such that I have a running list of reports for a calendar year. By the end of the year, there are 400 or so reports. Within the reports, there is an equipment2 sheet that I am trying to query with a range from B4:E28, where the results can be either 1 row, or all 25, depending on how much equipment was used for that given incident (potentially no rows, if no equipment was used). I have a script that imports all the URLs from the reports into a tab/sheet that is called ReportURLs, in a master tracking worksheet. Column D houses the URLs. I'm looking to query ReportURLs!D2:D dynamically to pull out all the data from each of the equipment2 tabs/sheets in each of the reports. Will your suggested Query/Indirect solution work for this? Thanks!
@@markuswinter-cdps3008 To be honest, it's hard to provide you with a working solution this way but at least I'll try to :) So: 1) go to your ReportURLs sheet and in column E (next to your URLs in column D), enter the following formula in E2: =IF(D2="", "", IMPORTRANGE(D2, "equipment2!B4:E28")) 2) Create a new sheet, let's call it CombinedData and in cell A1 enter the following formula: =QUERY(ARRAYFORMULA(FLATTEN(ReportURLs!E2:E)), "SELECT * WHERE Col1 IS NOT NULL", 0)
Sure! Just create a free Coupler.io account and create a new importer with Salesforce as a data source and Looker Studio as a destination. The setup process is pretty intuitive, but you can book a demo with our specialist to guide you through l.rw.rw/book-a-demo-yt
If you liked this video, check our other tutorials to supercharge your Google Sheets experience 🚀 🔵SUM, SUMIF, and SUMIFS functions ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PzNglh81NAM.html 🔵conditional formatting basics ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oe4jYblXw8k.html 🔵ARRAYFORMULA basics ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DU6ZnIK92wM.html 🔵data validation basics ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ea_Gr6Uhons.html
@@coupleracademy no it says "you need permission, learn more" I am the owner of all of the files, but maybe because the google drive is managed by my employer?
@@WorkoutNerd3221 Google typically does not offer live chat support for general inquiries or customer support issues. However, if you are a Google Workspace (formerly G Suite) customers, there is an option for live chat support available through the Google Admin Console.
Hope everything's clear now but if not, check out other Google Sheets tutorials on our channel, we explain different Google Sheets functions and functionalities in detail. Take care!
Hi! It looks like there might be a syntax issue when using multiple LABEL statements with calculated columns. Ensure you have proper spacing and syntax. Here’s a corrected example: =QUERY(Invoices_Extracted_on_2024.07.21!A1:L, "SELECT Col"&XMATCH("INVOICE_ID",header)&", Col"&XMATCH("Date",header)&", Col"&XMATCH("Invoice#",header)&", Col"&XMATCH("Customer Name",header)&", Col"&XMATCH("Invoice Status",header)&", Col"&XMATCH("Due Date",header)&", Col"&XMATCH("Due Days",header)&", Col"&XMATCH("Sub Total",header)&", Col"&XMATCH("Invoice Amount",header)&" - Col"&XMATCH("Sub Total",header)&", Col"&XMATCH("Invoice Amount",header)&", Col"&XMATCH("Balance",header)&" - Col"&XMATCH("Invoice Amount",header)&", Col"&XMATCH("Balance",header)&", Col"&XMATCH("Adjustment",header)&", Col"&XMATCH("Created By",header)&" LABEL Col"&XMATCH("Invoice Amount",header)&" - Col"&XMATCH("Sub Total",header)&" 'Discount', Col"&XMATCH("Balance",header)&" - Col"&XMATCH("Invoice Amount",header)&" 'Paid sum'") The key is to ensure each LABEL is correctly associated with its column, and there’s proper spacing and punctuation.