cancel
Showing results for 
Search instead for 
Did you mean: 
OleksandrB
Sisense Team Member
Sisense Team Member

Show full date format in the pivot or table widget

If you want to show the full date format, like 2024-11-20 18:00:00 in the Pivot or Table widget, please do the following:

1. Go to the elasticube find the Date column and duplicate it

ALT text: A user interface displaying a menu with options for "Date" highlighted in red. The menu includes options for "Duplicate," "Rename," "Hide," "Drop," "Description," "Change Data Type," "Add Data Security," and "Relationships."ALT text: A user interface displaying a menu with options for "Date" highlighted in red. The menu includes options for "Duplicate," "Rename," "Hide," "Drop," "Description," "Change Data Type," "Add Data Security," and "Relationships."

 

 

 

2. Rename it if you wish and convert it from the Date to the Text

ALT text: A screenshot of a user interface displaying a list of fields labeled "Date," "Gender," "Quantity," "Revenue," "Visit ID," and "Date_show." There is a dropdown menu under "Date_show" showing various data types, including "Date-Time," "Int," "BigInt," "Float," "Real," "Decimal," and "Text." The interface uses a red highlight for the "Date","Date_Show", and "Text"  sections.ALT text: A screenshot of a user interface displaying a list of fields labeled "Date," "Gender," "Quantity," "Revenue," "Visit ID," and "Date_show." There is a dropdown menu under "Date_show" showing various data types, including "Date-Time," "Int," "BigInt," "Float," "Real," "Decimal," and "Text." The interface uses a red highlight for the "Date","Date_Show", and "Text" sections.

 

 

3. Build the elasticube.

4. Go to the dashboard, create a widget, and select our Date_show field

ALT text: A user interface section showing a sidebar with icons for different functions, including a grid icon, a filter icon, and a help icon. Below the icons is a table titled "Add Title" with timestamps listed from November 26, 2009, to December 1, 2009. Each timestamp follows the format "YYYY-MM-DD HH:MM:SS."ALT text: A user interface section showing a sidebar with icons for different functions, including a grid icon, a filter icon, and a help icon. Below the icons is a table titled "Add Title" with timestamps listed from November 26, 2009, to December 1, 2009. Each timestamp follows the format "YYYY-MM-DD HH:MM:SS."

 


 5. Create a filter based on the real Date field.


ALT Text: Screenshot of a user interface showing an "Add Filter" section. There are fields labeled "Brand," "Category," "Commerce," and "Date" with checkboxes beneath each. A red arrow points towards the "Date" filter option, and another arrow points to a filter icon in the top right corner.ALT Text: Screenshot of a user interface showing an "Add Filter" section. There are fields labeled "Brand," "Category," "Commerce," and "Date" with checkboxes beneath each. A red arrow points towards the "Date" filter option, and another arrow points to a filter icon in the top right corner.

 

 

 

6. Now, the Pivot/Table widget shows the full date format, which you can filter using a date filter.

ALT text: "Screenshot of a data visualization tool showing a date field labeled 'Date_show' with the value '2013-12-04 00:00:00.000' on the left side. On the right side, a filter labeled 'Days in Date' displays '12/4/13' with an option to toggle."ALT text: "Screenshot of a data visualization tool showing a date field labeled 'Date_show' with the value '2013-12-04 00:00:00.000' on the left side. On the right side, a filter labeled 'Days in Date' displays '12/4/13' with an option to toggle."ALT text: "Screenshot of a data visualization tool showing a date field labeled 'Date_show' with the value '2013-12-04 00:00:00.000' on the left side. On the right side, a filter labeled 'Days in Date' displays '12/4/13' with an option to toggle."

 

 

Have a nice day!

Rate this article:
Version history
Last update:
‎11-22-2024 08:33 AM
Updated by: