This page has an error. You might just need to refresh it.
Unable to find an action for 1323;a: {"id":"1323;a","state":"SUCCESS","returnValue":{"componentDef":{"descriptor":"markup://forceChatter:highlightingScriptWrapper"},"creationPath":"/*[0]"},"error":[]}
Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation.”
I have 3 sources as .csv files- I use them as extract in Tableau Desktop.
Source1
Date Segment Savings
1/1/2024 S1 100
2/1/2024 S2 150
3/1/2024 S3 170
4/1/2024 S1 200
5/1/2024 S2 250
6/1/2024 S3 260
7/1/2024 S1 300
8/1/2024 S2 340
9/1/2024 S1 510
10/1/2024 S2 180
11/1/2024 S2 175
12/1/2024 S3 165
Source2
DATEGbp to Usd
1/1/2024 1.12
2/1/2024 1.15
3/1/2024 0.73
4/1/2024 1.16
5/1/2024 1.02
6/1/2024 0.98
7/1/2024 1.13
8/1/2024 1.45
9/1/2024 1.67
10/1/2024 1.78
11/1/2024 1.54
12/1/2024 0.99
I am joining Source 1 and Source2 on date and multiplying Savings with GBp to USD to get rates for each month. I am using AGG(Savings) function on Dashboard.
Now , I want to provide user access filter based on Manager so i want to use another source -
Manager Segment
M1 S1
M1 S2
M2 S1
M3 S1
M3 S2
M3 S3
M4 S2
M5 S3
I am joining Source1 and Source3 on Segment and creating a user access filter where username() = Manager, All the functions are working fine except the AGG(Savings) which is giving me above error. Is there a way i can resolve this? Thank you.
Why is my Trend Line the same color as my Line Chart?
Hi, I added a trend line one of my line charts in a dual axis line chart. I noticed that changing the color of the trend line on the format pane doesn't have an effect and that changing the color of the line chart will always change the trend line to the same color.I want my trend line to have a different color in order to stand out.
Hi, (right clic on the trend line, edit trend lines):
Uncheck "allow a trend line per color"
Also, probably the opacity percentage will make it look like gray, but if you move the opacity and style a little more, you will find the color is there:
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
How to sort on parameter selection /calculated field - % ?
Hi everyone,
I have a dashboard that uses param/calc to sort different columns. However, when I use var % in the sort calculation, I get an error stating that it 'cannot mix aggregate and non-aggregate functions'. Can anyone pls suggest how to fix this?
As it says in the error message, you need your outputs to all be of the same level (of aggregation). For a table sort calculation, you want the values to be at the level of detail of the table, where you're trying to calculate things at the underlying row level of detail (which would not give you the correct answer for your % variance values, because it would calculated the ratio for each row of data, then add all of them up). Change your calculation to use all aggregates:
case [Sort Param] when 'Sales' then SUM([Sales]) when 'Profit' then SUM([Profit]) when 'Sales Profit Var' then SUM([Sales Profit Var]) when 'Sales Profit Var %' then ([Sales Profit Var %]) end
Need Help Changing Email on Tableau Public – Stuck in a Loop!
Hi DataFam,
I need some help changing the email address on my Tableau Public account. I originally registered with my school email seven years ago, but the school has since discontinued it. You’d think this would be straightforward, but when I tried updating it, I kept getting redirected to a page claiming my account is a Tableau Cloud email. (https://help.salesforce.com/s/articleView?id=001458204&type=1)
I reached out to the Tableau Cloud team, but they told me my account isn’t associated with any Cloud instance (email attached). I’ve been bounced around between three Tableau teams (Operations, Public, and Cloud), and now no one is responding to help me update my email.
I’m really frustrated and worried I might lose access to my Tableau Public account, where all my visualizations are stored. Has anyone faced a similar issue or found a way to resolve it? Any advice would be greatly appreciated!
Hi, right clic on the green pill, and check show header:
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Troubleshooting dashboard. I had published a dashboard last year, but due to unknown reasons, the layout is appearing incorrectly. I tried republishing it but to no effect. What could be wrong?
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.