1 Reply Latest reply on Nov 1, 2018 12:56 PM by Patrick A Van Der Hyde

    Calculating projected sales based on number of working days

    an dinho

      Hi All,

       

      I am very new to tableau and seen a few posts about number of working days in a month, I have 5 days worth of sale(s) for a product and need to find out what the projected sales is for the rest of the month. How I would have worked this out in excel is to average out the 5 days worth of sales and then * by the number of working days within the month. I wanted to have this displayed as text rather than in a graph, but I tried the calculation above (in bold) in a calculated field and it did not work, can anyone please advise on the best way of doing this?

       

      Thanks in advanced.