Tablepress Row Filter 20years data to be filtered in a yearly and monthly tables

  • Resolved freebacktesting

    (@freebacktesting)


    4 years, 10 months ago

    I am designing a website which will show historical prices of stock in tables. its a quite hectic job to create different tables for every month of every year. there would be almost 240 tables for 20 years monthly data. for 1 stock and if i have 50 stocks data then it would be around 12500 tables, so I have a created a table which has columns as follows. 1. Sym ( Name of stock) 2. Date ( Full Date ) 3. Month ( Month like Jan, Feb, Mar, ) 4. Day ( day of week Like, Mon, Tue, Wed, ) I have data of 20 years. It is quite huge to show on one page. so I have created pages year and Month wise 2001,2002,2003 to 2021 and Jan Feb. mar etc. Now I want to show filtered data of 1 Year on a that specific year page or like 2010 year data on 2010 year page and 2010 Jan data on 2010 Jan page. how to do it. I tried using row filter extension, multi filter extension and auto filter extension. but I couldn’t get the desired results. pls help me

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 10 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    For this, I recommend using the TablePress Row Filter Extension from https://tablepress.org/extensions/row-filter/

    With that, you could use one big “master” table and use Shortcode like

    [table id=6 filter="2018" filter_columns="2" /]

    and

    [table id=1 filter="01-2018" filter_columns="2" /]

    to create yearly and monthly filtered versions.

    Just use either the year or the month-year combination (as part of the second column, the full date) as the filter term.

    Regards,
    Tobias

    Thread Starter freebacktesting

    (@freebacktesting)

    4 years, 10 months ago

    (@tobiasbg)
    Thank You very much. It works perfectly. The only thing is that I have to create a separate columns for year like 2010, 2011, 2012, and separate columns for month like jan 2010, feb 2010, march 2010,

    Can we use multiple filter like, first sort by column 3 by year 2010, 2011, 2012 and then filter by column 4 for specific month like Jan, Feb & Mar. so that I don’t have to create separate columns.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 10 months ago

    Hi,

    I’m not sure that I understand. Why would you have to create separate columns? This suggested solution relies on the “Date” column. Or is that not available at all times?
    You could of course also use multiple filters, like this:

    [table id=1 filter="2010&&Jan" filter_columns="3,4" /]

    This uses the “AND” connector, see https://tablepress.org/extensions/row-filter/

    Regards,
    Tobias

    Thread Starter freebacktesting

    (@freebacktesting)

    4 years, 10 months ago

    Sorry For Late reply. It solved my problem.. Now every thing is working fine.

    Thread Starter freebacktesting

    (@freebacktesting)

    4 years, 10 months ago

    Thanks

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 10 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Tablepress Row Filter 20years data to be filtered in a yearly and monthly tables’ is closed to new replies.