Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

FillDown function based on a measure

Hey!    I am creating a dashboard that gives an overview of the current states of transaction accounts and it has to show every day (not just the current day). To create this we get information fro...
Need Help
JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi Bianca,

 

Can you show what the current visual looks like? It would help in understanding what you are trying to achieve. 

By the understanding that I have now, you want the total sum of every day in a matrix, or do you want every day added to the next day and show that in a matrix? 

Are you using a date table by any chance?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is the visual without the numbers (as I am not allowed to share them)... In the current situation, only cells that have transactions on that date are filled. For example, Account 1310 has transactions on 11/11 and on 18/11, those cells are filled (11/11 with an end amount and 18/11 with the end amount of 11/11 + transactions to form a new end amount). The cells in between are empty and should be filled with the data from the cell 11/11 without it interfering with the calculation of 18/11.