-
1. Re: How to multiply Non aggregate and aggregate in Tableau
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
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
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
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
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
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
Thank you Saurabh your help saved my 2 days time