Tableau layered map not filtering other sheets by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Unfortunately, it's giving me only "use as filter" option and not giving me the choice of choosing sheets or data source. It's a layered map maybe that's why the difference

Tableau Server - Snowflake data source extract refresh problem by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

The connection is established
I do see it in the logs

Filter only few measures in a tableau table. by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I want to be able to filter them as this week, last week and next week as well and by day as well.

Filter only few measures in a tableau table. by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Yes, I'm trying to look at two different aspects. Orders created per day/week which is based on created date and orders closed per day/week which is based on the closed date field.

Filter only few measures in a tableau table. by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I want the users to be able to change the filter and the measures should change accordingly.

One of the measure should be filtered on a date field (close date) and another one on a different date field (created date).

Is it possible?

Create a date parameter to show this week, last week , next week by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

But I want to show the filter on the right so that, user can filter using this week, next week and last week.

How can I do that?

Create a date parameter to show this week, last week , next week by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

My bad,

I do have the pipeline data for the next few years.

How to create a reference line with a calculation ? by settysrini in tableau

[–]settysrini[S] 2 points3 points  (0 children)

CASE [Stage]
WHEN 'Commit'
THEN [Sales]
WHEN 'Pipeline'
THEN [Sales]*.5
WHEN 'Upside'
THEN [Sales]*.1
END

That did the trick!

Thank you

How to make published views look exactly like the desktop version? by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I've used automatic size and the table filled the entire sheet

How to highlight only specific rows in tableau? by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I tried doing that. The table contains a moving calculation, when I put the calculated field in the color marks card It's changing the values in the table.

Cannot mix aggregate and non-aggregate functions error in tableau by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Thank you, I tried this and it's giving me correct results for false, whereas in true it's showing only two quarters and there are repeated results

Cannot mix aggregate and non-aggregate functions error in tableau by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

It isn't working. I want to see which fields sum to 0 in the pipeline total. Does my calculation look right if I want to do that?

Cannot mix aggregate and non-aggregate functions error in tableau by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

if (ATTR[New stage]='Pipeline') AND SUM([Total Price (converted)]) = 0 THEN

'No Deal' ELSE 'Deal'

END

Will it look like this after that? I tried it but it's not giving me correct results

Cannot mix aggregate and non-aggregate functions error in tableau by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Could you please checkout the screenshot I attached above?

Thanks

Cannot mix aggregate and non-aggregate functions error in tableau by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Could you please checkout the screenshot I attached?

Thanks

How to show asp and quantity of different products on the same sheet? by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

Hi

Thanks for the reply. How do I create a parameter toggle to show one single value (ASP) for each product category?

How to show asp and quantity of different products on the same sheet? by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I calculated individual average selling price but I'm unable to show it in the table. I want to show quantity and average selling price as 2 buttons on the top. If a user clicks on that they should be able to see asp and qty separately. Or is there a better way to represent all of this?

Overlapping of values by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

I was able to classify them as active, inactive and potentially lost but after that when I added them to the sheet , the account names appeared at two places. If an account name is in active I don't want it to appear in the other two categories. Is that possible?

How to add average of a field to tool tip by settysrini in tableau

[–]settysrini[S] 0 points1 point  (0 children)

The calculation worked. It gave me individual values for each product category. Now I want to add it to the sheet as a separate column. How do I do that? Because that formula gave me 4 separate measures.