This content has been marked as final.
Show 4 replies
-
1. Re: Calculated Field to Transform Data?
Simon RuncOct 13, 2016 1:23 AM (in response to Benjamin Cole)
hi Benjamin,
So you can do this with the following 2 calculations;
[GDP]
IIF([Series name] = '"GDP ($)",[Value],0)
[Population]
IIF([Series name] = '"Population",[Value],0)
When you bring these in, say with the aggregate SUM each field only contains the SUM of each measure.
Let me know if that doesn't work, or doesn't make sense.
-
2. Re: Calculated Field to Transform Data?
Ravindra Zinjad Oct 13, 2016 1:23 AM (in response to Benjamin Cole)Hello Benjamin,
Use case statement as below.
Case when [series name] = 'GDP' then [value]
when [series name] = 'Population' then [value] else [series name] end
-
3. Re: Calculated Field to Transform Data?
Benjamin Cole Oct 14, 2016 6:31 PM (in response to Simon Runc)Ahh yes, this worked...thanks!
-
4. Re: Calculated Field to Transform Data?
Benjamin Cole Oct 14, 2016 6:31 PM (in response to Ravindra Zinjad)Hey Ravindra,
Thanks for the case statement, it didn't really address the issue because its still reliant on using the Series name and doesn't provide new measure values that i could then build a dual axis graph with.