Average Count of the Data

Below is the pic of an Machine Activity Table, Start Time and End Time are stored here, based on this StartTime and EndTime, need to calculate the hourly avg count of another field.

how can it be done ?
is it possible to get the data from Machine Activity to the Tulip Tables ?

hello @psp316r, would you like this displayed on a Table Analysis?? if so, something like this could work well:


where the following is the expression to group by Hour

format_date_tz(date_trunc(@End Time , ‘hour’), ‘MMMDD HH’, ‘EST’)

as you can see, the Average Part Count is being taken from the various States the Machine is in:

would this work as a solution for you?? let us know!!

1 Like

Hi there,
I want to create a similar analytics that in the x shows bars per hour and in the y show average of an integer value exists in the same records,
I tried to put this expression in the X : format_date_tz(date_trunc_tz(@tbl_collect_multivac_data Current_time , ‘hour’, ‘Jerusalem/Asia’), ‘HH’, ‘Jerusalem/Asia’)
But didn’t get any result, can anyone help me with the correct expression ?

Kind regards,
Amit Berku

hello @Amit, that expression looks correct to me.

just to help understand the root cause, what is the error message you’re seeing??

if you didn’t get bars, it could be that there aren’t any Records or Completions for the specified time. have you tried expanding Date Range to All Time (or a period of time that contains Completions/Records)??

Hi Gio, I did try to expand date range to all time but no results. Is my expression with exact parameters, like the hour kind of expression value?

gio Tulip Community Lead
November 15

hello @Amit, that expression looks correct to me.

just to help understand the root cause, what is the error message you’re seeing??

if you didn’t get bars, it could be that there aren’t any Records or Completions for the specified time. have you tried expanding Date Range to All Time (or a period of time that contains Completions/Records)??

yes, it should be displaying the HH if there is data in the range. as you can see here, your formula seems to be correct (this is a machine Analysis, but works for Completion data and Table):

would it be possible for you to share a screenshot?? thanks!!

Hi @gio ,
Thank you for your help, the problem was with the 3rd parameter of the function, time zone, I tried to write EST like in your formula and got the data, than I tried to write mine and nothing, I wrote it oposite, instead of Asia/Jerusalem I wrote Jerusalem/Asia, that was the only problem.

Regards,
Amit Berku

1 Like

Hi @gio ,
I have one small question, now I have this graph :


Bellow the bars there is the word “expression” because the source of data came from an expression, how can I change this description to something that the users will understand ?
How can I center the title of analytics ? How can I translate the meaning of Y axis ?

Kind Regards,
Amit Berku

great to hear you found the root cause!! here are some answers to your questions:

this can’t be done if you’re using customized Time format, you could use Hour of Day instead of Expression if you don’t need to format the display of Hour groupings.

this unfortunately cannot be done currently, feel free to share in Product suggestions - Tulip Community if you’d like. I will mention that if you embed the Analysis in an App, you can overlay text to display more detailed contextual information.

if you navigate to Y Axis, you can define the Label and Save the update:

hope this helps, let us know if you have further questions!!