Multi Line graph with different categories

agolla2

Hello,

Can anyone guide me on how to represent this data in a multi line graph with 4 different timezones.

Without creating a new dataset.

GrantSmith

The issue is that your data is wide but the series will only work with your data in a more long format.

If you pull in all of your columns it treats each of those columns as the value and not the hour series as you're wanting.

You need to pivot your data such that you have Case Created Hour, Time Zone and Case Count in your new dataset.

3 | EST | 78

2 | CST | 78

1 | MST | 78

0 | PST | 78

etc.

DavidChurchman

IMO, you wouldn't want 4 separate lines because it's all the same cases, so splitting them into four would be misleading. You could concatenate the four time zones into a single axis label. Like:

CONCAT(`Hour`, '|', CST,'|', MST,'|', PST)

And then your x-axis would have labels like:

0|23|22|21 1|0|23|22 2|1|0|23

Or maybe a better approach would be to just include the different timezones as hovertext, available on demand.

agolla2

I'm thinking of a series beast mode to achieve this. But not sure how to write it

GrantSmith

The issue is that your data is wide but the series will only work with your data in a more long format.

If you pull in all of your columns it treats each of those columns as the value and not the hour series as you're wanting.

You need to pivot your data such that you have Case Created Hour, Time Zone and Case Count in your new dataset.

3 | EST | 78

2 | CST | 78

1 | MST | 78

0 | PST | 78

etc.

DavidChurchman

IMO, you wouldn't want 4 separate lines because it's all the same cases, so splitting them into four would be misleading. You could concatenate the four time zones into a single axis label. Like:

CONCAT(`Hour`, '|', CST,'|', MST,'|', PST)

And then your x-axis would have labels like:

0|23|22|21 1|0|23|22 2|1|0|23

Or maybe a better approach would be to just include the different timezones as hovertext, available on demand.