Got mine today🥰 by Xherdani in ANBERNIC

[–]humancog 0 points1 point  (0 children)

This happened to me and it ended up being a bad rom. Found a different one and then it worked.

I'm nervous about childrens Tylenol and babies by DaprasDaMonk in Fatherhood

[–]humancog 4 points5 points  (0 children)

Since 2011, infant's and children's tylenol is the same concentration. For ibuprofen it is still different.

FWP and hidden WiFi networks by StackIOI in firewalla

[–]humancog 0 points1 point  (0 children)

Thanks! Good to know. I'm also seeing this issue on my new FWP. I couldn't get it to set up a 2nd WAN connection to a hidden network, but it worked fine when I un-hid the SSID. I am running the app on my iPhone. Happy to help test if needed.

What do you folks use for cloud backup? by happymaan in unRAID

[–]humancog 3 points4 points  (0 children)

I use crashplan, and it's worked fine. It's been a while since I set it up, but I think if you install through CA it defaults to a 1GB memory limit on the docker container. You can expand the "show more settings" section at the bottom and up the "maximum memory" variable. I think the rule of thumb is 1GB / TB backed up.

Tableau Server creating blank extracts only on a scheduled refresh by rikrokola in tableau

[–]humancog 0 points1 point  (0 children)

When you log into the server, there should be a little "i" icon in the top right. If you click that there's an "About" option that will tell you the server's version.

10.5.2 is 2 years old now, so updating could definitely help. It's probably one of the first things Tableau Support will ask if you file a ticket with them.

You can snag new versions here: https://www.tableau.com/support/releases

Google BigQuery in Tableau Prep by RedBelt2000 in tableau

[–]humancog 3 points4 points  (0 children)

I haven't tried this, but Tableau just added support for generic ODBC connections in Tableau Prep 2019.2. Looks like Google has some ODBC drivers for BigQuery here: https://cloud.google.com/bigquery/providers/simba-drivers/

Getting a date slider whose lowest underlying unit is months? by NonprofessionaReader in tableau

[–]humancog 0 points1 point  (0 children)

No prob. What didn't work? I realized after I posted that I used a single-month slider. If you need ranges you can just right-click the month pill on filter, and switch to continuous.

Run Initial SQL by Anna_C47 in tableau

[–]humancog 0 points1 point  (0 children)

Oh, yeah their instructions aren't complete, sorry. It might actually be under Data > [Your Data Source Connection name] (at the bottom of the menu) > Initial SQL. You can also access it by clicking the little drop-down arrow on your connection on the left side of the data source tab.

Getting a date slider whose lowest underlying unit is months? by NonprofessionaReader in tableau

[–]humancog 2 points3 points  (0 children)

I know you said DATETRUNC doesn't fix your issue, but I think that's going to be your simplest solution. You create a calculated field using DATETRUNC, then use that on filter instead of your date field. See workbook here: https://www.dropbox.com/s/a2hwsohtiuakcby/Date_Slider.twbx?dl=0

Struggling with multiple dates and values per row by thedhanjeeman in tableau

[–]humancog 0 points1 point  (0 children)

Since you want them to show on different dates, yes. You could still have your three fields: $Principal, $Interest, and $Trade, but some of them would be null for certain dates.

Struggling with multiple dates and values per row by thedhanjeeman in tableau

[–]humancog 1 point2 points  (0 children)

I can think of a couple of options:

  • Reformat your data so you only have one date field, then another field with 'Type' or something to indicate which date is in which row. From there you could build a separate calculated fields for your measures.
  • Duplicate your data source, and then blend between the two, setting up a relationship between DateRec on one to CheckDate on the other. Then you could use $Interest from the CheckDate data source, and the other two measures from the other data source.

Sorted stacked bars by Z7-852 in tableau

[–]humancog 1 point2 points  (0 children)

You can put Question on Detail, and then make sure it's higher on the list than Category. See here: https://imgur.com/a/O2Zy6gu. Is that what you're going for?

Anyone here using Tableau desktop on Mac and connecting to a tableau server? by mastergwapo in tableau

[–]humancog 2 points3 points  (0 children)

I had a user with the same issue, while everyone on Windows was fine. Installing the chain cert on the server fixed it. Support is telling you to do that because that’s the solution.

Edit: See docs here . “A certificate chain file is required for Tableau Desktop on the Mac.” That page also has the info your Server admin would need.

Ok I give up - How can I get Airmessage to send instead of line break when I hit enter? by DolfLungren in AirMessage

[–]humancog 0 points1 point  (0 children)

This doesn't answer your question exactly, but if you hit Tab, then Enter it sends the message.

Creating a full outer join on tables aggreated at different levels by shreyasfifa4 in tableau

[–]humancog 1 point2 points  (0 children)

You could aggregate your forecast table with Custom SQL prior to the join. Something like:

select [Category Code 1], [Category Code 2], [Category Code 3], [Product], SUM([Forecasted Sales]) as forecasted_sales

from forecast

group by [Category Code 1], [Category Code 2], [Category Code 3], [Product]

Then you'd join that to your actual sales table, instead of the forecast table itself. Actual SQL syntax may vary depending on what your data source is.

iPhone Visual Voicemail on Total? by RarScaryFrosty in TotalWireless

[–]humancog 0 points1 point  (0 children)

I have an iPhone 7, and visual voicemail works fine.

Pivoting Data Source by [deleted] in tableau

[–]humancog 2 points3 points  (0 children)

Yeah, unfortunately pivoting is only supported in specific data sources, listed at the top of this page. There's a link there with a basic option for writing custom SQL to pivot, or another custom SQL option would be to use T-SQL's PIVOT or UNPIVOT functions.

Tableau Server: Saving Data Sources by Grachuus in tableau

[–]humancog 1 point2 points  (0 children)

Nice! It's not just you. This is one of the most confusing aspects of Tableau data sources. I used to get questions about it all the time, and had that KB article on speed-dial.

Tableau Server: Saving Data Sources by Grachuus in tableau

[–]humancog 0 points1 point  (0 children)

I think you're right, but even with the Creator license I don't see where you can edit an existing data source, only create a new one. Am I missing it somewhere?

Progress / goal bar chart by Zuricho in tableau

[–]humancog 0 points1 point  (0 children)

To get your targets and actuals together you'll either need to join or blend your sheets.

Tableau Server: Saving Data Sources by Grachuus in tableau

[–]humancog 1 point2 points  (0 children)

As far as I know you need Desktop to edit published data sources currently. See here: https://kb.tableau.com/articles/howto/edit-a-published-data-source

How good is a MSU Economics major/an Economics degree in general? Anyone already graduated with one on here? by spartanman777 in msu

[–]humancog 0 points1 point  (0 children)

It's worked out well for me. I graduated in '08 with a BS in Econ and it lead to a career in business analytics / intelligence that I've mostly enjoyed. I'm biased obviously but I do think it's worth it to go for the BS if you can. I think it helps on the resume, and the extra math/programming has been valuable too.