1 Reply Latest reply on Apr 5, 2018 12:30 PM by Patrick Van Der Hyde

    Adding parameter on TimeStamp vizualization

    Malkhaz Pertaia

      Tableau Public Hello

      I am working on TimeStamp Activity analysis and I think I need your expertise/advices. Here is the visualization of activity by hours and weekdays. The size of the circle represents number of users(random numbers)

      Now, I need I need to add color palette for another parameter - average spend but all I could do was adding Monday average spend to all the following days. In fact I need that each weekday to be colored according to suitable day's average spend. (Monday column to be colored according to Monday spend, Tuesday with Tuesday etc)

      any ideas? Thanks in advance! 

        • 1. Re: Adding parameter on TimeStamp vizualization
          Patrick Van Der Hyde

          Hello Malkhaz,


          The data as designed is not going to cooperate with making a chart like this.  However with a few quick fixes, we can easily make the desired output.


          See Sheet 6 where the data has been exported, reimported as a new data source and then pivoted.  The pivoted data allows us to utilize a single Date Dimension field and a single Hours Dimension field.  With this, we can create a Sum(Hours) field that provides the sum of hours by day/hour.  Next, we can create a window_avg() function call to average this value across the Dimension for each Day.


          Using Measure Values will not allow for this.  This is a good example of examining data design and making sure it is easy to manipulate for reporting.  Similiar concepts can be reviewed in this Think Data Thursday regarding Survey data which is another data format that is typically not designed well to work with reporting such as Tableau.  - Think Data Thursday - Visualizing Survey Data - YouTube



          I hope this helps.