Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on a line chart which has ID on X-axis and "no of days open" on Y-axis.
I am trying to name these IDs in numbers like this-
Any idea as to how to name these IDs in numbers?
This?
Exp (using sortable aggr()):
=Aggr(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4,1),(ID,(sum({<Class={'A'}>}num(today())-num(Date)))))
Hi,
May be add a match table like the one below and use a new dimension [NewField]?
LOAD*Inline
[Field, NewField
10$, 1
44$, 2
$5, 3
$2, 4
$30, 5
$12, 6
];
May be using autonumber(), like:
Load
AutoNumber("no of days open") as Sequence
"no of days open",
...
And then use Sequence as dimension.
another option is to use Rank function to convert your dimension in number
=aggr(rank(ID),ID)
Hi Andrey,
Thank you for the response.
This is just an example showing 6 values, but in my database contains a huge list - Not practical this way.
Hi Rob,
Thank you for the response.
FieldIndex provides the load position of the value right?
I am looking for the ordering in the chart itself, whether the ID is at position 100 or 1000 in the load order doesn't matter. Only the position of that ID within the chart is to be displayed ( 1,2,3,4..... from left to right). Is this possible?
Hi Kushal,
Thank you for the response.
This only converts ID into a number, but doesn't display numbers starting from 1. Any other thought?
Hi Tresesco,
I am trying to avoid working with datamodel because "no of days open" is not just a field, it is an expression with several conditions on fields in more than 1 table. If I don't find a solution which can be implemented in the layout itself, I'll give this a try and will keep you posted.
Thank you.
please provide some sample data as well as the expression you are referring to.
thanks
regards
Marco