Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Several graphs to be updated - most efficient way?

Hi, 

 

I've recived a report with several graphs and tables. The report was made as a "pilot project" and all the data/transactions included was fixed between 2018-2019 YTD June. Now when the report will go-live, we have connected to the underlying databases to show the latest data available (monthly basis). 

 

My challenge now is that there are several graphs with different set-up of dates, e.g filtering on Jan-18...June-19 (monthly bars), or filtering only on June-19 (YTD calculation), or filtering on Jan-19....June-19. I'm thinking of different solutions to create a scroll-filter on the frontpage, e.g. choosing Oct-19 (latest figures) and all the graphs different date filtering shoould be updated accordingly.

 

Anyone could give me some tips before I spend too much time building something inefficient.

 

Many thanks, 

A

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You can make a common table (if im understanding right) and connect it to all of your dates on your tables.

     

    What i mean is to create a date table to connect it, you can do it by calendarauto() or calendar(min([datefield]),max([datefield])) but i would advise you to use the second option.

     

    Let me know if it worked.

     

    BR,

    DR

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Duarte,


      Thanks for the suggestion but my issue is that I have four different date filters for graphs ( see below). Jan2018...June2019, or jan..june, or Jan2019...June2019, or June

       

       

      The data set will also contain data/transactions for upcoming months (e.g. December 2019 are already available for a few data transactions recorded).

       

      I would like to have a Scroll-list on the frontpage where the user could e.g. enter "October" - and all the different filters above will select everything to October (or only October for the case with one month only)

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I get it know, you can make it the same wat but you have to prepare that table and the rest.

         

        When you create that table with the date series then you can make relationships between them so it recognizes all the data.

         

        I would advise to set all in date format on your tables and then connect to that table, after that you use the new table's data to define the date on the visualizations, then you can filter by just one.

         

        Let me know if I could explain my self and if it helps.

         

        BR,

        DR