1 of 1 people found this helpful
Couldn't you just use the sum and avg aggregation that would update dynamically when you filter?
If you need to use the window_sum/avg the start and ends can be omitted and it will use the entire partition or you could specifically define the offsets using a number -/+ or using first() last().
computes the average of all rows in the partition
computes the average of the previous and the current row
computes the average of the first row in the partition through the current row
Hope that helps.
Thanks a lot for the help. There are two more things I would have concerns with. I need to show my metric value in millions but once I select Million number format, there is "M" written with the value which I wanted to remove. Let me know how to do that.
Also, I was creating a heat map, below is the screen shot for the same. My heat map color coding is done based on a calculated field. But the value shown in heat map is a different measure. I am able to successfully implement the color coding for the same but the the color coding is done on text and I need the background to be color coded. Let me know if anyone knows how to do the same.
Looking forward for some help. Thanks in advance...
Thanks a lot for help. But if I remove M like that then the number displayed is like the original form i.e the number is not displayed in million. I think i might need to create an extra calculated field and divide the measure by 10^6 and then show it in label.
Also in case of color coding, I think we can use square instead of bar and then resize them to get something like the below mentioned screenshot :
But somehow when I try to resize the squares are of different size. I am assuming the size of square depends on the value of measure... As in my case the color coding is from different calculated metric and the value shown in label is a different measure. See the below screenshot :
Let me know how we can correct the above issue.
If you first format the number in Million units and then remove the M in the custom format, you get the desired result without creating a new field. The Sales total from my screenshot above is $2,300,000.
The problem with the squares is that they will usually overlap because you are drawing a rectangle. There are lots of ways to do things in T so maybe you found a way that works.
I attached a workbook for you to look at the difference between bars vs. squares and the sales formatting. 9.2.
Superstore.twbx 462.4 KB
I tried using bar but it just displays a line and not boxes. Also could you please upload the workbook again. The current one is opening properly.
Hi @VISHAL SARKAR,, use Square instead of the bar. Heat map required 1 or more dimensions and 1 or 2 measures.
This will automatically enable in the show me portion if you choose the right fields on your workbook.
Thanks and God Bless,
Thanks a lot for help. I was able to implement the same
Was just curious to know is it possible to restrict the selection in filter in tableau ?
For eg I have 20 countries in a filter and I can select 5 or 6 at max then a pop should appear that I cannot select more than this.
Thanks in advance!
There is no option to limit the filter to a # of selections, but there are a couple work-arounds using multiple parameters or a table calc to blank out the view.
1 of 1 people found this helpful