Daily Build Timings Widget w/ Usage Analytics

[djaquette]

We build a number of cubes every morning and I'd love to utilize the data in the provided Usage Analytics Model to make a line graph that shows, for each day:
- When the first build started
- When the last build ended
- The total number of minutes between those two points

It seems like all the data's there in the SummarizeBuild table, but I can't quite get the formulas right to get what I want. Thanks!

[DRay]

Hi @djaquette,

I am going to feature this post to get it more views and hopefully get you an answer.

[DRay]

Hi @djaquette.

the ootb dashboards related to builds already have a lot of charts on builds (screenshot).

Additional charts related to builds can be see in grafana (screenshot).

If the ootb dashboards aren't sufficient, you can look at the usage analytics cube and customize the existing dashboard or create a new build usage dashboard.

If that doesn't help, can you provide the formulas you have tried so far? We can take a look at it provide feedback.

[djaquette]

Yeah, I've start variations on `MIN([Minutes in startBuildTimeStamp])` or `MAX(MIN([Minutes in endBuildTimeStamp])` with `Days in startBuildTimeStamp` for the X-axis w/o luck

[DRay]

You can also do this in the model, whether it's via ranking or conversion of dates to numeric, etc. 

[DRay]

If you like, you can reach out to your account team to get a technical consultant involved. They can work with you to find a solution.