Format dashboard build datetime
the display format of the cube build time is shown as "Nov 8, 2023 2:00:01 AM"
We should have option to format it to "11/08/2023 02:00 ' i.e. MM/dd/yyyy HH:mm:ss'
hpathare
Posted 2 years ago·Last reply 2 years ago
15 comments
DRay
·2 years agoHello everyone.
Thank you for sharing your idea and providing details.
We encourage people to continue to vote and comment. One of the ways we prioritize efforts is by community interest, so every vote and comment can help turn a request into a reality.
Thank you again for sharing and being part of our community!
teddy_fer
·2 years agoDRay
this is truly obscured- why I cannot display a timestamp column in EC in whatever format possible ?
why when I need to see time with the date it hides the date ?
all other BI tools have that simple format feature .
moreover, when I try to bypass this weird missing functionality and display the same field twice to show one column with date and the other with time - I cannot sort by multiple field in a table or table with agg ?
even excel can do it .
DRay
·2 years agoHi luciano.
Thank you for responding. This forum is for product feedback. If you need assistance please submit in other forums or reach out to support.
Thank you.
luciano
·2 years agoI'm not looking for help creating widget or dashboard, I'm looking for help to fix the issue stated on this forum topic. Is exactly the same issue the user mentioned.
DRay
·2 years agoHi luciano.
Thank you for reaching out. If you are looking for help creating a Widget or Dashboard please post in the Help and How-to Forum.
luciano
·2 years agoHi DRay
I'm having the same issue, maybe you could help me?
The comment from Dougnewton is correct, when adding the columns startBuildTimeStamp endBuildTimeStamp I can't get the timestamp in one column. Rather, it makes create two columns, one for the date and one for the time. Like this:
DRay
·2 years agoHello @hpathare,
It has been a while since we heard from you. Is what dougnewton showed the format you are talking about?
DRay
·2 years agoHello hpathare,
It has been a while since we heard from you. Is what @dougnewton showed the format you are talking about?
DRay
·2 years agohpathare It has been a while since we heard from you. Is what dougnewton showed the format you are talking about?
DRay
·2 years agohpathare It has been a while since we heard from you. Is what dougnewton showed the format you are talking about?
DRay
·2 years agodougnewton Thank you, that makes sense.
hpathare Is that correct? You are talking about the area shown in the screenshot above?
dougnewton
·2 years ago · EditedNo, I think (s)he is referring to the build date-time that is shown in the banner of each dashboard, like:
In general, seems like all date displays in the system should respect the regional settings of the viewer.
Personally I like YYYY-MM-DD because it sorts nicely.
DRay
·2 years ago · EditedHi hpathare
Are you referring to a Widget? If so, you can edit the how a datetime is displayed by editing the Widget, hovering over the datetime field, clicking on the little calendar icon that shows up, and entering your desired formatting in the space outlined in the screenshot below.
If that's not the issue, can you share a screenshot of what you are seeing so I can try and replicate the issue?
hpathare
OP2 years agomy issue is on the dashboards where we see last build time , it shows as "Nov 8, 2023 2:00:01 AM" , support asked to raise it as feature request
DRay
·2 years ago · EditedHello hpathare,
Thank you for bringing this up.
Can you clarify where you are seeing that? When I look at the build times in the Data tab of my Sisense I see the datetime in the format you are requesting.