Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am stuck with a categories only data problem and I wondered if you could help me, please?
My database has the following fields:
Where besides USER ID, the other columns can assume any of the text values as following, being travel time periods:
I attached a photo of the dataset format as an example.
So user 1 for example, can have a DRIVE TIME (LAST YEAR) = 1 - 10MIN but DRIVE TIME (CURRENT YEAR) = 11- 20MIN.
My visualisation goal is to show a graph where we have two bars (DRIVE TIME (LAST YEAR) and DRIVE TIME (CURRENT YEAR), grouped per each time period. Example:
Or a table showing similar information (example attached). However, so far the table was breaking into combinations of time travel such as 1 - 10MIN, and all the time travel repeated for the second column, doing a COUNT of USER ID on each of the combinations possible. But that is not what I want.
Moreover, I should be able to filter on each travel time period on the bar graph for example, and having the entire dashboard readjusted.
PS: because of many reasons, I do not want to use the script to solve it, please.
Thank you so much!