Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show TUTEstimatedDate vs TUTActualCompletionDate in a line chart graph. Attached sample line chart
TUTEstimatedDate | TUTStatus | TUTActualCompletionDate |
5/17/2020 | Completed | 5/18/2020 |
5/20/2020 | Completed | 5/21/2020 |
5/23/2020 | Completed | 5/23/2020 |
5/25/2020 | Completed | 5/27/2020 |
5/28/2020 | Completed | 5/30/2020 |
Hi,
I'm not sure how you want to use the data else in the model, but to reach the above chart, you need to get to a unified dimension (x axis).
I would manipulate the data a bit, split the rows into estimations, and completed rows.
In the chart, build two expressions
=count({<[Estimate / Complete]={'Estimate'}>}Date)
=count({<[Estimate / Complete]={'Complete'}>}Date)
with one dimension - Date
Below is a suggesion for the final table
Date | Estimate / Complete |
5/17/2020 | Estimate |
5/20/2020 | Estimate |
5/23/2020 | Estimate |
5/25/2020 | Estimate |
5/28/2020 | Estimate |
5/18/2020 | Completed |
5/21/2020 | Completed |
5/23/2020 | Completed |
5/27/2020 | Completed |
5/30/2020 | Completed |
* it is not best practice to build flags based on text, you can just transform it to numbers, but it was just to showcase the solution
I hope it helps,
Eliran.