Skip to content

    • Charting

    Charting

    Pivot table - graph by

    Contributor
    in Charting

    Hi,

    I am sure I have done this before but if I have a date as the row on a pivot table can the graph by still be used so customers can aggregate to month, year etc. The option is greyed out??

    The field I am using is definitely a date field.

    image.png

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Contributor
      Answer ✓

      @MichelleH

      sure no problem, Using a megatable automatically allows the graph by on the date field if the first column is a date or datetime type.

    Answers

    • Contributor

      I won't delete the post but will answer myself. A megatable can graph in this way.

    • Coach

      @Jones01 Can you please share how you got it to work so that others can find your post later? You can also mark your own comment as the answer so that your question is marked as answered.

    • Contributor
      Answer ✓

      @MichelleH

      sure no problem, Using a megatable automatically allows the graph by on the date field if the first column is a date or datetime type.

    • Domo Employee

      @Jones01

      For some reason, the pivot table will only allow the "graph by" option if your date field is used for the rows, not the column.

    • Member

      Is there a proposed solution for this when you need to actually use a pivot table for the pivot functionality? A Mega Table doesn't allow selection of the pivoted columns, which means that a table cannot both be pivoted and change the date grain of the table.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories