Line Chart guide value format when X axis is a Date?

[TimothyRudzik]

I have a line chart in my map depicting temperature values over time and so the X axis is a date attribute. I want to add vertical guides to this chart but can not determine the proper format of the guide value when my X axis is a date.  I have not been able to find this answer on the web.

 In my example I have a horizontal guide at 32 degrees and so the guide value is 32.  

But I also want a vertical guide on February 9th, 2021. Since the X axis is a date field, what would the guide value format look like in order to achieve that?

[DanPatterson]

did you try entering a numeric value like 10 and see if the label automatically shows February 19, 2021

you may have to do some manual calculations for the start and end dates

[TimothyRudzik]

No luck entering 10 or any other integer value I can think to try. I have also tried entering various date formats without any luck.

[ChristopherAllen]

Hi @TimothyRudzik ,

Thanks for the question. The x-axis guide *should* have date picker inputs when the x-axis variable is a date. For example:

Would it be possible for you to send a screenshot of the Data tab of the Chart Properties pane? This might help us to troubleshoot your issue. 

Thanks!

Chris

[TimothyRudzik · Accepted solution]

Chris,

I realized as I was looking at your screenshot that you had aggregation turned on. So I enabled aggregation and added a new vertical guide and now I can see date selectors in the Guides tab. Then I changed aggregation back to <none> and tried to create new vertical guides and the date picker was gone again. Is it strange that aggregation would have to be ON in order to see the date picker in the Guides tab? Would that be considered a bug?

This example shows the Guides tab where aggregation is NOT USED in the Data tab and as you can see there is no date picker.

This example shows the Guides tab when aggregation IS USED in the Data tab and now the date picker shows up.

The workaround solution is that aggregation must be turned on in order to see the date picker in the Guides tab.

Thanks,

Timothy Ryan Rudzik

[ChristopherAllen]

Hi @TimothyRudzik ,

Thank you for following up; I can reproduce this bug when I set the aggregation to <none>. When a temporal line chart uses <none> aggregation the x-axis guide should still use the date picker control. I've logged this bug so it can be addressed in a future release. 

Thanks again,

Chris