Comments

8 comments

  • Avatar
    José Manuel Flores Medina

    please i need help I am a newbie

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine

    Hi José,

    Could you please elaborate (potentially with screenshots/images) on what you are trying to accomplish?

    Thanks,

    Sam

    0
    Comment actions Permalink
  • Avatar
    José Manuel Flores Medina

    January of each year, then February of each year, so on




    0
    Comment actions Permalink
  • Avatar
    José Manuel Flores Medina

    Thank you.

    1
    Comment actions Permalink
  • Avatar
    José Manuel Flores Medina

    Lo mismo esto

    1.

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine

    Hi Jose,

    In the table where your date field (FECMOV) is located in the ElastiCube, create a new custom field with just the month. Expression: GetMonth([FECMOV]). Then use that field as the Categories dimension in your widget.

    Thanks,
    Sam

    0
    Comment actions Permalink
  • Avatar
    Robert Choquette (Edited )

    When you do this, you get an integer representing the time unit. 

    Assuming that you want to aggregate on month of year.

    How would you represent this as the name (ie month = 1, but shown as January in the widget)? I have seen solutions using javascript and/or plugins. Is there a native way of doing this? Changing the display in the widget editor doesn't offer the calendar option because it's an int.

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine (Edited )

    I would recommend creating your field in the ElastiCube Manager however you want to display the values (whether 1, Jan, January, etc.), then using this technique to ensure they're sorted chronologically: https://support.sisense.com/hc/en-us/community/posts/221225968-The-Chart-Label-Order-Changer.

    0
    Comment actions Permalink

Please sign in to leave a comment.