Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help with an issue i am having. I have applied a background color to an expression in the definition field but when i try and sort the field nothing happens.
any suggestions?
thanks,
Ryan
Hi.
Could you provide some more info? The chart type. The expression that you've used.
The sample application would be the best choice.
Hi,
Its a straight Table and the definition is as follows:
ColorMix2 (if(sum(ADV)/count([Trade Date])<5000,-Sqrt(-(sum(ADV)/count([Trade Date])-100)/(100-RangeMin (top(total sum(ADV)/count([Trade Date])
,1,NoOfRows(total))))),Sqrt((sum(ADV)/count([Trade Date])-100)/(RangeMax (top(total sum(ADV)/count([Trade Date]),1,NoOfRows(total)))-100)))
, ARGB(255, 255, 0, 0), ARGB(255, 0, 64, 128), ARGB(255, 255, 255, 255))
the table looks like this
I can't share the application as it contains sensitive information sorry.
Hi.
If you comment the color expression and everything works fine, then step by step try to avoid using inter-record functions and NoOfRows function.
Hi
It appears that the sort functions are put out of play when using ColorMix. I just tested it and get the same results. Not sure if this is a bug or not. I will look into it. You can still sort using the Dimension but apart from that it seems that no other sorting works.
Hi Morris,
thanks for looking into it, it defiantly looks like a bug to me very frustrating!
thanks,
Ryan
No, it's not a bug.
If you use inter-record functions, e.g. Top(), Above(), etc., you need to sort by expression.
HIC
so would you use the background color definition in the sort by expression? Eg
ColorMix2 (if(sum(ADV)/count([Trade Date])<5000,-Sqrt(-(sum(ADV)/count([Trade Date])-100)/(100-RangeMin (top(total sum(ADV)/count([Trade Date])
,1,NoOfRows(total))))),Sqrt((sum(ADV)/count([Trade Date])-100)/(RangeMax (top(total sum(ADV)/count([Trade Date]),1,NoOfRows(total)))-100)))
, ARGB(255, 255, 0, 0), ARGB(255, 0, 64, 128), ARGB(255, 255, 255, 255))
Hi
In this case I would use the expression used to calculate ADV or Passive Ratio as the Sort by expression. Again you can only do this on the dimension and not the expression.
thanks for the reply works great, hopefully they fix this issue