Forum Discussion
Single Date filter for multiple visuals coming from different sources
Hi,
I have a report that is pulling data from two SQL sources. The data is related, however, one source summarizes production while the other does not summarize the data.
The unsummarized source data table has rows for multiple items produced on a specific date by an individual based on the type of item produced such as a plate, cup or bowl.
The summarized source data table combines the count of all items produced by and individual to a single date and then performs calculations for productivity levels (like how many units are produced per hour, how many minutes are spent producing a single unit, etc.)
Below is generic data I threw into Excel as reference. The report page would include a bar chart (from the unsummarized data) as well as a table (from the summarized data). My problem is I cannot figure out a way to make a data sort work for both tables. Does anyone have any ideas?
3 Replies
Hi JenWilson ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin YuHi, I am trying to create a date filter that will filter both the chart and the table. I want to be able to provide a chiclet with MTD, QTD and YTD that will filter both at the same time, but I cannot figure out what I need to do with the Calendar table to make this functionality work.
The Relative date slicer does work on the reporting but is missing QTD functionality. Is there I way I can recreate my own way of using the relative date filter? If I can get this functionality to work, chiclets wouldn't be a necessity.
