Showing due date in a Tempo Report Column

Questions & Answers
1

https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/tempo-planner-report-examples

If issues are added as a row dimension, how can I add due date in the column in a Tempo Plan report with Time in the column dimension?

If I show the issue property due date, the due date is being duplicated for each time period.

Due date column
Due date column822Ă—466 72.1 KB

2

Hi @scv

Welcome to the eazyBI community!

To add a measure that is not drilled by Time, while “Hours spent” is still drilled, do the following:

  1. Temporary remove the Time dimension from the report
  2. Add “Issue due date” in columns
  3. From the measure “Hours spent”, drill into the Time dimension (use the “Drill into” option and select Time dimension). Read how to drill into measure by another dimension: Create reports
    In this solution, you can not add Time to Pages for filtering. To limit weeks, select the weekly hierarchy All Times member and then choose a calculated member, where you aggregate the needed weeks.

See the example below of how it would look :

image
image2208Ă—1002 186 KB

Best,
Ilze, support@eazybi.com

3

Thank you so much Ilze. Works perfectly!

1 Like