Is there a way to number the axis similar to an excel spreadsheet? Maybe I am missing something, but I cannot find any details on this in the reference manual or on here.
Hi Matthew, I'm not quite sure what you mean when you say you want to "number" the axis? Your axis will display the values of the entity or entities you specify, if you wanted to display your data by letters across the top and numbers down the side as in Excel you could certainly do that, you'd need entities containing those values and your data would need to be dimensioned by those fields.
I'm not sure whether that helps, if you explain what you're trying to achieve I might be able to give more assistance.
Thank you for the response,
I was wondering if I could number the vertical axis without creating an entity.
Ah I see, you wouldn't really be able to do that on the axis without an entity, the best you could probably do is to set the first block to be a rowcount maybe?
Hi @Matthew Sobon,
did you try the ranking funtion "Counter"? Its a row counter, counts rows progressively.
https://help.board.com/docs/ranking-functions
I would like for it to appear before the entity in the axis, which I am unable to do with the counter.
You can put your row entity on the axis, put your row counter, then put the same row entity as a block on the layout. Then set the row column to zero, this will then only show block b (row counter) and block c (entity description). Should work in the instance you described, but has a lot of situations where it won't, such as if adding a grouping or manipulating the layout in certain ways.
