-
1. Re: How to computer 1 dimension with 2 filters
madhuri.tanniru Jun 17, 2016 11:06 AM (in response to lawrence.magno) -
2. Re: How to computer 1 dimension with 2 filters
lawrence.magno Jun 17, 2016 12:23 PM (in response to madhuri.tanniru) -
3. Re: How to computer 1 dimension with 2 filters
madhuri.tanniru Jun 20, 2016 6:44 AM (in response to lawrence.magno)Hi Lawrence,
I have come with the following solution, please see if this is what you are looking for
I have taken the following as my data source
And the following view is built in Tableau
The following calculated fields were added
[UniqueIdentifier] = [Object Name]+[Category]
[CapacityValues] =
IF ATTR([UniqueIdentifier]) = ATTR([Object Name])+"Capacity" then SUM([Values])
ELSE 0 END
[DiskSpaceUsageValues] =
IF ATTR([UniqueIdentifier]) = ATTR([Object Name])+"DiskSpaceUsage" then SUM([Values])
ELSE 0 END
[Difference] = IFNULL(-([CapacityValues]+[DiskSpaceUsageValues]),0)
Table Calculation ( applied on the field Difference)
Hope this helps!
Thanks,
-Madhuri
-
4. Re: How to computer 1 dimension with 2 filters
madhuri.tanniru Jun 20, 2016 1:43 PM (in response to lawrence.magno)Please see if this helps
Thanks,
-Madhuri
-
5. Re: How to computer 1 dimension with 2 filters
lawrence.magno Jun 24, 2016 9:37 AM (in response to lawrence.magno)Hi
Thank you for your help. You gave me ideas!
I duplicated the measure so i have measure for capacity and used
drag the measure names on the column
and drag measure values on Marks on label
create 2 calculated field.
calculatedfield1:
IF [dimension] = (Capacity) then [measure] end
calculatedfield2:
IF [dimension] = (used) then [measure2] end
Thank you,
Lawrence
-
6. Re: How to computer 1 dimension with 2 filters
madhuri.tanniru Jun 24, 2016 10:02 AM (in response to lawrence.magno)Glad it helped!
Thanks,
-Madhuri