Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sales evolution through time

Hello   I am trying something that should be very easy but I can't figure it out.   I have the data like this:   Date Buyer Product Value 12/12/2018 Jon Apple 20 13/12/2018 Anth...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    At the end I created a new meassure that is Year-Month, and then sorted alphabetically. I don't like it, but for now it does the job.

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    At the end I solved it with a date table with the information about the months, quarters, financial years, etc.

     

    It's not ideal and tableau does it automatically, but it solved the issue! Using a date table is extremely useful.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous I was able to create this with a line chart, with Date on the Axis, Product as the Legend, and Value as Values.

 

I believe this is what you're looking for?

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, even combined would have been nice. Did you use any particular calculated fields or just with the normal visualization options? How did you achieve it?

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Standard line chart visualization with Date on the axis, Product as the legend, and Value as values.

     

    For a combined view, I created the below measure and then put Date on the axis, Combined in the values, and removed Product from the legend.

     

    Combined = SUM(Sheet1[Value])

     

     

     

    If that answers your question, can you please mark it as the solution?