Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

HELP report graphic filtering

Hello community. I have a Date table. And I have a couple of tables like this:

Datepostslikesshares
3/05/2018201005
18/05/2017101058
3/05/2018251109
28/04/20181011110
15/04/20171511515
22/02/20182212020
1/02/2017231008

 

I'm trying to make a bar graphic that can filter by months and then each bar represents a year. Like this (sorry for the  quality of graphic):

 

 

Pleas help. I've been trying but can only do a graphic with the months JAN trough DIC of 2016, then JAN through DIC of 2017 and so on. Really need to make look like that picutre.

 

Thanks in advance

Need Help
Tips and Tricks
Tutorial Requests
  • SteveCampbell's avatar
    SteveCampbell
    8 years ago

    I think your drawing is lovely.

     

    Do you have a YEAR and MONTH in your date table? If not make one with YEAR = Year([Date]) and MONTH = Month([Date])

    Choose a "clustered column chart" and put MONTH in the axis, and YEAR in the legend, and whatever you want in the value.

6 Replies

  • SteveCampbell's avatar
    SteveCampbell
    Icon for Memorable Member rankMemorable Member
    8 years ago

    I think your drawing is lovely.

     

    Do you have a YEAR and MONTH in your date table? If not make one with YEAR = Year([Date]) and MONTH = Month([Date])

    Choose a "clustered column chart" and put MONTH in the axis, and YEAR in the legend, and whatever you want in the value.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you! It did work. I have a followup question though. 

       

      If I have a table like this:

       

       

      How could I make it so that it appears 2016 march next to 2017 march next to 2018 march next to 2016 april next to 2017 april next to 2018 april.. and so on. Kinda like this (I did it with paint so I can show you :v)

       

      Thanks in advance!

      • SteveCampbell's avatar
        SteveCampbell
        Icon for Memorable Member rankMemorable Member
        8 years ago

        Is this "2016 March" etc a hierarchy or new column you created? If you click on a column, you can go to the "Modeling" Tab and use "Sort by Column". You may need to create a sort column or use a datekey - You will need one unique value for each value.

         

        I am assuming you have a month and year column you have concatenated. If so, you can create a column:

        Sort Column = 

[Month] + 
divide ( [Year], 10000)

         

        Then click on your concatenated column, go to modeling, sort by column > "Sort Column"