Forum Discussion
What/How to visualize multiple dates per product
I am looking for help for hte following scenario. I need to be able to visualize a product with 3 dates. For Example
Product 1, Purchase Date, Sold Date, Return Date
I was thinking that maybe it could be done in a stacked bar chart or something but cannot figure it out. The dates seem to always show up as count when I put in as data. Ideally the products would be listed on the Y axis with dates going along the X axis.
Anybody have any idea how to do this or perhaps an online tutorial where this is already done?
Thanks In Advance
5 Replies
What would be the purpose of the visual (as Described)? I would imagine it'd be more useful to have the difference between the three dates, which you would then be able to add to a measure. So take the average difference (in days, hours, whatever time period makes most sense) between Purchase date and Sold date for example. Then repeat with Difference between Sold date and Returned Date.
Another technique would be to take advantage of tool tips, and add three measures which calculate the relevant dates (can be as simple as Min(Purchase Date) for example) and add them to a visual as a tool tip.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,
Hello Ryan
I suggested the same thing but the requirement is to have a visualization instead of an excel sheet that shows the 3 dates per product. I was thinking the gnatt chart with start date and duration but thats not what the user wants.
Can you expand on the purpose or provide some insight into you're data model? What is the user looking to take away from this info, and why would it not be best to see in a table, matrix, or multi row card?
Otherwise the other idea which is similar to the first is to do a measure that takes TODAY() - MIN([Purchase Date]) for example. Then you can do a stacked bar or column chart, or even a line chart. Screenshots of data model would be helpful as well.
Hope this helps or inspires a solution for you.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,
I only think you can do this if you use the table or matrix visual. I can't think of any of the other visuals that will be able to handle this.
