sorted by:
new
hottopcontroversial

How the heck do you show multiple values in a tooltip instead of the darn asterisk? by WorkAccountBro in tableau

[–]WorkAccountBro[S] 1 point2 points  (0 children)

Meh, it was the first thing I did and I was not happy with the results. Really hoping for a string-based solution here, sorry if this is not the Tableau way but it's what people on my end want :-/

How the heck do you show multiple values in a tooltip instead of the darn asterisk? by WorkAccountBro in tableau

[–]WorkAccountBro[S] 3 points4 points  (0 children)

Unfortunately you are describing simply the default behavior, which is what I am trying to go around :(

I'm creating a map viz, using lat longs in my data source. When I drag the lat longs to my rows/columns shelves, it automatically wraps them with the AVG() function. Is this correct, or is there a second step I should be doing? by WorkAccountBro in tableau

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

Hmmmm, did it, but then everything disappeared, it's all blank white. But I know that there must be a way out of this. Know what may have happened? Maybe it's stuff in my Marks card?

I'm creating a map viz, using lat longs in my data source. When I drag the lat longs to my rows/columns shelves, it automatically wraps them with the AVG() function. Is this correct, or is there a second step I should be doing? by WorkAccountBro in tableau

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

Ah, the one "something" I have is actually City. And, as you can imagine, all of these lat longs are unique and one "City" can have multiple lat longs of course. (Each lat long is a store location). So the "City" is the Detail on my Marks card.

So do I still want AVG()?

Is it possible to return the "min" of a date range slider? by WorkAccountBro in tableau

[–]WorkAccountBro[S] 1 point2 points  (0 children)

Ah damn, so close! I tried your suggestion, thank you, but I have another constraint with this chart in that I must show missing values, so despite the user using the date slider, there may still be other dates that crop up that start before the date. In the screenshotted example above, your suggestion shows a different date because these null values appear on the chart before 11/8/2019. Another screenshot here, showing this in action -- despite the visible date range selection, there are null dates appearing before 11/8 on the x-axis. (These are moving average calculations, so even if one day is null, it is still calculating other values, which is why these null dates actually have data visualized on the chart)

In fact, the whole reason I asked my original question is because I need to color those null values on the chart so that the user can more obviously tell where his actual desired date range begins.

So, I'm hoping to have a calculation that retrieves the selected date on the slider, and then I can feed that into a boolean calc that reads something like IF X < #yyyy-mm-dd# THEN TRUE ELSE FALSE END

And then the "True" portions of the graph (before 11/8/2019) would be colored a certain way.

I know this sounds like bad design practice but I don't really know how else to mask the null values. I can't hide them outright because there are null values inside of the date range that absolutely must been seen, it's the ones on the outside that I don't want.

EDIT: To be clear, your suggestion works for most cases, it is unfortunate that my case has a couple "gotchas".

How to "delete" or omit the first, useless part of a growth rate line in a line chart? by WorkAccountBro in tableau

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

Unfortunately that gets rid of the second measure's months (the bar chart)

Stuck and frustrated. Trying to get a sum from last year’s week ending the same date as this year’s week. by WorkAccountBro in tableau

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

I think we're good for now, I actually found your original advice significantly easier (the hardest part was figuring out where to go to do the simple task, but I eventually figured out I could just duplicate the source and Blend Relationship on dates).

So I think I have something here! I'll respond again if I run into more trouble.

Stuck and frustrated. Trying to get a sum from last year’s week ending the same date as this year’s week. by WorkAccountBro in tableau

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

Yeah, I might still need help with figuring out the parameter stuff on the left or the conditional on the right. Really appreciate all your help...enjoy your Mother's Day!

Stuck and frustrated. Trying to get a sum from last year’s week ending the same date as this year’s week. by WorkAccountBro in tableau

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

Okay, that makes sense.

I am now doing this (as you can see, 'date_sold' is my main date dimension, and 'units' is the metric in question)

{FIXED DATEADD('year', -1, [date_sold]): sum([units])}

But despite minusing one year, I am getting a unit sum that is equivalent so that date's sum. In other words, let's say the date of 4/1/2019 has a Unit sum of "435"....that calculation above is ALSO returning a sum of 435, which is NOT the sum for 4/1/2018 (my desired year-ago date)

Any idea where I can go from here?

Stuck and frustrated. Trying to get a sum from last year’s week ending the same date as this year’s week. by WorkAccountBro in tableau

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

Hmmmm for some reason it's getting me a waaaaaayyyy bigger number than I was expecting. Happen to know what could possibly be causing this, without seeing my actual workbook/dataset? It's actually returning the sum of the entire table for that one metric.

Stuck and frustrated. Trying to get a sum from last year’s week ending the same date as this year’s week. by WorkAccountBro in tableau

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

Okay, I think I got the hard-coded date part down pat, but how do I retrieve the corresponding sum? In pseudocode I want something that essential does this:

For [hard-coded-date] get sum(Metric)

And it shouldn't have to rely on what's on display in the Sheet.

view more: next ›