1

I have been trying to add a trend line to a discrete (blue pill) field and I can't able to do that. I have tried other ways which is creating a calculated field and using it to the sheet but it is not giving me the visualisation as before. The discrete field contains a yyyy-mm values from the data source which is a string format and currently being used. But I need to add trend line for that using an alternative way. Kindly help!

I tried creating a calculated field to make it work but the problem is the visualisation is not working as before

Improve this question

1 Answer 1

Reset to default
2

Convert your yyyy-mm field into a date type field by creating the following calculated field.

DATE([your_field]+"-01")

The trend line will then work.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

And make sure to treat the date as continuous. Trend lines require continuous fields
@AlexBlakemore ultimately my question is on how to do this in a discrete field?
Numeric and date fields are not permanently discrete or continuous - that is just a choice are how to present their values visually. So a date field can be treated as discrete on some shelves/views and as continuous in others. The choice in the data pane in the left margin is only a default. So there is no problem with treating a field as continuous just ito create a trend line, and treating it as discrete in other cases

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.