rahul93 Contributor

Your question is a bit unclear. For the last 12 months calculation, you can do something like this: sum(case when `your_date_field` >= dateadd(`your_date_field`, interval -1 year) and `your_date_field` <= `your_date_field` then `total_value` else 0 end)/365 Your second part is not clear. If there are 28 days of the month…

As of now this is not possible. For the first part of your question you can create a table or just let the user click and go to the data underneath. But you cannot make any changes to this dataset for it to make any changes in the first level chart/card. I am not aware of any solutions/custom apps that provide this…

Hi, I would do it in the description part of the card. if anyone hovers on the title then it pops up to show the description where you could mention your important facts regarding the cards. Thanks,

Did you figure this out?

Oh! So if its the last day of the month, i think it shows you the changes that gradually made the number what it was when the alert is set to trigger. Do you think that could be the case? Like i said its a little tricky to understand whats going on if you dont monitor it between 2 alerts.

Hi, I have been playing with alerts a lot recently, it is a tricky beast to understand. But as a FYI, alerts get triggered when the dataset loads/reloads. I am not sure what the issue could be here as it depends on the dataset. But, if you are using a beast mode to sum the values of the calculated field then i think that…

Hi, You may want to find a field that groups them together i.e a field which has the same records/value for both the points. Put that field on the x axis and then if you click on the point it will show data for both points. Another way to do this would be when you click on one of the points and you go to the drill down…

Hi, Transforms in the workbench only have limited (of which some you may not be able to do in a dataflow) features like formatting a date field, encrypting the data for some users etc. Whereas transformations in a dataflow can manipulate the data like in sql which can include changing the format of date, making some…

you could do select *, case when `zipcode` in (......) then '36061' end as fips from transform_data_1 Reduces the number of lines.

@Huawrote:It has been bothering several of us, everytime we see a lower case "k" or "m" as abbreviate of a big number. Please change it to upper case. One way to do it would be to concatenate the value and putting the 'M' in the Concat function. Example : Concat('$ ', `total_value`, 'M')

No Problem!

Hi, You can create another column that has the count(member_id) for all members in all records. Now, for the target value you can use a max on this new field. You cannot do this using a beast mode as the filters will apply to all the fields/records in the card and therefore will also affect the beast mode. 

Hey, I am not sure what you mean by a 45 degree line. If you mean horizontal line you can do so by going to the quadrant lines option and setting a value on the y axis scale. This will give you a horizontal fixed line based on the values you are using on your y axis. Hope this helps. ? 

Your question is not clear. I am assuming Total is an aggregation of all the series. If you want to exclude some number of series and show the same total amount, then you cannot do it. You can cluster the series you want to exclude into one and name it something or add them to one of the series you want to include. Its not…

As of now it is not possible. The closest you can get to doing that , is to create a bullet chart. That has 1 solid line for plan and a secondary bar that covers the total bar which can denote last years value.

If you want to see all the data, then you will have to export the table card (drill down) to a spreadsheet. For some time now, the data that is shown in the table cards has been limited.

Hi Scott, thank you for replying. Yes, it is true that can be done in a line and bar chart. Although, we have a requirement where we would like to do the same in a line chart. So, should i consider that it cannot be done?

There is no issue with saving the card. I can save the card but if i try to add another filter after that then it crashes. But if i close and reopen the card it has the 20 filters that were there before the crash. 

There is a threshold of 20 filters, if the user attempts to add another above 20 then the card crashes. Thanks

@ckwright If there is no max limit to the number of quick filters, then why does the card keeps crashing whenever it exceeds 20 filters?

Never happened to me. Probably they must have turned that setting off or something like that, because i have never ever seen that. \

You can see all the cards related to the dataset if you have access to the pages on which the cards lie. I generally being an 'admin' add those pages under my profile and then i can see those cards under the cards section when i click on the dataset. If they could change this to an admin can see every card related to the…