I’d like to create a line chart using date on the X axis. When the viewer has 24hs or less selected for the visual I would like the chart to show hourly increments. But if they have more than 24hs making it span multiple days I would like the axis to switch to days. Is there a way to do this?
Hi @jmartinetti - welcome to the community!
Please review the following dashboard and underlying analysis: Device Telemetry Analysis. I have replicated the scenario. The date dimension in x-axis changes to hour if the start date and end date difference is more than 12 hours, else it shows data point by minute.
Please check the c_dynamic_time_dim calculated field and the related calculations. Please let us know if you have any questions. Thanks!
Hi @jmartinetti - if you feel the above answer addresses your question, would you mind marking it as a Solution. Else let us know if you have any question. Thanks!
This is what I was looking for, thank you!