CONDITIONAL CASE SUM
Hi Sisense Community!! Please reference the attached workbook that I drafted in Excel. I am trying to draft a daily view by week, of each employee's time worked. This screenshot shows an example of actual hours worked by day by employee. I am trying to create a dynamic case statement for a metric that calculates the same way as is seen in K7 in the workbook. Essentially it would ready like this: SUM(TIME ON SUNDAY) + IF (TIME ON MONDAY = 0 THEN 0 ELSE TIME ON MONDAY) + IF(TIME ON TUESDAY = 0 THEN 0 ELSE TIME ON TUESDAY) + IF(TIME ON WEDNESDAY = 0 THEN 0 ELSE TIME ON WEDNESDAY) + IF(TIME ON THURSDAY = 0 THEN 0 ELSE TIME ON THURSDAY) + IF(TIME ON FRIDAY = 0 THEN 0 ELSE TIME ON FRIDAY) Any suggestions on how to get this case statement started through the first two lines? Many thanks in advance! -CarterSolved16KViews1like16Comments
How to Calculate YTD by Month in a pivot table
I have a pivot table that works for my team. It looks like this: The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget). I have received a request to expand this pivot (or create a new one based off of the data in this current one) that calculates the YTD for each of these fields. So, for example, I'm trying to build 3 new columns in the pivot table: March Budget YTD = January Budget + February Budget + March Budget March Revenue YTD = January Revenue + February Revenue + March Revenue March Variance YTD = March Revenue YTD - March Budget YTD I need these additional columns for each month, either added to this existing pivot table, or in a new one with a filter for the month the team wants to look at. Is this possible in a pivot table? I need to keep it split by Customer Type. How would I solve for this?Solved12KViews0likes2CommentsDYNAMICALLY FORMATTED DATA LABELS
Does anyone have suggestions on how to do the following: Script the data labels so that they never overlap? I'm not sure if that's possible but I can hope! Add additional formatting around the data labels similar to the screenshot below where each data label is surrounded in a colored shape?Solved11KViews1like12Comments
Advanced Filter Function
Hi Sisense Community! I am currently building a sales dashboard and would like to compare actual sales numbers and sales target. However, the data that I have for actual sales is only until the current date, but the sales targets are until end of year. Hence, my current dashboard has a lot of empty values in the 'Sales Amount' column, since the sales didn't happen yet (first screenshot). My goal is to filter out the 'Sales Target' values where the 'Sales Amount' column is still null. Is there a way to do so with the help of an advanced filter? Thank you 🙂Solved9.7KViews0likes4Comments
Show blank values in pivot table instead of not showing line at all
Hi, In the data model I have main table that is linked to another table using an index. Not all rows exists on the other table. When I try to display in the Pivot table column from the other table it omits from the table the non linked rows. Is there a way to display all rows even if not exists in the other table? I know I can do data model manipulation such as Join tables, but I wish to solve this at the dashboard level.Solved9.4KViews0likes4Comments
Let viewers remove their starred filters
Hi all, Through the REST API it's possible to give viewers access to starred filters and also let's them create those filters themselves. However, they do not have the option to overwrite/remove those starred filters. Is this possible? Or could this become a feature? Kind regards!9.2KViews0likes9CommentsUse of Conditions in BloX
I am attempting to use Conditions in a BloX widget. Unfortunately, the documentation for this feature is not very thorough and doesn't cover my use case. I am building a table. Each row has two columns, a label and a value. For each row in the table, I want to check the value and if it is below a certain amount, I want to hide the complete row. Basically, I want to set the style to "Display": "none" for that item in the container. In the attached snip, I want to hide the item that begins on line 41 because CountTotal2017 has a negative value. I have searched for documentation on using Conditions in BloX and pretty much everywhere it gives the same basic example of changing a text's color and changing which image to display. If anyone knows how to accomplish what I need, or can point me to more thorough documentation on the feature, I would greatly appreciate a reply. TIA.Solved9.1KViews0likes7Comments