Google Data Studio GDS Looker
I am a task that we don’t know how to solve.
I have a list of projects with the following fields:idstartDateendDateNameStatus109/23/202210/23/2022Project 1Close209/23/2022
Project 2Active309/23/202201/24/2023Project 3Close401/24/202301/27/2023Project 4Close501/24/2023
Project 5Active601/30/2023
Project 6Active And I want to get all the projects that were active in the previous week. For example, DATE RANGE control 01/23/2023 - 01/29/2023.
Project 2, Project 3, Project 4, Project 5
How to use Google Data Studio (Looker)?
Thank you in advance
I don’t imagine how to do this in GDS, as the net date range works only with one line of data.
Всім привіт
Я задача, яку поки не знаємо як вирішити
| id | startDate | endDate | Name | Status |
|---|---|---|---|---|
| 1 | 09/23/2022 | 10/23/2022 | Project 1 | Close |
| 2 | 09/23/2022 | Project 2 | Active | |
| 3 | 09/23/2022 | 01/24/2023 | Project 3 | Close |
| 4 | 01/24/2023 | 01/27/2023 | Project 4 | Close |
| 5 | 01/24/2023 | Project 5 | Active | |
| 6 | 01/30/2023 | Project 6 | Active |
І я хочу отримати всі проекти, які були активними на попередньому тижні. Наприклад, DATE RANGE контрол 01/23/2023 - 01/29/2023.
Правильна відповіль: Project 2, Project 3, Project 4, Project 5
Як це реалізувати в Google Data Studio (Looker)?
Дякую заздалегідь
Я не уявляю, як це зробити в GDS, оскільки діапазон дат нейтівний працює тільки з одним рядком данних
-
14 days145 USD
1166 5 0 14 days145 USD
Доброго дня. Можу реалізувати це в Power BI якщо вам підійде. Це дуже гнучкий інструмент. Набагато кращий ніж GDS. Проте коштує 10$ в міс
Робив дашборд на ms project для великої державної структури
Current freelance projects in the category Web Programming
Project workspace for edits in Opencart 3
27 USD
Now you need to hold the screen to scroll down and the option to translate the page will appear https://prnt.sc/3qe4pyKzM10v https://prnt.sc/cTssYXE-zORO It is necessary to fix so that the language translation is complicated Content Management Systems, Web Programming ∙ 17 seconds ago |
Refine the payment system in Tutor LMS (Wordpress)
48 USD
It is necessary to redo the default manual payment method on Tutor LMS, all payment system data must be in the settings. The settings should include: 1. Title for the checkout page 2. Description for the checkout page 3. Private key 4. Merchant ID 5. Additional fields that are… PHP, Web Programming ∙ 16 minutes ago ∙ 1 proposal |
Redesign and adaptation of the "AIScreen Digital Signage Platform" page
53 USD
Task:We are looking for an experienced frontend developer to redesign the existing page "AIScreen Digital Signage Platform". The task involves adapting the page blocks to the new design and integrating content, strictly following the provided layouts and… HTML & CSS, Web Programming ∙ 6 hours 21 minutes ago ∙ 2 proposals |
Template and layout, configuration of the online store on OpenCart 4.1.0.3
17 USD
I am looking for a diligent person who has experience working with OpenCart. It is necessary to find and select a template for an online store, the theme - Auto parts for trucks, and install it. OpenCart is installed on the hosting, I am waiting for collaboration proposals. The… Content Management Systems, Web Programming ∙ 11 hours 42 minutes ago ∙ 10 proposals |
Base linker
292 USD
Hello, I have one store on Allegro with 40 products ( products with a few variants ) , where there is a mess. I opened a second company also selling on Allegro and I am looking for someone who can properly configure the new store to avoid duplicating the mess. I use Base linker… Databases & SQL, Web Programming ∙ 11 hours 49 minutes ago ∙ 4 proposals |
Cherkassy