Dheeraj_1996 Member

yes, I am doing this. but this fetches -ve value when records decrease. I only want +ve entries so I am converting things to 0 when -ve. but then it is giving issue

No it isn't giving the desired result. it is populating all the records.. but i need the difference from today to yesterday. In my beastmode I am getting the correct figures, but the subtotal is incorrect. the subtotal when -ve is also converting to 0.

No this does not help, My dataset has multiple error codes for every day and aggregated records in it.

Yes, I created a new beast mode and added it to the filter. While saving the card it is giving the error

thanks a lot.. this helped but this still shows duplicate entries. How do I get single entry for that day?

any other way to add up the minutes for particular day?

This is not working. I shared the card with the other person, still it gives the same error

HI, I am using the below format for the date transformation. but not giving the proper format. CONCAT(CASE WHEN split_part(`auditdate`- `submitdate`,' ',1) * 1 = split_part(`auditdate`- `submitdate`,' ',1) THEN CONCAT(ABS(split_part(`auditdate`- `submitdate`,' ',1)), ' days ') ELSE '' END, RIGHT(split_part(`auditdate`-…

My dataset loads every morning at 3AM, and it appends all the data in it by date.. I want to see how many files, records I have received in that particular day. lets say I have 3 files today in the dataset and 1 file yesterday. I have received 2 files today..

thanks, through this I could achieve a part. but not the entire stuff. I used test dataset and this is what your solution achieved How would I be able to fetch row 2?

But in the text card, the issue was that, only the 1st row of the dataset is being fetched. not all rows.

I tried the domo notebook, but I was not able to add the data from the dataset in it. is there a way this can be done? and does the DOMO PPT plugin fetches notebook in the PPT? where can I find the DOMO blank Brick?

that I am already using. but I want to create a card or a visualization in the below format from the dataset which is fed from the excel. Data with bullet points

Agreed with your points, our visualization should not show the two big chunks of inflows and outflows. we want a visualization which will give the total backlogs even if we change the date of the graph.. the backlog tickets should be incremental in nature. eg: if I have 1 tickets in 1st week, 2 tickets in 2nd week.. the…

Hi Marcel, Thanks for your response, in our case when we apply the above condition the entire data in dataset gets affected. The inflow and the outflow column are getting affected. We only want the running total for the Backlog count. Can you please suggest?

I meant it should show all the pending items from the time data set was developed.

The issue is that, the count of backlog should be incremental as per week. Example: The backlog should be the total open tickets present in the week from the beginning. in the card it shows only for that week.

HI Guys, not receiving the desired results. :(

Hi Mark, thanks this worked for one of the rows. But for other row it is not working where the day is 0. can you please help.