Unable to select other timestamp filed in Date histogram

  • What Grafana version and what operating system are you using?
    version 8.5

  • What are you trying to achieve?
    Select other timestamp in Date histogram

  • How are you trying to achieve it?

  • What happened?
    try but not allow to select other filed except TimestampasDate

  • What did you expect to happen?



    In the data source, I have 4 columns with 4 different timestamp(pic1), I would like to pick either 3 to groupby except TimestampAsdate in Date histogram.
    However, the only one available(pic2) to check is TimestampAsdate, why? How to deal with it?

  • Can you copy/paste the configuration(s) that you are having problems with?
    Yes

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No

  • Did you follow any online instructions? If so, what is the URL?

Those are epoch timestamp, you might need to convert them to real date time

Thanks for the reply, I know how to use date transformation in Grafana. In that way, I can’t use date tohisgram function. Are you suggest me to convert it before I pull data from database? Because I am user to build the dashboard, I do not have permission to update that in the raw data. Any other suggestion?