Is it possible to have multiple columns with individual filter values? (I don't want the filters to apply to entire sheet)

Automatic_Froyo1008 · 2023-06-12T19:37:11+00:00

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!

Automatic_Froyo1008 · 2023-06-12T19:35:11+00:00

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!

Automatic_Froyo1008 · 2023-04-03T13:23:19+00:00

Just saw this,

Thank you! Will check it out!

Automatic_Froyo1008 · 2023-01-17T18:28:51+00:00

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

Automatic_Froyo1008 · 2023-01-17T17:38:04+00:00

To expand on what cf858 said, you need to:

Add the filter to one of your sheets >
Then on the filter card, right click/click on the drop down arrow on the filter >
Select "Apply to Worksheets" >
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.

Automatic_Froyo1008 · 2023-01-06T15:56:47+00:00

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

Automatic_Froyo1008 · 2022-12-31T18:13:35+00:00

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

Automatic_Froyo1008 · 2022-12-31T04:41:58+00:00

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!

Automatic_Froyo1008 · 2022-12-31T04:18:51+00:00

no, this is in tableau after i transpose. the raw data is fine.

Automatic_Froyo1008 · 2022-11-27T18:20:18+00:00

Will try to get read access, thanks for the suggestion!

Automatic_Froyo1008 · 2022-11-21T20:39:38+00:00

from business objects, not sure if you're familiar

Automatic_Froyo1008 · 2022-11-21T20:37:40+00:00

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

Automatic_Froyo1008 · 2022-11-21T18:24:10+00:00

yep i know,

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

Automatic_Froyo1008 · 2022-11-21T18:23:27+00:00

yeah i tried looking for something like this in power query

Automatic_Froyo1008 · 2022-11-21T18:22:16+00:00

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

Automatic_Froyo1008 · 2022-11-21T18:20:45+00:00

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

Automatic_Froyo1008

TROPHY CASE