Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

What's in on this page:

Table of Contents

...

  1. Check Slicer to configure it.
    Tip

    Ignore this filter if the Slicer does not exist in the dashboard.

  2. Click the blank box to the right of Slicer.
  3. Select the filtering criteria from the Select dropdown menu.

    1. If the desired filter criteria are not available in the Slicer, please click Advance to customize advanced filtering conditions.
    2. Enter the advanced conditions in the blank box.

      • If Ignore Filter is checked, the filtering conditions configured before the Slicer will be disregarded; only the Slicer will be effective.

Date Format

No.NameDescriptionExample
1MM-DD-YYYY

Display dates as month-day-year.

01-31-2024
2DD-MM-YYYYDisplay dates as day-month-year.31-01-2024
3YYYY-MM-DDDisplay dates as year-month-day.2024-01-31
4MM-DD-YYDisplay dates as month-day-year, showing only the last two digits of the year.01-31-24
5DD-MM-YYDisplay dates as day-month-year, showing only the last two digits of the year.31-01-24
6YY-MM-DDDisplay dates as year-month-day, showing only the last two digits of the year.24-01-31
7MM YYYYDisplay dates as month year.01 2024
8YYYYDisplay dates as year.2024
9MMM YYYYDisplay dates as month year, with the month displayed as a three-letter abbreviation of the English word, capitalized.Jan 2024

Date Time Format

No.CategoryNameDescriptionExample
1DateMM-DD-YYYY

Display date as month-day-year.

01-31-2024
2DD-MM-YYYYDisplay date as day-month-year.31-01-2024
3YYYY-MM-DDDisplay date as year-month-day.2024-01-31
4MM-DD-YYDisplay date as month-day-year, showing only the last two digits of the year.01-31-24
5DD-MM-YYDisplay date as day-month-year, showing only the last two digits of the year.31-01-24
6YY-MM-DDDisplay date as year-month-day, showing only the last two digits of the year.24-01-31
7MM YYYYDisplay date as month year.01 2024
8YYYYDisplay date as year.2024
9MMM YYYYDisplay dates as month year, with the month displayed as a three-letter abbreviation of the English word, capitalized.Jan 2024
10Same as account setting

Display dates according to the date format set in your Get Started settings.
Image Modified

If your selected date format in Get Started is MM/DD/YYYY, then all dates in this widget will be displayed in the format MM-DD-YYYY.

11NULL

Do not display date.

When the date time is 2024.01.31, 18:30:30, display it as 18:30:30.

12Time

HH:mm

Display time as hours (in 24-hour format): minutes18:30
13

HH:mm:ss

Display time as hours (in 24-hour format): minutes: seconds18:30:30
14

hh:mm

Display time as hours (in 12-hour format): minutes06:30
15

hh:mm:ss

Display time as hours (in 12-hour format): minutes: seconds06:30:30
16

NULL

Do not display time.

When the date time is 2024.01.31, 18:30:30, display it as 2024.01.31.
17Time Indicators

a

When Time format is set to hh:mm and hh:mm:ss, this option will appear for configuration. Display lowercase am and pm after the time.

6:30:30 pm
18

A

When Time format is set to hh:mm and hh:mm:ss, this option will appear for configuration. Display uppercase AM and PM after the time.

6:30:30 PM
19

NULL

When Time format is set to hh:mm and hh:mm:ss, this option will appear for configuration. Do not display am, pm, AM, or PM after the time.

If the time is 6:30:30 pm, do not display pm and display it as 6:30:30.

Related Topics

...

Content by Label
showLabelsfalse
showSpacefalse
excludeCurrenttrue
cqllabel in ("widgets","widget","slicer")