2 Replies Latest reply on Oct 1, 2018 8:21 PM by Monisha Ramesh

# I would like arrows for my all my measure values Please ignore the look of those letters A.B.C.D.E for each column.

I placed this formula:

if ZN(COUNT([worksheet id])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) > 0

then 'increase'

else if ZN(COUNT([worksheet id=1])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) < 0

then 'decrease'

else 'null or same'

end end

In my shape calculation but it seems to work only for the first 2 colums and not for the percentage differences. help?

NOTE: My columns have only "Measure names" so I don't have multiple marks

• ###### 1. Re: I would like arrows for my all my measure values

It 's quite difficult to understand your expectation without seeing data structure.

Could you please create mock-up data and attach as twbx, and explain your expected view by number example.

Thanks,

Shin

• ###### 2. Re: I would like arrows for my all my measure values

Hello,

I understand I will try putting up an example at the earliest.

But,

Simply put I need a calculation to calculate the difference between the normal integer values and the percentage values in the table. So that I can put it to shapes for a KPI Indicator. (up and down arrows)

Currently, it is just calculating the difference between one cell and its previous value for the normal integer values.
{"ft_lang_label":"__label__en","ft_lang_prob":0.9215446,"math_prob":0.8876548,"size":917,"snap":"2019-13-2019-22","text_gpt3_token_len":224,"char_repetition_ratio":0.09419496,"word_repetition_ratio":0.089171976,"special_character_ratio":0.22791712,"punctuation_ratio":0.10869565,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.97211194,"pos_list":[0,1,2],"im_url_duplicate_count":[null,1,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-03-22T08:08:19Z\",\"WARC-Record-ID\":\"<urn:uuid:5d492a0e-d995-423c-a7d3-7bed4251d803>\",\"Content-Length\":\"91873\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:e30a22c2-51e0-48a8-a151-6642c782c40c>\",\"WARC-Concurrent-To\":\"<urn:uuid:2236ae9a-7ac5-4f85-b12a-209117c4b05f>\",\"WARC-IP-Address\":\"204.93.79.205\",\"WARC-Target-URI\":\"https://community.tableau.com/thread/283547\",\"WARC-Payload-Digest\":\"sha1:3I5PHG6E65XPE26CI6Y7KGOM6EE4CBTE\",\"WARC-Block-Digest\":\"sha1:KGBERXZPDUKVR4WGBBUD4WA37GYNQBVD\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-13/CC-MAIN-2019-13_segments_1552912202640.37_warc_CC-MAIN-20190322074800-20190322100800-00481.warc.gz\"}"}