8 Replies Latest reply on Nov 21, 2017 2:09 AM by pinki sharma

How to make measures using dynamic comparison

pinki sharma Nov 13, 2017 10:26 PM

Hi All,

I have 3 columns in table.

1. Time

2. Total Calls

3. Codec

I want to make timeline view with calls and calls in particular codecs like shown in attached image.

To implement this right now i am making calculated fields like this -

if [Codec]="G711U" then

([Calls])

end

Data points are coming right but the problem in this approach is - I am comparing the codec values with hard coded value.

This is not right approach because codec value can be anything .I don't know all the values of codec.

Could you guys please help me to find resolution of this problem ?

Thanks is advance.

Regards,

Pinki Sharma

1. Re: How to make measures using dynamic comparison

pinki sharma Nov 13, 2017 10:28 PM (in response to pinki sharma)
Forgot to attach images

sampleCodecWb.twbx 12.9 KB
Like Show 0 Likes(0)

Actions
2. Re: How to make measures using dynamic comparison

haitham Farouk Nov 13, 2017 10:40 PM (in response to pinki sharma)

Hi pinki,

You can accomplish this by add another axis on sales and make it line and color it by codec .... see the below image:

Best Regards
Like Show 0 Likes(0)

Actions
3. Re: How to make measures using dynamic comparison

Tushar More Nov 13, 2017 10:47 PM (in response to pinki sharma)

Hi Pinki,

I think you should create a parameter based on codec and then use it in calculated field.
Hope this helps.

Regards,
~Tushar
Like Show 0 Likes(0)

Actions
4. Re: How to make measures using dynamic comparison

pinki sharma Nov 13, 2017 11:00 PM (in response to haitham Farouk)

Hi Haitham,

Thanks for replying.
I agree i can achieve time line view with the approach suggested by you but i want to make tabular view also with other dimensions like country etc. This approach would not work in tabular view.

I am not able to attach wb or any image.

Tabular View-

Country   Calls   calls in G711A      calls is G711U
IND          500               300               200
AUS          2000         1000               1000

Regards,
Pinki Sharma
Like Show 0 Likes(0)

Actions
5. Re: How to make measures using dynamic comparison

pinki sharma Nov 13, 2017 11:02 PM (in response to Tushar More)

Hi Tushar,

Thanks for replying.
I dont know all the codec values . It can be anything .
Parameters are not dynamic so i cannot use this approach.

Regards,
Pinki Sharma
Like Show 0 Likes(0)

Actions
6. Re: How to make measures using dynamic comparison

haitham Farouk Nov 13, 2017 11:07 PM (in response to pinki sharma)

This also can be done ... see the below image you can put anything in the row shelf

BTW (all calls is row level total)

Best Regards
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
7. Re: How to make measures using dynamic comparison

Tushar More Nov 13, 2017 11:09 PM (in response to pinki sharma)

So, in that case I would suggest take a look at the below link.
Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers

This will help you in creating dynamic parameter.

Let me know if you have any question.

~Tushar
Like Show 0 Likes(0)

Actions
8. Re: How to make measures using dynamic comparison

pinki sharma Nov 21, 2017 2:09 AM (in response to haitham Farouk)

Hi Haitham,

Thanks for reply.
How can i get "0" for null values. I have lot of null values.
Regards,
Pinki Sharma
Like Show 0 Likes(0)

Actions