Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Display each day only once

Hello, I'm using a matrix display with workweek (weeknum.weekday) as columns using the equation WW = FORMAT(WEEKNUM([timestamp],2),"General Number") & "." & WEEKDAY([timestamp],2) If there are mul...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous something I'm missing here,please share sample data and if there are more than one tale shre relationship diagram, and also what measure you are using in matrix/

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous works for me, just added ww and new measure you provided earlier.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    That's really strange.   Under visual level filters for WW, it shows that there's only a single WW 18.5 as well, but it still subbornly displays a duplicate WW 18.5 value

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous yes, that's why i'm having hard time understanding why it is showing duplicate, try new matrix visual, or open/close file, or just start new file, very hard to pin point what is the actual issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Not sure if it makes a difference, but the measures are pulled from different tables.  They're all in the same format as the one with cb and cs I sent previously, and display summations of values from the exact same timestamp.   All the timestamps from different tables are identical though - data from different tables are all uploaded with identical timestamps recorded.