Can not choose Sparkline Array

Flemming Dahl shared this problem 5 months ago
Resolved

I'm trying to use the Sparkline Array.


Although I have a column of date type, I can not select this column in Advanced Function / Sparkline


Please see attached images showing the date field, the report, the advanced function and the associated SQL


Could you help please?


Best regardsFlemming Dahl

Comments (3)

photo
1

Hi Flemming,


Thank you for your question.


I suggest looking at the underlying Data Type of the field that you are attempting to use within the Sparkline formatter, as it seems to only formatted as a Date data type. I suspect the field might actually be a Timestamp Data Type, where you will need to perform a Date Function on the Timestamp in the View, in order to get a Date Field. You should then be able to use this Date Field in the Sparkline formatter. This article should provide more information about the Date Function.


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Thank you. That helped.

Have a nice weekend.

Br,Flemming Dahl

photo
1

Hi Flemming,


I'm glad to hear that helped.


I'll go ahead and mark this as closed for the moment, please don't hesitate to respond here to re-open this ticket if you have any further questions.


Kind regards,

Simon