Comments
-
I got the formula to work in a Sumo card! Thanks @ST_-Superman-_ .
-
It's two data sets with slightly different data in them. I'm not combining them but want two separate cards. Sorry that it was confusing. There are other columns in the project data but are not necessary for the output. I could have just as easily summed it up in the ETL as I did with the other forecast list.
-
All I want is a single bar chart for each of the data sets. I've attached a simplified sample of the two data sets. I may want to make a sumo card also.
-
Thank you for all the input. I wasn't sure what to do with the formula from @ST_-Superman-_ but as I was adding it in Beast Mode and looking at the card filters, I found that there is a filter for Next 12 months. Hope that it updates next month. The only way I've been able to keep learning is to read or ask questions in…
-
Thanks again.
-
That's wonderful! Thank you.
-
Yes I did miss that detail. I have learned much. Thank you.
-
That's what I can't find. This is the transform step.
-
Thank you both for your answers. Yes there were zeros in my column. I am doing my first SQL dataflow to convert that column but am having difficulty with the steps. I've watched the videos which don't match what I'm seeing and the articles don't have enough detail. I created a transform and it validates. SELECT…
-
I have two cases open regarding the data. I was looking for anyone who is actually using what is currently available. The data I need are not there or not complete so I want to know if it is valuable to others and how they are using it.
