8 Replies Latest reply on Jan 21, 2019 10:42 PM by christian winoto

Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

christian winoto Jan 20, 2019 11:46 PM

Hi Everyone

I have a problem with dashboard filter action.

So, in the dashboard1 I have 2 sheet source and destination. I want to make the destination sheet show 2 line, first is 'C' and the other want is anything that user choose in the source sheet. Example, if the user choose 'A' in the source sheet, so the destination sheet will show 'A' and 'C'. If user choose 'D' in the source sheet, the destination sheet will show 'C' and 'D'

Right now, the destination sheet will always show only value that user choose from source sheet.

Can anyone help to solved this problem?

I also attached the workbook to try it by yourself

Thank you

sample.twbx 43.5 KB

1. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

Shinichiro Murakami Jan 21, 2019 12:19 AM (in response to christian winoto)
To plot multiple scatter, you need to multiply the data set itself.

Thanks,
Shin

sample_multiple_scatter_SM_10.4.twbx 43.4 KB
Like Show 0 Likes(0)

Actions
2. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

christian winoto Jan 21, 2019 12:45 AM (in response to Shinichiro Murakami)

Thank you Shinichiro, that's what I want
But, do you have another way to do this without multiplying the source data?
Because if the data already big let say like 2 million record, so I need to multiply it to become 4 million record right? I'm afraid it will make the impact to the dashboard and the database performance
Like Show 0 Likes(0)

Actions
3. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

Shinichiro Murakami Jan 21, 2019 10:39 AM (in response to christian winoto)

so I need to multiply it to become 4 million record right?

Theoretically, yes. But other workaround requires more query resource and this is simplest I believe.
Actually 4 million is not significantly huge for Hyper in standard case.
You can try extract data and see how performance look like.

Publish a Data Source - Tableau

Thanks,
Shin
Like Show 0 Likes(0)

Actions
4. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

christian winoto Jan 21, 2019 8:23 PM (in response to Shinichiro Murakami)

I see. Thank you Shin for your help
I will try it to my real case

Best Regards
Chris
Like Show 0 Likes(0)

Actions
5. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

Shinichiro Murakami Jan 21, 2019 8:40 PM (in response to christian winoto)

Hi Chris,

You are welcome.

Shin
Like Show 0 Likes(0)

Actions
6. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

christian winoto Jan 21, 2019 9:33 PM (in response to Shinichiro Murakami)

Hi Shin,
Sorry, I have another question regarding the output from your result

I'm using your twbx result and as you can see from the picture, the left side that I circled have the same value. Why the they have a gap?
Because in my opinion, the point should be on the same place
Like Show 0 Likes(0)

Actions
7. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

Shinichiro Murakami Jan 21, 2019 10:01 PM (in response to christian winoto)

I don't know what is the filed of "score"..
That field is not used at all as calculations.

If you put them as attr , it shows some attribute, but I on't know what that means. .

Thanks,
Shin
Like Show 0 Likes(0)

Actions
8. Re: Show 1 Fixed Dimension that Cannot be Changed by Dashboard Action

christian winoto Jan 21, 2019 10:42 PM (in response to Shinichiro Murakami)

Hi Shin,
so the score used to show the value of each point of the chart. In my case, there are 6 points. I think you just need to convert it into measure and use sum aggregation.

Thanks,
Chris
Like Show 0 Likes(0)

Actions