#Tableau39 人正在讨论

Hi, @SSMK A

I may still not fully understand what you’re trying to achieve, but are the values shown in the Sample diagram what you’re referring to? 

For checking purposes, I’ve displayed each value as well. 

Since the processing is done with an LOD calculation, please be aware that if you need any filter operations, you’ll have to use a Context Filter. 

<sample>

<calc>

@Kasumi Kikugawa unfortunately you will be constrained / limited by an internal character limit in Tableau.  Depending on the data source it is 255 to 1024 characters maximum.  There may be a workaround to extend that using a solution from Interworks: https://interworks.com/blog/tmccullough/2013/12/20/displaying-long-text-fields-tableau-excel or changing the DB/SQL Server type to a larger value: https://furtherrandomthunks.wordpress.com/2012/12/13/tableau-and-the-1k-string-limiting-with-sql-server/

Another option might be in the Tableau Exchange Gallery, using a Write Back extension in the dashboard.  There are several, but you'll need to explore with each developer as to any constraints or limitations:

  Those are probably your better options. 

Ref:

If this response answered your question, please mark it as an Accepted Answer? 

This way, others searching for similar solutions will find the answer faster in the future.

Best, Don Wise (Tableau Ambassador)

In CRM Analytics you do not actually 'connect' separate dashboards, the pattern is to build ONE dashboard and use Global Filters to slice it by region/object/etc. How you get there depends on whether your regional dashboards sit on the same dataset or different ones: 

If they are all on the same dataset (the easy case): 

Create a single new dashboard on that dataset, add the charts/widgets you want, then add Global Filters (the filter panel in the dashboard editor) on Region, Object, and any other fields. Widgets built on the same dataset facet together automatically, so one Region selection filters everything at once. That gives you the 'one global dashboard, filter by region' behaviour you are describing. 

If each region is a separate dataset: 

You first need them in one dataset, otherwise a single Region filter has nothing common to filter on. Use a Recipe (Data Prep) to UNION the regional datasets into one combined dataset, and if a 'Region' column is not already on each, add it in the recipe so every row is tagged with its region. Then build your single dashboard on that combined dataset and add the Global Filters as above. Since you tagged Dataset Recipe, this is likely your path. 

A couple of pointers: 

- Global Filters live in the dashboard's filter panel and apply to every widget bound to that dataset, pin them so they persist. 

- If you keep widgets from more than one dataset in the same dashboard they will not auto-facet, you connect them with bindings, or cleaner, unify into one dataset via the recipe so faceting just works. 

Net: do not try to link the existing dashboards, rebuild as one dashboard on a single (recipe-combined, if needed) dataset, then Global Filters give you the region/object slicing. 

If this helps, please mark it as the Best Answer so it helps the next person. Thanks :)

Hi Vaibhav, 

You won't need to touch all 200 devices individually. You'd configure the Tableau MCP connection once, centrally, and push it out to devices via your org's device-management solution. Each user still authenticates to Tableau individually, so they'll only see the content they're already authorized for. 

Also, for Tableau Cloud, Tableau is moving to a hosted Tableau MCP — no self-hosting or maintaining a server on your end. It uses OAuth 2.1 and is built for enterprise-scale deployment. 

So the flow becomes: 

Admin → Central MCP configuration → Claude users → OAuth → Tableau Cloud 

Not 200 separate setups — one centralized config, with individual auth and permissions still intact. 

Regards 

Rajneesh 

You can do the Union in your first Custom SQL script itself as shown below 

SELECT A,B,C 

FROM XYZ 

WHERE Condition1  

UNION ALL 

SELECT A,B,C 

FROM XYZ 

WHERE Condition2 

UNION ALL 

SELECT A,B,C 

FROM XYZ 

WHERE Condition3  

Hi,  @SSMK A 

Are you looking for something like the attached example?  

Please take a look. I set up the headers using a dual‑axis. 

<sample>

<sheet settings> 

use dual axis (for header).

This can be done by creating the below calculation, using LOOKUP() function:For now, both July and August are in the view just so you can see that July's data for Quantity now lives in August's 'date', as shown above.  But, we don't want to have to select two month's data at a time and yet, two month's of data MUST be in the view. somehow. 

So, we then change the Order Date filter that you originally had into again, a Relative Date filter, again displaying only most recent two months, as I did before:

Then, the question remains, how to show just the current month, but only with last month's data in the current month.  Again, another filter.  BTW, both of these are Table Calculations, so certain fields must be in the view somewhere in order for them to all function correctly and display correctly.  The new calculation will now filter the above result to only the last row in the view:

As to it being automatic and adjusting for next month, it should based on the Relative Date filter..it would automatically adjust to September and pick up August's data. And so on. 

If this response answered your question, please mark it as an Accepted Answer? 

This way, others searching for similar solutions will find the answer faster in the future.

Best, Don Wise (Tableau Ambassador)