On time dimension, I want a measure to "count of tickets with due date as startof day" & count of tickets with due date as startof day (-1) (yesterday)

Questions & Answers
1

Dear Team,

I am interested in counting the tickets with duedate as today with a label"today" & also interested in counting the tickets with label “OK” with duedate as yesterday.

The result shall be a timeline with a bar graph showing tickets with label today and due today, 2nd bar graph, ticket due yesterdday with the label “ok

Br, Bhavini

2

Hi,
Welcome to the eazyBI community!

You can use measure “Issues with due date” and create calculated members in the Time dimension for Today and Yesterday: Calculated members in Time dimension

1546×854 92.2 KB

Select those new Time members in the rows and you will have only those two dates in the report and your bar chart could look like this (the order depends on the order in which you select the members for the report):

2404×1230 268 KB

The red color for today is achieved by conditional formatting with a custom formula:

1398×1162 87.4 KB

If you want to see the dates, you could select today and yesterday in the page filters and display date in the rows:

2404×1246 250 KB

I hope this helps.

Kindly,
Ilze