Hi all,
I'm trying to build a line graph in which I could see dates - and in it, hours.
I have both dimensions, they're in a hierarchy, but the is only continuous inside each date - and not between them:
Does anyone knows how can I make it continues all over the dimensions?
Thanks!!
Jun 15, 2016 7:05 AM
can you attach a packaged workbook?
Matan,
I think the issue is that your hours column isn't stored as a time segment, just a number.
I believe that you can work around this with the following calculation to create a continuous date time stamp, and replace the columns of the graph with the continuous Hour() of the new calculation.
Below is mock data
Let me know if I am missing something.
Cheers!