Data modeling in quicksight

[vinodkumarb]

Hi Team
I have a table called master fields are like
lag_number
inward date
generated value
dispatched date
processed value

i need generated value based on inward date
and processed value based on dispatched date

but in my dashboard i need to use only one single date filter(dropdown)

like these sceniros i have achieved in power bi like below
i have created one candler tabe ,i have provided relationship like this

after that in my dashboard i have used calender date as a filter dropdown,i have calculated generated value normally sum(generated value) why becouse showned above data model i have given active relationship from calender date to inward date

for processed value i have calculated like below

processed value(treatas) =

        CALCULATE(
            SUM(Sheet1[processed_value]),
            USERELATIONSHIP(calener_table[Date], Sheet1[dispatch_date])
        )

it was working as my requirement in power bi

like these scenerios how i need to solve in aws quicksight

here data source will be flat file (.csv) single file only

please provide me appropriate solution

thanks
b vinod kumar

[sagmukhe]

@vinodkumarb - Thanks for posting your query. Unfortunately exact replication of this is currently not possible in QuickSight. As outlined in the following post, you can show this in 2 different visuals separately by sourcing the data from 2 different datasets where joins are established respective with inward_date and dispatched_date. Hope this helps!

Multiple Datasets to be connected like "relationship" than "join"

Hi, I had recently created a tableau report which had data from multiple tables and used its “relationship” feature to be able to link the data at time line level and create calculated fields. This functionality is missing in QuickSight, and having to create multiple cross joins with the given list of data sets is not showing up the right numbers in the visual. Is there any work around for this? Or is it suggested to have multiple datasets created on QS where each dataset will focus on 1 level …

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!