Daily Build Timings Widget w/ Usage Analytics

Question

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 · Answer

Hi&nbsp;djaquette,
I am going to feature this post to get it more views and hopefully get you an answer.

dray · Answer

Hi&nbsp;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).

&nbsp;
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.

dray · Answer

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

dray · Answer

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.

djaquette · Answer

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

Forum Discussion

Daily Build Timings Widget w/ Usage Analytics

Recent Discussions

How to configure SSO with JWT

Semantic Layer tables stack up like a deck of cards

Resizing Interactive Pivot's dropdown menu

Sisense Intelligence token estimation

How to display two different Values from two different years within the same month range?

Sisense

Support

Resources