-
1. Re: How to multiply Non aggregate and aggregate in Tableau
John Sobczak Dec 12, 2017 9:04 AM (in response to Vasudeva Veeragandham)If you can supply some simple mock data (only a few rows) and an example of what outcome you are looking for this would help.
-
2. Re: How to multiply Non aggregate and aggregate in Tableau
Vasudeva Veeragandham Dec 12, 2017 10:02 AM (in response to John Sobczak)Hi John,
Thank you for the reply
Looking for below
A.PRICE*COUNT(B.ID))
Price has values like this -
6.77
6.76
6.79
6.72
6.55
and ID has Values Like this
2069
2070
2071
Here we need do count(ID) i.e - 3, Then Multiple 3*Price
nothing but count(ID)*Price
Expecting Results
3*6.77 =
3*6.76 =
Hope this example help you to find the out root cause
-
3. Re: How to multiply Non aggregate and aggregate in Tableau
Sankarmagesh Rajan Dec 12, 2017 10:08 PM (in response to Vasudeva Veeragandham)Hi Vasu,
Try with
Count(ID)* Sum(Price)
If it not works then attach workbook.
Thanks
sankar
-
4. Re: How to multiply Non aggregate and aggregate in Tableau
Vasudeva Veeragandham Dec 12, 2017 11:31 PM (in response to Sankarmagesh Rajan)Thank you for the reply , i dont think so it will work because i dont want sum of price * count (ID).
It will give wrong values
-
5. Re: How to multiply Non aggregate and aggregate in Tableau
saurabh.c.0 Dec 13, 2017 1:12 AM (in response to Vasudeva Veeragandham)Try with
Count(ID)* MAX(Price)
If this doesn't work please attach your workbook
-
6. Re: How to multiply Non aggregate and aggregate in Tableau
John Sobczak Dec 13, 2017 4:57 AM (in response to Vasudeva Veeragandham)If it is simple as you described then a basic LOD will do. LOD's have the nice feature of NOT being treated as an aggregate but a row level value.
Most basic form of LOD is {countd(ID)} which will count across ALL rows of your entire data which you can then use as your non aggregate multiplier but I suspect you will want to include dimensions in your LOD.
-
7. Re: How to multiply Non aggregate and aggregate in Tableau
Vasudeva Veeragandham Dec 15, 2017 8:47 AM (in response to saurabh.c.0)Thank you Saurabh your help saved my 2 days time