0 Replies Latest reply on Sep 23, 2018 7:12 AM by an dinho

    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.