Forum Discussion
Help needed - create metric based on 2 datasets. Use one total form DS1 and use 2 columns from DS2
Super UserI would rather do that as a waterfall chart.
lbendlin thanks for the help - but to reflect your suggestion to show in a waterfall chart , in that type of graph I don't see the total # of people inside the hotel. It only shows me a starting point # of people and then in red/green bar the # of people IN or OUT counted.
I want to see the total number of people as a number in a graph over time for all days in 15min. So this is not really what I am looking for. Like the example screenshot.. the yellow line I would like to represent:
- hotel rooms guests (number) Plus and MINUS the IN & OUT counts during the dya. So taht yellow line wil show rolling total over the day
- the green/blue bar shows the IN & out counts to present me peak times for visitors