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

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?