Multi Line graph with different categories

agolla2
agolla2 Member
in Charting

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.

image.png

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    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.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • agolla2
    agolla2 Member

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

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    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.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories