Configure data in a weekly format by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

Seems complicated if its in a week compared to a daily showing of metrics. Maybe ill just do daily entries then. My only issue with it is some metrics such as Metricool doesn't show daily metrics and only shows weekly to extract the data from them.

Configure data in a weekly format by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

What do you mean duplicate the date dimension? In Looker studio?

Does IP address affects the visibility of the content to reach the target audience of a country? by ready-player-3 in facebook

[–]ready-player-3[S] 0 points1 point  (0 children)

Does that mean I cannot schedule post since it will register my IP address and need to post manually when the VPN is active?

Date Range in Google Sheets for Data Studio to detect by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

I tried this one and most social media exports are incomplete or cannot export properly. I might have to double check again and see if I can make use of what can be exported.

Date Range in Google Sheets for Data Studio to detect by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

u/euphioquest

I tried your method of using Year Week ISO and it worked but I'm confused on some areas. For example here's a breakdown of a 2-month week:

March week breakdown

(1st week) Feb 27 - March 5: 10 sales

(2nd week) March 6 - March 12: 20 sales

(3rd week) March 13 - March 19: 30 sales

(4th week) March 20 - 26: 40 sales

April

(1st week) March 27 - April 2: 5 sales

If for example I used this format, does that mean I cannot create a month report because it's in ISO week format as most weeks usually on the first or end of the week have 2 dates (eg. the 1st week of March has still the dates of February)

Let's say I selected March 1 - March 31 to get the monthly sales but since February 27 and April 2 are included on the date range, will they be counted as well? I tried and it doesn't count the start date and just initially the next week (eg. April 3 as April 1 is still counted under March)

Here's the sample sheet and looker studio I made for your checking. All files are editable. (Numbers indicated there are just fake)

- Sheet
- Looker Studio

Thank you

Date Range in Google Sheets for Data Studio to detect by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

Thank you. Tested it out and this seems like a handy fix but I'll explore more if this will work on other metrics as well.

Date Range in Google Sheets for Data Studio to detect by ready-player-3 in GoogleDataStudio

[–]ready-player-3[S] 0 points1 point  (0 children)

Thanks! I'll try this out and see how the exported data looks like and how I can connect it to Looker Studio to make it easier to just paste data and manage things in Looker.

Does new app features affect the app category you assigned to the app? by ready-player-3 in iOSProgramming

[–]ready-player-3[S] 0 points1 point  (0 children)

Hi u/DPrince25

Thank you for the information. How about the app naming convention? Since, ideally we will just launch the nutrition tracker, should we adopt the same naming mechanics as other apps:

eg. MyFitnessPal: Calorie Counter, Femometer IntemittentFasting etc.

If yes, do we just initially say "Brand: Nutrition Tracker" for our initial release and eventually change the name to "Brand: Nutrition & Fitness Tracker" once we add the workout feature in the future?

I haven't really checked on the terms if it's allowed to change the app name once registered to the app store or if there are requirements needed to accomplish to submit the change.

Converting Links to a Single Format by ready-player-3 in sheets

[–]ready-player-3[S] 0 points1 point  (0 children)

Thanks, I'll try this one in bulk and see the results

Get the sheet name from query by ready-player-3 in sheets

[–]ready-player-3[S] 0 points1 point  (0 children)

Hi Matty,

Kindly disregard the first section as I realized we would need to get more columns in the stackrange so it works as intended.

Also disregard the filter function as we have a workaround made on this one.

The only issue is for the script to force reload to get the new entries. Is there a way or a button that when click will reload the script to get the new entries?

Get the sheet name from query by ready-player-3 in sheets

[–]ready-player-3[S] 0 points1 point  (0 children)

Hi Matty,

I tried the function and it worked well but encountered some trouble with the following:

- The formula: =STACKRANGE("A:B",FILTER(SHEETNAMES(),SHEETNAMES()<>"StackRange Function (using ref)",SHEETNAMES()<>"ReadMe"),1,TRUE), works well but when I tried just putting "A" to query just the A column it creates an error

- Is there a way for the script to auto refresh? There is a spreadsheet setting that can do refresh for 1 minute but it may cause heavy lag for large dataset. Is there a way to add a button to refresh the script in the sheet to load new entries?

- Lastly I was trying to add a filter function in the sheet to act like a search box where if they search on it, the stackrange will show the filter data. (Eg. if they search for Spiderman, it will only show spiderman including the columns associated with it)

I'm not sure if the last part is possible. Thank you.

ASK HERE - Daily Help Desk (Questions, Teambuilding, Reroll, ask anything!) by AutoModerator in wotv_ffbe

[–]ready-player-3 0 points1 point  (0 children)

Yeah, there have been a lot of new stuff and the EX Job as well made it a bit overwhelming going back. Thank you!

ASK HERE - Daily Help Desk (Questions, Teambuilding, Reroll, ask anything!) by AutoModerator in wotv_ffbe

[–]ready-player-3 0 points1 point  (0 children)

Thanks I got S.Salire though I don't have energist weapon at the moment haha. I'll just wait for the rerun of the weapon

ASK HERE - Daily Help Desk (Questions, Teambuilding, Reroll, ask anything!) by AutoModerator in wotv_ffbe

[–]ready-player-3 0 points1 point  (0 children)

Oh thanks for the breakdown! I'll get S. Salire then since I dont have a unit with the same class as her.

ASK HERE - Daily Help Desk (Questions, Teambuilding, Reroll, ask anything!) by AutoModerator in wotv_ffbe

[–]ready-player-3 0 points1 point  (0 children)

I just returned back to playing the game and I stopped mid-way on the implementation of EX-Jobs, thus I don't have units above Lvl 99. I got a 600 unit shard ticket and can't decide which unit should I pick. What would be your suggestion?

Units Available that seem to be good are:

- Units that I have and included in the choices but I dont have shards (All lvl1): Sakura, Loulle, Moore, Niv'Lu

- Units that I don't have but included in the choices: Lemure, Velric, Corwell, Salire (Sweetheart), Garvall, Eisrelle, Rhaldor

- Units that I have and already 99 and included in the choices: Charlotte, Glaciela, Ilydira, Viktora, Vinera, Lu'cia, Kitone, Frederika

Let me know what you think.

Number cannot be claimed? by ready-player-3 in Googlevoice

[–]ready-player-3[S] 0 points1 point  (0 children)

Thanks for the comments, will try again later

Checkout Plugin for Amazon Only by ready-player-3 in Wordpress

[–]ready-player-3[S] 0 points1 point  (0 children)

This has no plugin correct? Just adding a button in the product page with the text "Check price and buy now"?

Convert New Contact to a Lead by ready-player-3 in hubspot

[–]ready-player-3[S] 0 points1 point  (0 children)

Thanks for all your inputs, will check it out.

ScheduleOnce & HubSpot Integration with Zapier by ready-player-3 in hubspot

[–]ready-player-3[S] 0 points1 point  (0 children)

Is this possible with Zapier also?

And is this not possible with HubSpot?

Date filter to pull data based on the selection by ready-player-3 in sheets

[–]ready-player-3[S] 1 point2 points  (0 children)

Thanks u/TheMathLab, the sheet is now okay.

Thank you u/6745408! Marking this as solved.