9 Replies Latest reply: Aug 21, 2017 8:23 AM by Juan Moreno RSS

    Chart with three columns

    Juan Moreno

      Hi all,

       

      I'm creating a very simple chart, just three columns one after another.

       

      I have the three expressions corresponding to the values I want to represent and if I place them as Measures, it works: they are displayed as three columns.

       

      Count({<StartDate={"=InWeek(StartDate, Today(), 0)"}>}EventCode)

      Count({<StartDate={"=InWeek(StartDate, Today(), -1)"}>}EventCode)

      Count({<Year={$(=vTodayYear-1)}, Week={$(=vTodayWeek)}>}EventCode)

       

      I'd like to name them Current Week, Last Week, Same Week Last Year. What do I have to create as a Dimension for this?

       

      Thanks!

       

      Juan