So if i understand the question right, you need to filter out the '*' character from the data set and the filter. I have a workaround for this. I have attached the workbook also for your reference. Please let me know if this helps.
public wagon data.twbx 21.3 KB
Unfortunately, neither solution really applies, As the problem I have is the "*" character is not visible in the filter options, so there is nothing to select to exclude it from the view. The "*" Character seemed to be visible after I copied the data across to create the anonymous data.
Here is another workbook with actual data showing the issue. I would like to remove the data points that have a "*" for any field.
@Deepak Rai, Rashmi Sudhakar
public wagon data2.twbx 18.4 KB
Please extract your data. This file can't be opened.
I am not able to open your file coz my licence is expired . I tried your scenario in tableau public with excel sample data,
Following is the sample data
R1 R2 R3 abc * ttyy xcv sds * dfg dsd * ert fgt fgh tyu rtt tyu
After that I create one calculated field chk as:
Chk : [R2]<>'*'
and set as a filter at data source level:
It does filter out my data for that R2 Column
Try this one. This may help you
First of all , if you are setting filter at data level then records with '*' Shouldn't be in the sheet.
you need to apply filter at data source level. Try it and let me know.
What I understood from the tableau workbook, you are using ATTR in the tooltip.
Since there are multiple values in Class(Vehicle) for each "Origin" and "Planned Destination" dimension it would result in a *.
This * is different from the * present in data.
Check screenshot for refernce:
You can not show all values in a tooltip if there are multiple values to show. You have to think of work arounds for this. Else you might consider to show any measures such as number of Class(Vehicles)s instead of showing name. Please clarify your requirement
1 of 1 people found this helpful
Hej Beau! The * has nothing to do with Data Source but ATTR (Attribute) in Tableau
Attribute aggregation has several uses:
- It can ensure a consistent level of detail when blending multiple data sources.
- It can provide a way to aggregate dimensions when computing table calculations, which require an aggregate expression.
- It can improve query performance because it is computed locally.
Tableau computes Attribute using the following formula:
IF MIN([dimension]) = MAX([dimension]) THEN MIN([dimension]) ELSE “*” END
So the values are there . You do not need the bright spark in your IT department to fix that