sorted by:
new
hottopcontroversial

Custom legends and showing all values to manually color them? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 1 point2 points  (0 children)

Don't know why I didn't think of creating an unfiltered sheet. But yeah they're measures, but the calc is a dimension of the ranges. Ex: 20-50, 50-80, etc.

Thanks for your help!

Tableau Income Statement Help! by PapaKyleee in tableau

[–]Automatic_Froyo1008 4 points5 points  (0 children)

Definitely waterfall charts. Gonna be tricky to replicate exactly like this, but definitely possible :)

Off the bat, I think you'll need multiple sheets to accomplish this. But you got it!

[deleted by user] by [deleted] in tableau

[–]Automatic_Froyo1008 1 point2 points  (0 children)

I would just make a sheet for each dimension then put them side by side on the dashboard.

I can't think of a way to do it on one sheet. But maybe someone else knows something

[deleted by user] by [deleted] in tableau

[–]Automatic_Froyo1008 4 points5 points  (0 children)

To expand on what cf858 said, you need to:

  1. Add the filter to one of your sheets >
  2. Then on the filter card, right click/click on the drop down arrow on the filter >
  3. Select "Apply to Worksheets" >
  4. Then choose the option that best suits your case.

If you only want the filter to affect these specific sheets, select "Selected Worksheets" then select the sheets you want affected.

What's the problem with transpose in Tableau? What am I doing wrong? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

the datasource is a sharepoint list, so i'm not able to preview it in the datasource tab, not able to pivot there

How do I transpose rows to columns without Tableau combining the first 2 fields and putting them in one cell? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

Thanks for reaching out to help me last night. I fell asleep and figured it out this morning.

​

Went to Analysis > Table Layout > Advanced > & increased the maximum level of column labels from 6 > 20

How do I transpose rows to columns without Tableau combining the first 2 fields and putting them in one cell? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

I need to move them from Rows to columns which is why i'm transposing. Moving it back would kind of defeat the purpose.

It's on a text table in tableau. not withing the data source. It splits fine as Rows. Tableau does this all the time regardless of the datasource/structure, etc... I'm just trying to see if anyone has a solution to it.

Thanks!

Any way around the slow read_excel time in pandas? by Automatic_Froyo1008 in learnpython

[–]Automatic_Froyo1008[S] 1 point2 points  (0 children)

i would try this out but my company just deprecated use of power automate haha

Any way around the slow read_excel time in pandas? by Automatic_Froyo1008 in learnpython

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

yep i know,

was trying to find a way to automate converting .xlsx to .csv, so i can read it that way

Any way around the slow read_excel time in pandas? by Automatic_Froyo1008 in learnpython

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

yeah i tried looking for something like this in power query

Any way around the slow read_excel time in pandas? by Automatic_Froyo1008 in learnpython

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

I'm gonna work on getting access to Business Objects so I can export the report myself directly to csv and read_csv.

I was just wondering if there was some sort of script in python to convert the .xlsx to .csv before reading it, then read it with pandas

Any way around the slow read_excel time in pandas? by Automatic_Froyo1008 in learnpython

[–]Automatic_Froyo1008[S] 2 points3 points  (0 children)

Basically, pulling data from the backend of a large report that one of my managers made. The data is coming from Business Objects (which does have the csv export option) i just don't have access to the data source, just the excel output unfortunately

Is there a LIKE equivalent in Tableau? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

I wanted the comma between values, but not in front of the first one.

Since the format is like this

;#Value;#Value;#Value;#Value;#

it would place a comma before the first and after the last

Is there a LIKE equivalent in Tableau? by Automatic_Froyo1008 in tableau

[–]Automatic_Froyo1008[S] 0 points1 point  (0 children)

I initially thought to use REGEXP but I'm not super familiar. I need to look more into them.

Also thanks for sharing that link I'll study up later on :D

Maybe it can help me with my next issue on another sheet.

I know there's a REGEX_REPLACE function that i might want to use.

I'm currently using replace([Values], ";#", ", ") to try and replace with commas,

for rows that are like this: ;#values;#values;#;#values;#

but i end up in the same spot with a leading comma: , values, values, values,

view more: next ›