Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating a Total Based on Start/End Dates

I have a data set that includes Start/End Dates, Site, Object, and ObjectAttributeX (a number equal to or less than 1). I need to calculate Total ObjectAttributeX for a Site. If an Object's Attribu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler I'm sorry! very new to this, not sure how to explain accurately.

So I want the date that the data is filtered to be based off a datedimension table that i built. I put the DateDimension into a Slicer to filter the data in the "Report" tab.

I have 4 tables right now - a site key, the objectattributex by date, objectattributex need, and a date dimension:

 

Is it possible to make this work?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Maybe. What are the directions and of those relationships? And are they 1:many, 1:1, many:1, many:many? Is the ObjectAttributeX Need is that what we are trying to create??

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler 

    Ok, I drew them but I can write it out if that's easier?

    ObjectXNeed is something I already have.

    I'm trying to create how much I have (ObjectAttributeX) on any given date, based on the information in this table: