how to visualize

Stephane

Hello

I have time and date of equipement use and I want to visualize when they are running.

For example something like a calendar; weekly based or graph bar with hours on Y value from 7 am to 7 pm and a bar showing if the equipment was used or not.

Data are date/time of start and date/time of end usage for each equipment.

Don't know how to/what to use.

Thanks

Best regards

Stephane

Hello Grant

Thanks for the answer.

I did what you suggest and it works

I used 15min slice; a bit long to write the tel but worth the case

Also can do an other one now with less granularity and make a drill graph to see detail...

Thanks again

Best regards

Stephane

Stephane

Sorry, didn't noticed the small yes on the bottom.

😀

jaeW_at_Onyx

@user009257

instead of worrying about the chart type, maybe draw out on paper what this viz should ook like, and also what you're trying to communicate.

Are you trying to measure utilization rates? if so, a table card of equipment with daily utilization expressed as a percentage might be more effective than a bunch of lines.

how many pieces of equipment do you have? if you have more than 4, having one bar per day would be 4* 7 bars... that's kind of hard to read and extract value from.

GrantSmith

Hi @user009257

If you're wanting to graph when the equipment is being used the current format won't get you want you're looking for. You'd need to instead slice your data to state "at this time I was in use". You can do this using an ETL to modify your data. You'd need to define how granular you want your slices to be but sounds like hourly is what you're looking for.

For example:

Machine 1 | 2021-02-15 8:30 AM | 2021-02-15 9:45 AM |

Would become:

Machine | Hour | Active

Machine 1 | 2021-02-15 07:00 AM | 0

Machine 1 | 2021-02-15 08:00 AM | 1

Machine 1 | 2021-02-15 09:00 AM | 1

Machine 1 | 2021-02-15 10:00 AM | 0

As for graphing you could use a calendar type chart to get a heat map of how often the machine is running or you could utilize a bar chart with the hour on the axis (depending on if you want the specific date or the run time bucketed into the hour number of the day)

Another option might be a Flex Table which would get you a graph of activity but also allow you to have additional data numbers next to the graph displayed.

Stephane

Hello Grant

Thanks for the answer.

I did what you suggest and it works

I used 15min slice; a bit long to write the tel but worth the case

Also can do an other one now with less granularity and make a drill graph to see detail...

Thanks again

Best regards

Stephane

GrantSmith

Hey @Stephane

I'm glad it worked for you. Can you make sure to accept my answer so others can easily find the solution if they have a similar issue?

Stephane

Sorry, didn't noticed the small yes on the bottom.

😀