I'm trying to visualise data using Google charts, but it won't work with Lookup (count related) columns, so I'm trying to convert those values to Numbers using workflow and that won't work either using my methods that I know.
My setup now:
List 1: a list of 24 hours in a day.
- 'Title' column: 24 items, from 00 to 23.
- 'Count' lookup (count related) column counting how many times certain hour appears in List 2
List 2: a list of items and their time.
- 'Time' is a calculated column that takes values from 'Hours' and 'Minutes' lookup columns that are linked to List 1.
- 'Hours' has a choice of 00-23 hours from List 1, same as 'Minutes', but I only want to count 'hours' frequency at this moment.
I'm also trying to get workflow to do the calculations.
Are there any known ways to get this working?