1 2 Previous Next 15 Replies Latest reply on Aug 16, 2017 11:12 PM by suganthi sekar

# Discrete and continuous value in same axis - version 10.3

Hi ,

I need year and customer wise value and year wise total in same graph like in attached file .

 year cust value total (aggregate value) 2016 cus1 10 30 2016 cus2 20 2017 cus1 30 70 2017 cus2 40 2015 cus1 50 110 2016 cus2 60

• ###### 1. Re: Discrete and continuous value in same axis - version 10.3

Suganthi,

What have you tried and where are you getting stuck?  The forums questions are replied to by other users of Tableau.  Sharing a packaged workbook showing what you have tired and with a bit of sample data will help others to help you.

Packaged workbooks: when, why, how

Patrick

• ###### 2. Re: Discrete and continuous value in same axis - version 10.3

Hi,

i cant able to able to create sample in Tableau (Expected graph) , so that i send data and screenshot what i need

Thanks

• ###### 3. Re: Discrete and continuous value in same axis - version 10.3

Hi Suganthi,
Is this something that you are looking for ?

I was able to create the line but was not able to plot the line linearly as the sum total sum for a year will come across both all the customers in that year .

Let me know if this helps you so that I can guide you through the steps.

Thanks.
Rahul Singh

• ###### 4. Re: Discrete and continuous value in same axis - version 10.3

Hi Rahul,

Thanks for the reply . Total is for the year ( not customer wise).

• ###### 5. Re: Discrete and continuous value in same axis - version 10.3

Hi Suganthi,
I understand that . That is why I have used fixed LOD to calculate the total sales for a year which is represented by line chart .

What I am telling is that the total will repeat for each customers in a year  as you have a different column for year.Total aggregated value will come again as 30 for your second row as the year is same 2016. It cannot be blank.

Thanks.
Rahul Singh

• ###### 6. Re: Discrete and continuous value in same axis - version 10.3

Hi Suganthi,

plz find the attached packaged workbook which has the below output.

Hope this might be be helpful.

Regards

Suniana

• ###### 7. Re: Discrete and continuous value in same axis - version 10.3

Hi sunaina,

Thanks for the reply , yes the above graph came for me also, but i want 30,70,110 should joined as curve like  in my example chart

• ###### 8. Re: Discrete and continuous value in same axis - version 10.3

Hi Rahul,

yes , i agree u r point , but that is my requirement value is customerwise and year wisetotal(measure column)  both should be in same chart

Input

 year cust value 2016 cus1 10 2016 cus2 20 2017 cus1 30 2017 cus2 40 2015 cus1 50 2016 cus2 60

Expected output

• ###### 9. Re: Discrete and continuous value in same axis - version 10.3

Hi Rahul,

can you please share  the packaged work book of the image that u have posted.

Regards

Sunaina

• ###### 10. Re: Discrete and continuous value in same axis - version 10.3

Thanks

• ###### 11. Re: Discrete and continuous value in same axis - version 10.3

Hi Suganthi,

hope this is what you are looking for. find the attached packaged work book as well for reference

Regards

Sunaina

• ###### 12. Re: Discrete and continuous value in same axis - version 10.3

Hi Sunaina,
That's  a nice approach but the problem with that is that if we look at it the mark label 70 is lower than the bar level 60 which can raise question.

Thanks,
Rahul Singh

• ###### 13. Re: Discrete and continuous value in same axis - version 10.3

Hi Sunaina ,
Here is the attached twbx file,

Thanks.
Rahul Singh

• ###### 14. Re: Discrete and continuous value in same axis - version 10.3

Hi Sunina,

Thanks for the reply, the same question for me also which rahul singh raised

1 2 Previous Next