
1. Re: Arrows for multiple metrics based on percent differences
michael shin Feb 23, 2015 9:34 PM (in response to michael shin)Hi there. Any ideas or feedback please?

2. Re: Arrows for multiple metrics based on percent differences
Radha Dorairajan Feb 23, 2015 11:25 PM (in response to michael shin)Hi Michael,
I was unable to view your workbook as it had some external connections which I was not able to access. Please create a data extract and then package the workbook and share it.
Nevertheless I tried to answer your question based on the inputs you had given. I have created the same for one measure. This can be extended to more measures as per requirment. Here are the steps.
Create a calculated field with the following if else statement.
if(ZN(SUM([Sales]))  LOOKUP(ZN(SUM([Sales])), 1))<0 then 'Negative'
elseif(ZN(SUM([Sales]))  LOOKUP(ZN(SUM([Sales])), 1))=0 then 'Zero'
elseif(ZN(SUM([Sales]))  LOOKUP(ZN(SUM([Sales])), 1))>0 then 'Positive' end
Here my measure name is "Sales" and I am studying the sales growth.
After creating the field, use the Crosstab visualization and change the marks type to "symbol". Drag and drop the field u created on to the shapes shelf.
The triangle in the pill shows that it is a table calculation. Click on the pill to get a dropdown where you can edit the table calculation properties. In my case , my time period is in columns and I want to calculate the difference from my previous value along the row. Therefore I chose " Table(Across)" in the "compute using" options.
Since this is a table calculation, no matter what level of granularity you are on (year, quarter, month, week, day) it will always calculate in comparison to the previous value.
Once the table calculation is set, you can define the symbols you need for depicting the different values in the edit
shapes window. Use a blank PNG image for the null item to hide the symbols in the first column. Please refer to the following article for custom shapes. Custom Shapes .
Please find the tableau file attached.

Growth Shape example.twbx 1,023.4 KB


3. Re: Arrows for multiple metrics based on percent differences
michael shin Feb 24, 2015 7:28 AM (in response to Radha Dorairajan)Hello Radha. Attached is the TBWX file. I shall read thru your recommendations above.

For Nidhi Review Final.twbx 371.2 KB


4. Re: Arrows for multiple metrics based on percent differences
michael shin Feb 24, 2015 4:46 PM (in response to Radha Dorairajan)Hi Radha. I attempted to do this for 3 metrics within the same crosstab/worksheet. I attempted that by extending out the calculated metric:
if(ZN(SUM([PV w/ Advertiser]))  LOOKUP(ZN(SUM([PV w/ Advertiser])), 1))<0 then 'Negative'
elseif(ZN(SUM([PV w/ Advertiser]))  LOOKUP(ZN(SUM([PV w/ Advertiser])), 1))=0 then 'Zero'
elseif(ZN(SUM([PV w/ Advertiser]))  LOOKUP(ZN(SUM([PV w/ Advertiser])), 1))>0 then 'Positive'
elseif(ZN(SUM([PV w/ Editorials]))  LOOKUP(ZN(SUM([PV w/ Editorials])), 1))<0 then 'Negative'
elseif(ZN(SUM([PV w/ Editorials]))  LOOKUP(ZN(SUM([PV w/ Editorials])), 1))=0 then 'Zero'
elseif(ZN(SUM([PV w/ Editorials]))  LOOKUP(ZN(SUM([PV w/ Editorials])), 1))>0 then 'Positive'
elseif(ZN(SUM([PV w/o Rslts]))  LOOKUP(ZN(SUM([PV w/o Rslts])), 1))<0 then 'Negative'
elseif(ZN(SUM([PV w/o Rslts]))  LOOKUP(ZN(SUM([PV w/o Rslts])), 1))=0 then 'Zero'
elseif(ZN(SUM([PV w/o Rslts]))  LOOKUP(ZN(SUM([PV w/o Rslts])), 1))>0 then 'Positive' end
The above does not seem to work. Any ideas on how to do all 3 metrics?

5. Re: Arrows for multiple metrics based on percent differences
michael shin Feb 25, 2015 10:28 AM (in response to michael shin)Hi there. Any feedback on multiple metrics plz?

6. Re: Arrows for multiple metrics based on percent differences
Chris McClellan Feb 25, 2015 3:44 PM (in response to michael shin)1 of 1 people found this helpfulI've never found a way to interlace the number & arrow for multiple measures on a single worksheet. What I usually do is to create different sheets and put them on a dashboard in the right format so it looks like they are interlaced.

7. Re: Arrows for multiple metrics based on percent differences
michael shin Feb 25, 2015 4:57 PM (in response to Chris McClellan)Thanks Chris.
Mike

8. Re: Arrows for multiple metrics based on percent differences
Radha Dorairajan Feb 25, 2015 5:23 PM (in response to michael shin)Hi Michael,
I was trying to find a way to solve your problem. It is not possible to have all three measures with symbols in the same view. You can use 3 sheets for the three metrices and arrange them one next to each other. You can also use a different chart type like a bar or a line which depicts the trend quite easily without having to use symbols.