Master Time Table

[arsallee3]

I am working to chart items by hour and having some difficulties in getting the output I want.

Pulling data from a SQL table with single date/time stamp field.

I can chart by hour with no problem, however I have hours that I have no data and would like to have this reflected in the hourly chart.

I have tried creating Master time table still not able to get the results that I would like.

[hic]

If you create a field "hour", use this as dimension in your graph, and set the axis as "Continuous" (on Axis sheet) you will have holes in your graph on the hours where there is no data.

An alternative is to use

   Sum(Data) + 0*Sum({1} Data)

instead of

   Sum(Data)

as expression, and remove "Suppress zero values" on the Presentation tab. This will force all dimensional values to be displayed, also the ones without data..

HIC

[arsallee3 · Accepted solution]

I did have the hour as a dimension already however I do not see way to set to Continuous.

The alternative formula did achieve the result for me though.

Thanks,

Andy