Hi,

it looks like your hours field is a dimension rather than a datetime, if you get the datetime from your table then you will be able to select hours, see below how quarter has been selected on the X-axis:





whereas here years has been selected.





Please keep us posted as to how you get on with this.

Regards,
David

Thanks, you are right, my hours are set as dimensions. Any way of getting it to be datetime as you mentioned?

Had in mind the transpose feature in Excel, does YF have that?

Hi,

you will have to explicitly cast it at the view level, this is done in an SQL query in a Virtual Table. Here is a Wiki page that contains very good documentation on Virtual Tables. Of course, you will have to find out what is the casting function for the particular DBMS you are using.

Regarding your question on Excel's transpose feature, if you mean the ability to swap the X-axis and Y-axis, then this can't be done in Yellowfin - i.e. a series is a series.

Hope this helps you, if any other questions may arise then please don't hesitate to contact us.

Regards,
David