Missing hours/create a new axis

[#1]

Dear All

Can anybody please suggest me a way to add a 24 hour axis to the chart, in a way that all 24 hours are shown and the time between 1.00 and 7.00 is evenly distributed?

Thank you in advance.

[#2]

I ques you only have value's until 16:00.

[#3]

Hi

The values always change, because there is an update every 15 minutes. The table is updated daily, basically all values are reset to 0 after midnight.

Thanks.

[pover · Accepted solution]

First, if all the hours don't exist in the data model, you should add hours to the data model and link it to the hour column in your transactions table. For example:

LOAD maketime(rowno()-1) AS HOUR
AUTOGENERATE 24;

Then in the graph and in the presentation tab, disable the option to suppress zero values and to suppress missing values. You might also have to select the option to show all values in the dimension tab.

Regards.

[#5]

Dear Karl

You are a star! It works! I had created the 'hours' table myself, but I could not see the values because I hadn't clicked on suppressed zero values!

Thank you again!