Showing various time ranges on a line chart

Question & Answer
,
1

Hello,

Currently I have a line-chart showing data for each day hourly. However, I would like to do the following in the chart w.r.t today’s date → If the look-back period is : <5 days show hourly. 5+ days use day. 6+ months, show monthly.

Can I do that? Please advise.
Thank you.

1 Like
2

Hello @harpar1808 !

The challenge is managing the field well aggregation. You will need to use an ifelse calculation that will truncate the date depending on your look back window. Is your look back window based on a parameter choice from your user or another calculation/field in the dataset?

Essentially the calculation would look like this:

ifelse(
    ${LookBackWindow} > 5,
        truncDate("DD",{DateField}),
    ${LookBackWindow} <= 5,
        truncDate("HH",{DateField}),
    etc..,
    NULL
)